Database - RAC/Scalability (MOSC)

MOSC Banner

Is it possible to explicitly set resource TARGET status to OFFLINE on one of the node out of 2 node

edited Dec 6, 2013 4:15AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered
1. Created seperate local listeners for each node
2. Registered them in cluster

Is it possible to set TARGET value to OFFLINE for these local listener?

--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER1_LOCAL.lsnr
               ONLINE  ONLINE        ora001  --> Should be ONLINE and running noed1
               ONLINE  OFFLINE      ora002     --> Need to set TARGET status to OFFLINE on node2

ora.LISTENER2_LOCAL.lsnr
               ONLINE  OFFLINE      ora001  --> Need to set TARGET status to OFFLINE on node1
               ONLINE  ONLINE       ora002  --> Should ONLINE and running on node2

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