RELOACATE SCAN LISTENER AND SCAN VIP IN 3 NODE RAC
We are using oracle 11.2.0.3.0 with 3 node rac. Earlier 3 scan vip and 3scan listener running on each node.But we found recently node1 running using 2vip and 2scanlistener
and in node2 1vip and 1scanlisteners were running. But in GRID CONTROL the status was down beacause GRID thinks de SCANLISTENERS are running on different nodes, Oracle said its a BUG.
When you can not patch the BUG and want a workaround do the following bellow.
If i decided to reloacate the scan vip/Scan_listener to node3 from ndoe 1 using below command, does it cause any impact on my transcation?
[oracle@nodeB ~]$ . oraset grid
The Oracle base has been set to /u01/app/oracle
[oracle@nodeB ~]$ srvctl status scan_LISTENER
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node nodeB
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node nodeC
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node nodeA
[oracle@nodeB ~]$ srvctl relocate scan -i 1 -n nodeA
[oracle@nodeB ~]$ srvctl status scan_LISTENER
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node nodeA
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node nodeC
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node nodeA
