Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RAC database listener issue

vvcortazarOct 1 2010 — edited Oct 1 2010
Hi, I noticed something wrong in one of the two instances in my RAC database, when I run a listener status it only shows one node (the one running on the server I ran the listener status), but both instances are up, and the listener status on the other node the status shows both instances, here is the status output for the fist node:


Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date 27-SEP-2010 17:01:41
Uptime 4 days 1 hr. 20 min. 12 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /opt/app/oracle/diag/tnslsnr/holler/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=holler)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.212.75.29)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "NOD01" has 1 instance(s).
Instance "NOD012", status READY, has 1 handler(s) for this service...
Service "NOD01XDB" has 1 instance(s).
Instance "NOD012", status READY, has 1 handler(s) for this service...
Service "nod01_rac" has 1 instance(s).
Instance "NOD012", status READY, has 1 handler(s) for this service...
The command completed successfully


and for the second node:


LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 01-OCT-2010 18:24:32

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 Solaris: Version 11.2.0.1.0 - Production
Start Date 22-SEP-2010 11:28:27
Uptime 9 days 6 hr. 56 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /opt/app/oracle/diag/tnslsnr/hod/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hod)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.212.75.30)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.212.75.26)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "NOD01" has 2 instance(s).
Instance "NOD011", status READY, has 2 handler(s) for this service...
Instance "NOD012", status READY, has 1 handler(s) for this service...
Service "NOD01XDB" has 2 instance(s).
Instance "NOD011", status READY, has 1 handler(s) for this service...
Instance "NOD012", status READY, has 1 handler(s) for this service...
Service "nod01_rac" has 2 instance(s).
Instance "NOD011", status READY, has 2 handler(s) for this service...
Instance "NOD012", status READY, has 1 handler(s) for this service...
The command completed successfully


I restarted both listeners and the issue persists? what could be wrong on the configuration for the fist node?

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2010
Added on Oct 1 2010
1 comment
393 views