返回顶部
首页 > 资讯 > 错误编码 >ORA-12514: TNS:listener does not currently know of service requested in connect descriptor ORACLE 报错
  • 379
分享到

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

报错故障TNS 2023-11-05 05:11:44 379人浏览 泡泡鱼
摘要

文档解释 ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Cause: The listener rece

文档解释

ORA-12514: TNS:listener does not currently know of service requested 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 service name for a service (usually a database service) 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 services are currently known by the listener by executing: lsnrctl services
– Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.
– If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener.
– Check for an event in the listener.log file.

这个错误表明,数据库实例没有注册到监听器中,客户连接时,未能找到请求的服务。

官方解释

常见案例

1. 数据库实例名称发生了变化,但未及时将新的实例名称注册到监听器中,此时客户端会收到这个错误;

2. 用户填写了错误的实例名称,或使用不正确的连接串,同样会报这个错误;

3. 数据库实例没有启动时也同样会报这个错误(因为实例没有注册到监听器中)。

正常处理方法及步骤

1. 确认数据库实例已经正确启动;

2. 确认tnsnames.ora文件配置的正确;

3. 如果以上都没有问题,使用lsnrctl status命令查看监听参数,查看与要连接的实例是否注册到监听器中,如果没有,使用lsnrctl reload修改重新加载监听器参数即可。

--结束END--

本文标题: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor ORACLE 报错

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

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

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

  • 微信公众号

  • 商务合作