CRS-05020 Not all endpoints are registered for listener string

deal with production issue of CRS-05020 with 2 – Node Oracle RAC.

--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        OFFLINE OFFLINE          Not all endpoints are registered for listener string
CRS-05020 Not all endpoints are registered for listener string
Cause: Check listener log file for that listener.
Action-1 Listener agent failed to register all endpoints to listener.

Team had checked that scan listener log
export ORACLE_HOME=/u01/app/11.2.0/grid
lsnrctl status LISTENER_SCAN1

tail -100f $ORACLE_HOME/diag/tnslsnr/$ORACLE_SID/listener_scan1/trace/listener_scan1.log

logs shown that object not exists means scan ip is not available on either nodes
we had cross checked
ifconfig -a from both the nodes

$srvctl stop scan_listener

succeed

$srvctl stop scan
PRCR-1065 : Failed to stop resource ora.scan1.vip
CRS-2675: Stop of ‘ora.scan1.vip’ on ‘ecklpcrf01’ failed

not succeed

I thought that we should check Oracle Metalink …

I had follow the steps mentions in Oracle Metalink document-Doc ID952903.1

How to update the IP address of the SCAN VIP resources (ora.scan{n}.vip) (Doc ID952903.1)

we came to idea to manually – add the temporary ip in node1 as below cmd

ifconfig bond0:3 10.80.XXX.XXX netmask 255.255.255.224 up

$srvctl start scan
$srvctl start scan_listener

This time error is gone
🙂

--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       node02

It seem that issue is resolved but

This is not the permanent solution again.
because no post reboot scan will not working and same issue again.

$srvctl stop scan_listener

succeed

$srvctl stop scan
PRCR-1065 : Failed to stop resource ora.scan1.vip
CRS-2675: Stop of ‘ora.scan1.vip’ on ‘ecklpcrf01’ failed

not succeed

we have to have fixed this issue before going to use scan with application.

srvctl stop scan_listener
srvctl stop scan
PRCR-1065 : Failed to stop resource ora.scan1.vip
CRS-2675: Stop of ‘ora.scan1.vip’ on ‘ecklpcrf01’ failed

srvctl remove scan
Remove the scan? (y/[n]) y
PRCS-1024 : Failed to remove Single Client Access Name Virtual Internet Protocol(VIP) resources ecklpcrf-scan
PRCR-1025 : Resource ora.scan1.vip is still running

srvctl remove scan -f

crsctl stat res -t
:)done there were no scan resource in this command output – Oracle 11g R2 cluster without scan 🙂

ifconfig bond0:3 10.80.184.205 netmask 255.255.255.224 down

srvctl add scan -n racscan
crsctl stat res -t

ora.LISTENER_SCAN1.lsnr
      1        OFFLINE OFFLINE
ora.scan1.vip
      1        OFFLINE OFFLINE

srvctl start scan
srvctl start scan_listener
crsctl stat res -t

ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       node02
ora.scan1.vip
      1        ONLINE  ONLINE       node02

srvctl stop scan_listener
srvctl start scan_listener -n node01
crsctl stat res -t

ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       node01
ora.scan1.vip
      1        ONLINE  ONLINE       node01

tnsnames.ora
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racscan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

$ sqlplus scott/******@orcl
working
🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.