我在与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
Oracle试图告诉你这部分是错误的:
(SERVICE_NAME = ocp36t)
我们在本地运行的应用程序遇到以下错误: ORA-12514:TNS:侦听器当前不知道连接描述符中请求的服务 我使用测试了连接,该连接正确解析,并尝试尝试连接,但失败,错误与上面相同。对于,我使用了以下语法: null 我们不知道对这种环境进行了任何改变。我们还能测试什么吗?
ORA-12514 TNS:侦听器当前不知道连接描述符中请求的服务 我检查了listener.ora和tnsnames.ora,没有找到错误。 Listener.ora 请帮忙。
检查下面的配置。如何配置才能使其发挥作用?
当我尝试通过SQLDeveloper或我的java应用程序连接到oracle时,我得到以下错误,尽管我能够从SQLPLUS(命令行工具)连接 每当我做系统重新启动时,我都会遇到这个问题。虽然系统重新启动后10次中有1次,但我能够成功连接。 我可以看到所有的oracle服务,包括<code>OracleOraDb11g_home1TNSListener</code>都在服务部分。仅供参考,我的SID
嗨,我已经在我的笔记本电脑上安装了来练习Oracle。我已连接到 HR 帐户。它已经连接了3天,但是在那之后,当我尝试通过SQL Developer连接时,我收到此错误: