TNS-12514: TNS:侦听器当前不知道连接描述符4/2016中请求的服务

Question

尝试从SQL Developer或Net Manager连接到新安装的Oracle Enterprise时出现此错误。我确实尝试了我能找到的每一个解决方案，但都没有成功。

我正在尝试使用系统帐户进行连接，并且能够使用sqlplus登录，因此我知道我的凭据是正确的。

listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\OracleUser\product\12.1.0\dbhome_2\bin\oraclr12.dll")
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\Oracle\OracleUser\product\12.1.0\dbhome_2)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = C:\Oracle\OracleUser\product\12.1.0\dbhome_2\log

tnsnames.ora

LISTENER_ORCL = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

...\product\12.1.0\dbhome_2\log\diag\tnslsnr\iper410a\listener\trace\listener.log内部错误

24-APR-2016 19:10:33 * (CONNECT_DATA=(CID=(PROGRAM=null)(HOST=__jdbc__)(USER=null))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1195)) * establish * orcl * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
24-APR-2016 19:10:40 * (CONNECT_DATA=(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=my_windows_login))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1198)) * establish * orcl * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

令我困惑的是，错误是列出了我的windows登录帐户(my_windows_login)，而不是‘系统’Oracle帐户。

敬请指教！

Answer 1

看来你有两个神谕之家。

检查cmd -> tnsping orcl命令的输出。您可以查看正在使用的是哪个oracle目录。

然后，您可以检查环境变量、->系统变量、Oracle主目录路径，并对->主目录进行重新排序。这在我的案例中起作用了。