Database Networking (MOSC)

MOSC Banner

SCAN Listener issue in 11gr2

edited Jun 22, 2015 8:51AM in Database Networking (MOSC) 7 commentsAnswered

Hi All,   GOOD DAY.

I have two node  RAC. When I try to connect with DB, connections are only possible with NODE2. I am unable to connect with NODE1.

TNS Client entry:

RAC=

  (DESCRIPTION=

    (ADDRESS=

      (PROTOCOL=TCP)

      (HOST=xxx.yyy.zz.44)

      (PORT=1521)

    )

    (CONNECT_DATA=

      (SERVER=dedicated)

      (SERVICE_NAME=rac.localdomain)

    )

  )

where xxx.yyy.zz.44 is SCAN IP.

When I execute following command on DB server. It shows instance rac1 state BLOCKED.

[grid@rac2 ~]$  lsnrctl services listener_scan1

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 10-JUN-2015 18:03:11

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))

Tagged:

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