Database - RAC/Scalability (MOSC)

MOSC Banner

Listener on the second node is not accepting connection

edited Sep 4, 2017 7:27AM in Database - RAC/Scalability (MOSC) 16 commentsAnswered

Hello All,

I have a RAC 11gR2 database on RHEL 6 with 2 nodes.Instance is up on the First node but not up on the second Node. Please, find below:

oragrid@node02 $ srvctl status database -d orcl
Instance orcl1 is running on node node01
oragrid@node02 $

Above is meant to show both node01 and node02.

I checked listener on both node and discover that listener on node 2 is not accepting connection.

The Listener status on both node reads

NODE 1

oragrid@node1 $ lsnrctl status


LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 21-NOV-2015 16:18:40


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                21-NOV-2015 13:12:27
Uptime                    0 days 3 hr. 6 min. 13 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/64bit/oracle/11.2.0/grid/network/admin/listener.ora
Listener Log File         /opt/64bit/oracle/base/diag/tnslsnr/node1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.68.1.24)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.68.1.20)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.68.1.22)(PORT=1522)))
Services Summary...
Service "ORCL" has 2 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
  Instance "ORCL1", status READY, has 2 handler(s) for this service...
Service "ORCLXDB" has 1 instance(s).
  Instance "ORCL1", status READY, has 1 handler(s)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center