navicat连接oracle报错ORA-28547:connection to server failed,probable Oracle Net admin error
程序员文章站
2024-03-13 16:35:15
...
使用navicat在连接本地oracle的时候报下面这个错误:
ORA-28547:connection to server failed,probable Oracle Net admin error
上网搜索了下解决方法:
把listener.ora文件里面的给注释掉就好:
(PROGRAM = extproc)
navicat连接oracle的过程中有两个重要的问价:tnsname.ora和listener.ora
下面附上两个文件的配置:
#listener.ora
local =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = orcl)
)
)
#tnsname.ora
# listener.ora Network Configuration File: D:\software\myoracle\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = D:\software\myoracle\oracle\product\11.2.0\dbhome_1)
#(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\software\myoracle\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\software\myoracle\oracle
上一篇: JSF标签选择器
下一篇: 最常使用linux命令
推荐阅读
-
navicat连接oracle报错ORA-28547:connection to server failed,probable Oracle Net admin error
-
报错ORA-28547:connection to server failed,probable Oracle Net admin error
-
navicat15 RA-28547:connection to server failed, probable Oracle Net admin error
-
遇到connection to server failed, probable Oracle Net admin error问题的解决办法
-
报错ORA-28547:connection to server failed,probable Oracle Net admin error
-
navicat15 RA-28547:connection to server failed, probable Oracle Net admin error
-
解决connection to server failed, probable Oracle Net admin e
-
解决connection to server failed, probable Oracle Net admin e
-
遇到connection to server failed, probable Oracle Net admin error问题的解决办法