当前位置: 首页 > 知识库问答 >
问题:

Toad for oracle--ORA-12514:TNS:侦听器当前不知道连接描述符中请求的服务

单昊穹
2023-03-14

我在与Toad for Oracle连接时得到了这个错误。

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Items Checked
TNS_ADMIN environment variable is defined as "D:\app\oracle\product\12.1.0\client_1\Network\Admin"
D:\app\oracle\product\12.1.0\client_1\Network\Admin\tnsnames.ora was located
The following connect descriptor was found for OCP36T in the tnsnames.ora file
     ocp36t =
        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = lx-cpora-t01k.lmig.com)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = ocp36t) 
        )
        )
      D:\app\oracle\product\12.1.0\client_1\Network\Admin\sqlnet.ora was located
NAMES.DIRECTORY_PATH specifies TNSNAMES in the sqlnet.ora file
Steps to Take
If the database was just started wait a few moments and try again as the database may be initializing
Verify that the connect descriptor for OCP36T has the correct SERVICE_NAME or SID component in the tnsnames.ora file
Verify that the listener is properly configured and that the database is registered with the listener

共有1个答案

汝臻
2023-03-14

Oracle试图告诉你这部分是错误的:

(SERVICE_NAME = ocp36t)
 类似资料: