CNDBA社区
RAC 集群安装好后，会有2个监听：LISTENER 和 LISTENER_SCAN1：
[grid@cndba1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE cndba1
ONLINE ONLINE cndba2
ora.FRA.dg
ONLINE ONLINE cndba1
ONLINE ONLINE cndba2
ora.LISTENER.lsnr
ONLINE ONLINE cndba1
ONLINE ONLINE cndba2
ora.OCR.dg
ONLINE ONLINE cndba1
ONLINE ONLINE cndba2
ora.asm
ONLINE ONLINE cndba1 Started
ONLINE ONLINE cndba2 Started
ora.gsd
OFFLINE OFFLINE cndba1
OFFLINE OFFLINE cndba2
ora.net1.network
ONLINE ONLINE cndba1
ONLINE ONLINE cndba2
ora.ons
ONLINE ONLINE cndba1
ONLINE ONLINE cndba2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE cndba2
ora.cvu
1 ONLINE ONLINE cndba1
ora.cndba.db
1 ONLINE ONLINE cndba1 Open
2 ONLINE ONLINE cndba2 Open
ora.cndba1.vip
1 ONLINE ONLINE cndba1
ora.cndba2.vip
1 ONLINE ONLINE cndba2
ora.oc4j
1 ONLINE ONLINE cndba1
ora.scan1.vip
1 ONLINE ONLINE cndba2
通过这2个监听都可以连接到数据库，但他们之间是有区别的， 在没有使用DNS的情况下，SCAN IP 并不能真正的起到设计的作用，该IP 会飘在某个节点上。 比我们这这里是飘在节点2上。
此时如果我们在节点1上查询 LISTENER_SCAN1 的状态，会提示不存在，如下：
[grid@cndba1 ~]$ lsnrctl status listener_scan1
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 25-APR-2022 22:08:35
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
[grid@cndba1 ~]$
在节点2上就可以正常查询：
[grid@cndba2 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 25-APR-2022 22:06:28
Copyright (c) 1991, 2013, 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.4.0 - Production
Start Date 24-APR-2022 09:20:52
Uptime 1 days 12 hr. 45 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/gridsoft/11.2.0/network/admin/listener.ora
Listener Log File /u01/gridbase/diag/tnslsnr/cndba2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=198.198.198.32)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=198.198.198.34)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "cndba" has 1 instance(s).
Instance "cndba2", status UNKNOWN, has 1 handler(s) for this service...
Service "cndbaXDB" has 2 instance(s).
Instance "cndba1", status READY, has 1 handler(s) for this service...
Instance "cndba2", status READY, has 1 handler(s) for this service...
Service "cndba_st" has 2 instance(s).
Instance "cndba1", status READY, has 1 handler(s) for this service...
Instance "cndba2", status READY, has 2 handler(s) for this service...
The command completed successfully
[grid@cndba2 ~]$ lsnrctl status listener_scan1
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 25-APR-2022 22:06:36
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 23-APR-2022 21:23:02
Uptime 2 days 0 hr. 43 min. 34 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/gridsoft/11.2.0/network/admin/listener.ora
Listener Log File /u01/gridbase/diag/tnslsnr/cndba2/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=198.198.198.35)(PORT=1521)))
The listener supports no services
The command completed successfully
[grid@cndba2 ~]$
版权声明：本文为博主原创文章，未经博主允许不得转载。
