In the system patrol, found that the backup of the database is not properly backed up, aware that it may be a problem monitoring, through the database RAC management users to see the RAC1 VIP stopped working.
Oracle11gr2_rac for_redhat6.3
The process is as follows:
1 perform crs_stat-t with grid user to view RAC running status, obviously ORA.RAC1.VIP display offline
Name Type Target State Host
------------------------------------------------------------
Ora. DATADG.DG ora....up.type Online Online Rac1
Ora .... Er.lsnr ora....er.type Online Online Rac2
Ora .... N1.lsnr ora....er.type Online Online Rac1
Ora .... TEDG.DG ora....up.type Online Online Rac1
Ora.asm ora.asm.type Online Online Rac1
ORA.CVU ora.cvu.type Online Online Rac1
ORA.GSD Ora.gsd.type OFFLINE OFFLINE
Ora....network ora....rk.type Online Online Rac1
ora.oc4j ora.oc4j.type Online Online Rac1
Ora.ons ora.ons.type Online Online Rac1
Ora .... Sm1.asm Application Online Online Rac1
Ora .... C1.lsnr Application ONLINE OFFLINE
ORA.RAC1.GSD Application OFFLINE OFFLINE
Ora.rac1.ons Application Online Online Rac1
ORA.RAC1.VIP Ora....t1.type ONLINE OFFLINE
Ora .... Sm2.asm Application Online Online RAC2
Ora .... C2.lsnr Application Online Online RAC2
ORA.RAC2.GSD Application OFFLINE OFFLINE
Ora.rac2.ons Application Online Online RAC2
Ora.rac2.vip ora....t1.type Online Online Rac2
Ora.scan1.vip ora....ip.type Online Online Rac1
Ora.sgtms.db ora....se.type Online Online Rac1
2 Execute the following command (here to enter the corresponding command according to the actual situation, the following is the command to start the RAC1 VIP)
Srvctl Start Vip-n Rac1
4 Confirm again, see the corresponding VIP online is the normal work
Occasionally there is a database can not be connected with Plsql, the alarm is not started to monitor the error, the troubleshooting steps, you can be sure that SCANVIP stop working
Execute srvctl start Scan_listener start listening wait for about 10 seconds, then look at the output status, troubleshoot the problem
Fix for VIP exception in Oracle RAC Environment