rac监听不支持服务 The listener supports no services

月亮星辰入眼

已于 2023-01-10 21:45:44 修改

阅读量2.1k

点赞数 1

分类专栏： Oracle 文章标签：数据库 linux

于 2023-01-10 20:39:13 首次发布

本文链接：https://blog.youkuaiyun.com/lambto/article/details/128635368

版权

今天发现集群掉了一个监听，但是rac1，rac2都能连上DB。检查发现是grid用户监听掉了。
检查状态发现监听不支持服务，猜测是监听服务问题。一一排查。
1.检查集群监听状态：

[grid@rac101 ~]$ lsnrctl status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                10-JAN-2023 15:21:20
Uptime                    0 days 0 hr. 28 min. 38 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/12.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/rac101/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
The listener supports no services
The command completed successfully

最后两排发现The listener supports no services。

2.检查集群资源

[grid@rac101 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       rac101                   STABLE
               ONLINE  ONLINE       rac102                   STABLE
ora.DATA.dg
               ONLINE  ONLINE       rac101                   STABLE
               ONLINE  ONLINE       rac102                   STABLE
ora.FLARC.dg
               ONLINE  ONLINE       rac101                   STABLE
               ONLINE  ONLINE       rac102                   STABLE
ora.LISTENER.lsnr
               ONLINE  INTERMEDIATE rac101                   Not All Endpoints Re
                                                             gistered,STABLE
               ONLINE  ONLINE       rac102                   STABLE
ora.MGMT.dg
               ONLINE  ONLINE       rac101                   STABLE
               ONLINE  ONLINE       rac102                   STABLE
ora.OCR.dg
               ONLINE  ONLINE       rac101                   STABLE
               ONLINE  ONLINE       rac102                   STABLE
ora.chad
               ONLINE  ONLINE       rac101                   STABLE
               ONLINE  ONLINE       rac102