Repair of vip exception in oracle RAC environment
During the system inspection, we found that the backup of the database was not completed normally, and realized that there might be something wrong with the monitoring. Through the database rac management user to check, we found that the vip of rac1 stopped working.
Oracle11gR2_RAC for_redhat6.3
The processing is as follows:
1 use grid user to execute crs_stat-t to check the running status of rac, and it is obvious that ora.rac1.vip shows 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, enter the corresponding command according to the actual situation, the following is the command to start the vip of rac1)
Srvctl start vip-n rac1
4 reconfirm. If you see the corresponding vip online, it means it is working properly.
Occasionally, the database cannot connect with plsql, and an error is reported that the monitoring has not been started. The troubleshooting steps are the same as above. It can be determined that the scanvip stops working.
Wait about 10 seconds to execute srvctl start scan_listener startup monitoring, and then look at the output status and troubleshoot the problem.
