We received complain from application team, that we are not able to do connect database. But when we checked, database is up and running fine. One database configured in one of the 2-Node RAC (11gR2 RAC cluster). From verification found VIP of that node is in "INTERMEDIATE and FAILED OVER" state. Listeners are running fine in both nodes.
So, the issue is, VIP was showing as INTERMEDIATE and FAILED OVER in one of RAC node
Checked crs the status and here is the sample output:
$ crsctl status resource -t
......
ora.example1a.vip
1 ONLINE ONLINE example1a
ora.example1b.vip
1 ONLINE INTERMEDIATE example1a FAILED OVER
$
-- Now Check that particular VIP status
[oracle@example1b ~]$ crsctl status resource ora.example1b.vip
NAME=ora.example1b.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=INTERMEDIATE on example1a
[oracle@example1b ~]$
-- Now stop the VIP
crsctl stop resource ora.example1b.vip
ora.example1a.vip
1 ONLINE ONLINE example1a
ora.example1b.vip
1 OFFLINE OFFLINE
-- Start the VIP
crsctl start resource ora.example1b.vip
[oracle@example1b ~]$ crsctl start resource ora.example1b.vip
CRS-2672: Attempting to start 'ora.example1b.vip' on 'example1b'
CRS-2676: Start of 'ora.example1b.vip' on 'example1b' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'example1b'
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'example1b' succeeded
[oracle@example1b ~]$
-- Check the status now
ora.exmaple1a.vip
1 ONLINE ONLINE exmaple1a
ora.exmaple1b.vip
1 ONLINE ONLINE exmaple1b
Now it back to online.
No comments:
Post a Comment