1. Check if RAC is normal
[Oracle @ racdb01 ~] $ Crs_stat-T
Name type target State host
------------------------------------------------------------
Ora. RAC. DB application online racdb01
Ora... s1.inst application online racdb01
Ora... s2.inst application online racdb02
Ora... esdb. CS application online racdb01
Ora... es1.srv application online racdb01
Ora... es2.srv application online racdb02
Ora... 01. lsnr application online racdb01
Ora... b01.gsd application online racdb01
Ora... b01.ons application online racdb01
Ora... b01.vip application online racdb01
Ora... 02. lsnr application online racdb02
Ora... b02.gsd application online racdb02
Ora... b02.ons application online racdb02
Ora... b02.vip application online racdb02
2. Connect to the database and check the instance
Select instance_name from V $ instance;
Instance_name
--------------
Rac2
3. Test
Test 1
Remove the public network cable of rac2
Rac2 automatic reboot
[Oracle @ racdb01 ~] $ Crs_stat-T
Name type target State host
------------------------------------------------------------
Ora. RAC. DB application online racdb01
Ora... s1.inst application online racdb01
Ora... s2.inst application online offline
Ora... esdb. CS application online racdb01
Ora... es1.srv application online racdb01
Ora... es2.srv application online offline
Ora... 01. lsnr application online racdb01
Ora... b01.gsd application online racdb01
Ora... b01.ons application online racdb01
Ora... b01.vip application online racdb01
Ora... 02. lsnr application online offline
Ora... b02.gsd application online offline
Ora... b02.ons application online offline
Ora... b02.vip application online racdb01
Check the connection status and find that instance 1 is automatically connected.
Select instance_name from V $ instance;
Instance_name
--------------
Rac1
Refer to the original rac2 network, reboot rac2
[Oracle @ racdb02 ~] $ Crs_stat-T
Name type target State host
------------------------------------------------------------
Ora. RAC. DB application online racdb01
Ora... s1.inst application online racdb01
Ora... s2.inst application online racdb02
Ora... esdb. CS application online racdb01
Ora... es1.srv application online racdb01
Ora... es2.srv application online racdb02
Ora... 01. lsnr application online racdb01
Ora... b01.gsd application online racdb01
Ora... b01.ons application online racdb01
Ora... b01.vip application online racdb01
Ora... 02. lsnr application online racdb02
Ora... b02.gsd application online racdb02
Ora... b02.ons application online racdb02
Ora... b02.vip application online racdb02
Check the connection status and still connect to instance 1
Select instance_name from V $ instance;
Instance_name
--------------
Rac1
Test 2
Remove the public network cable of Rac1
Check the status and find that VIP1 is flowing to rac2
[Oracle @ racdb01 ~] $ Crs_stat-T
Name type target State host
------------------------------------------------------------
Ora. RAC. DB application online racdb01
Ora... s1.inst application online racdb01
Ora... s2.inst application online racdb02
Ora... esdb. CS application online racdb01
Ora... es1.srv application online offline
Ora... es2.srv application online racdb02
Ora... 01. lsnr application online offline
Ora... b01.gsd application online racdb01
Ora... b01.ons application online racdb01
Ora... b01.vip application online racdb02
Ora... 02. lsnr application online racdb02
Ora... b02.gsd application online racdb02
Ora... b02.ons application online racdb02
Ora... b02.vip application online racdb02
After two minutes, check the status again and find an exception. VIP1 & VIP2 are all down and the database cannot be used.
[Oracle @ racdb01 ~] $ Crs_stat-T
Name type target State host
------------------------------------------------------------
Ora. RAC. DB application online racdb01
Ora... s1.inst application online racdb01
Ora... s2.inst application online offline
Ora... esdb. CS application offline
Ora... es1.srv application online offline
Ora... es2.srv application online offline
Ora... 01. lsnr application online offline
Ora... b01.gsd application online racdb01
Ora... b01.ons application online racdb01
Ora... b01.vip application online offline
Ora... 02. lsnr application online offline
Ora... b02.gsd application online offline
Ora... b02.ons application online offline
Ora... b02.vip application online offline
Try to check the CRS status on rac2 and report an error. It is fruitless to manually start CRS.
[Oracle @ racdb02 ~] $ Crs_stat-T
CRS-0184: cannot communicate with the CRS daemon.
Test failed. Find the cause .......