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

最新推荐文章于 2025-08-13 14:11:28 发布

weixin_30701575

最新推荐文章于 2025-08-13 14:11:28 发布

阅读量46

点赞数

CC 4.0 BY-SA版权

文章标签：网络数据库

原文链接：http://www.cnblogs.com/168cuiyuan/p/5262622.html

本文介绍了解决Oracle数据库连接问题的方法，通过确保tnsnames.ora文件中的SERVICE_NAME配置正确，并提供了一个具体的配置示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

this issue and the fix was to make sure in tnsnames.ora the SERVICE_NAME is a valid service name in your database. To find out valid service names, you can use the following query in oracle:

select value from v$parameter where name='service_names'

Once I updated tnsnames.ora to:

TEST =
   (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = *<validhost>*)(PORT = *<validport>*))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = *<servicenamefromDB>*)
    )
)