提示错误为
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 弄了一晚还是不行,但用sqlplus能用,我只有100分解决了就全给了!!
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 弄了一晚还是不行,但用sqlplus能用,我只有100分解决了就全给了!!
贴出tnsnames.ora的内容和服务器监听文件的内容,或者列出sid内容。
例:tnsnames.ora的内容如下:
vis-dalian =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.254.161.***)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = VIS)
)
)
你的sql developer里的配置应该是:
选择SID的时候,配成:VIS,而不是vis-dalian.
或是用oracle客户端重新配置一下!
# Generated by Oracle configuration tools.ZXQ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zengxiangqi-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zxq)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)这是tnsname.ora的内容,我是新手,请问各位应该怎样改?
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = zengxiangqi-PC)(PORT = 1521))
)
)
看一下,现在监听的服务名是啥