Database - RAC/Scalability (MOSC)

MOSC Banner

Connection problems after SCAN / VIP relocation

edited May 21, 2012 7:54PM in Database - RAC/Scalability (MOSC) 10 commentsAnswered
Hello,

yesterday, after a "rolling reboot" of our 2 oracle database cluster nodes, several of our application developers had difficulties to connect to our database.
After rebooting, the VIPs and SCANs were each located on the wrong node, as the following output of crs_stat shows:

ora.scan1.vip               ora.scan_vip.type         ONLINE    ONLINE    node2o2
ora.scan2.vip               ora.scan_vip.type         ONLINE    ONLINE    node1o2
ora.LISTENER_SCAN1.lsnr     ora.scan_listener.type    ONLINE    ONLINE    node2o2
ora.LISTENER_SCAN2.lsnr     ora.scan_listener.type    ONLINE    ONLINE    node1o2

Relocating the resources adjusted this again:

srvctl relocate scan -i 2 -n node2o2

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