Toad for oracle -- ORA-12514:TNS:listener does not currently know of service requested in connect descriptor

19 浏览
0 Comments

Toad for oracle -- ORA-12514:TNS:listener does not currently know of service requested in connect descriptor

当使用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

admin 更改状态以发布 2023年5月24日
0
0 Comments

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

(SERVICE_NAME = ocp36t)

0