返回顶部
首页 > 资讯 > 错误编码 >ORA-12505: TNS:listener does not currently know of SID given in connect descriptor ORACLE 报错 故障修复 远程
  • 582
分享到

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor ORACLE 报错 故障修复 远程

报错故障TNS 2023-11-05 00:11:07 582人浏览 独家记忆
摘要

文档解释 ORA-12505: TNS:listener does not currently know of SID given in connect descriptor Cause: The listener received a r

文档解释

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a SID for an instance (usually a database instance) that either has not yet dynamically reGIStered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.

Action:
– Wait a moment and try to connect a second time.
– Check which instances are currently known by the listener by executing: lsnrctl services
– Check that the SID parameter in the connect descriptor specifies an instance known by the listener.
– Check for an event in the listener.log file.

ORA-12505: TNS: listener does not currently know of SID given in connect descriptor这是由于指定的服务名称/SID不正确导致的。官方解释,这个错误可能是由于客户端连接字符串中指定的 SID 不存在于服务器端的监听器配置文件中,而且它也有可能是在不兼容的驱动程序的情况下指定一个错误的端口号。

常见案例

1)服务器端没有正确配置SID导致:该错误是由于指定的SID不在tnsnames.ora文件中所致,或者该文件中有不正确的定义所致。

2)客户端没有正确配置TNSNAMES.ORA:客户端TNSNAMES.ORA文件中指定的服务名/SID不存在,或者指定的服务名/SID不正确。

3)客户端没有正确配置sqlplus.exe环境变量:在使用sqlplus运行sql语句时,与指定的tnsname相对应的环境变量没有被设置。

正常处理方法及步骤

1)检查服务器端TNSNAMES.ORA文件,确认文件内容正确。

2)检查客户端TNSNAMES.ORA文件,确认内容正确。

3)检查sqlplus.exe环境变量,确认设置正确。

4)重启服务器端进程,重新启动客户端进程。

--结束END--

本文标题: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor ORACLE 报错 故障修复 远程

本文链接: https://www.lsjlt.com/news/527506.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

猜你喜欢
软考高级职称资格查询
编程网,编程工程师的家园,是目前国内优秀的开源技术社区之一,形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容,为IT开发者提供了一个发现、使用、并交流开源技术的平台。
  • 官方手机版

  • 微信公众号

  • 商务合作