我从SQL Developer连接到oracle 12c时收到此错误,
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
我的 tnsnames.ora 文件内容是:
ORACLR_CONNECTION_DATA =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = IPC)(KEY = EXTPROC1521)))(CONNECT_DATA =(SID = CLRExtProc)(PRESENTATION = RO)))ORCL1 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.10)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl.abc.com)))ORCL =(DESCRIPTION =(ADDRESS =(PROTOCOL = TCP)(HOST = INT) .abc.com)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl.abc.com)))
我的 listener.ora 文件内容是:
SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = CLRExtProc)(ORACLE_HOME = C:\ app \ oracle \ product \ 12.1.0 \ dbhome_1)(PROGRAM = extproc)(ENVS =“EXTPROC_DLLS = ONLY:C:\ app \” oracle \ product \ 12.1.0 \ dbhome_1 \ bin \ oraclr12.dll“)))LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS =(PROTOCOL = TCP)(HOST = INT.abc.com)(PORT = 1521)) (ADDRESS =(PROTOCOL = IPC)(KEY = EXTPROC1521))))
我在sql developer "Add Connection"窗口中使用 Service Name 作为 'orcl1'
和 Host Name 作为 '10.10.1.10'
并获得上述错误 .
我可以使用带有正确用户名和密码的cmd连接到sqlplus . 任何帮助将不胜感激 .
2 回答
一旦我将 Service Name 更改为 "orcl.abc.com" ,我就可以连接到SQL Developer
好像你是使用orcl通过sqlplus连接的 . 检查你的主机名 . 在tnsnames.ora中,您使用的是int . abc.cm并且在监听器中你正在使用ipaddress . 尽量保持两者一致 . 将tnsnames.ora中的主机名更改为ipaddress .