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