Connection problems after SCAN / VIP relocation
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