If issuing “crsctl status
resource” command show the status of listener as “Not All Endpoints Registered”,
it is usually because of contradictions in the Listener settings. It means that
probably you have a manually setup listener (by editing listener.ora file) with
different settings than registered with the CRS/HAS. Or, there could be
multiple listeners configured from multiple oracle homes – one from Grid
Infrastructure home, and other listener with same configuration running from
other home and started manually (using lsnrctl command).
I faced this issue
because I had a listener “Listener” configured with CRS on port 1522, whereas
same “Listener” was also statically defined in the listener.ora of same GI
(Grid Infrastructure) home with port 1521.
[grid]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME
TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE INTERMEDIATE my_db_host Not All Endpoints Registered
ora.ORADATA.dg
ONLINE OFFLINE my_db_host
ora.ORAFRA.dg
ONLINE OFFLINE my_db_host
ora.asm
ONLINE ONLINE my_db_host Started
ora.ons
OFFLINE OFFLINE my_db_host
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE
my_db_host
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE
my_db_host
ora.opera.db
1
OFFLINE OFFLINE
[grid]$ srvctl config listener
Name: LISTENER
Home: /u01/app/11204/grid
End points:
TCP:1522
|
As you can see above, the
port of listener is set to 1522, however, my listener.ora file was configured
with port 1521. To fix this, I changed the port of my listener back to 1521 in
CRS configuration. You may consider changing port in listener.ora file to match
with the CRS configuration.
[grid]$ srvctl modify listener -l listener -p 1521
[grid]$ srvctl config listener
Name: LISTENER
Home: /u01/app/11204/grid
End points:
TCP:1521
|
Once done, restart of
listener solved the problem permanently.
[grid]$ srvctl stop listener
[grid]$ srvctl start listener
[grid]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME
TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE
my_db_host
ora.ORADATA.dg
ONLINE OFFLINE my_db_host
ora.ORAFRA.dg
ONLINE
OFFLINE my_db_host
ora.asm
ONLINE ONLINE my_db_host Started
ora.ons
…
…
…
|
No comments:
Post a Comment