客户端不能正常连接oracle，监听状态为"Not All Endpoints Registered"

最新推荐文章于 2025-03-13 11:22:58 发布

原创

最新推荐文章于 2025-03-13 11:22:58 发布 · 5.3k 阅读

本文探讨了当客户端无法正常连接Oracle数据库，监听状态显示为'Not All Endpoints Registered'时的排查方法。通过检查crsctl状态确保资源在线，参考ID 1454439.1的解决方案。

1,现象描述，应用反应不能正常
[grid@sdcmpdb1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 01-JUL-2013 16:39:49

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                01-JUL-2013 15:47:57
Uptime                    0 days 0 hr. 51 min. 52 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/11.2.0/grid/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/diag/tnslsnr/sdcmpdb1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
The listener supports no services
The command completed successfully

[grid@sdcmpdb1 ~]$ crsctl status