Service not registered with listener on one of the nodes?
We have an 11.2.0.1 oracle RAC with 2 nodes. Recently the listener died on node 1 and after a manual startup it seems like the service doesn't register with the listener on this node.
Here's what statusing the listener on both nodes shows:
[oracle@db01]$ $GRID_HOME/bin/lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-NOV-2010 12:27:49
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 17-NOV-2010 07:14:40
Uptime 0 days 5 hr. 13 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/db01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.128.4)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.128.14)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@db02 ~]$ $GRID_HOME/bin/lsnrctl status listener
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-NOV-2010 12:30:08
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 17-NOV-2010 07:14:40
Uptime 0 days 5 hr. 15 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/db02/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.128.5)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.128.15)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "prd1.somehost.net" has 1 instance(s).
Instance "prd12", status READY, has 1 handler(s) for this service...
Service "prd1XDB.somehost.net" has 1 instance(s).
Instance "prd12", status READY, has 1 handler(s) for this service...
The command completed successfully
The prd12 instance shows as registered with the listener on db02 but the prd11 doesn't on db01. Right now all connections are routed to the prd12 instance. Also trying to connect to prd11 manually returns "ORA-12505: TNS:listener does not currently know of SID given in connect descriptor". The prd11 instance is actually running and I can connect to it locally via 'sqlplis "/ as sysdba"' but not via 'sqlplus user/pass@prd1'. I'm wondering what went wrong and how to register the prd11 with the listener on db01.
Here's some more information
[oracle@db01 ~]$ $GRID_HOME/bin/srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node db02
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node db01
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node db01
[oracle@db01 ~]$ $GRID_HOME/bin/srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node db02
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node db01
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node db01
[oracle@db01 ~]$ $GRID_HOME/bin/srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): db01,db02
Thanks in advance,
Nick
Edited by: user639426 on Nov 17, 2010 4:44 AM