In order to test a migration scenario, a set of 10g RAC environments may have been a long time since the 10g RAC has been installed, and the whole process has been in progress.
1. After the cluster software and database software are installed, using Crs_stat detection status, the VIP status is not correct, ping Vipip not pass
[Email protected] ~]# CD $CRS _home
[Email protected] crs_1]# crs_stat-t
Name Type Target State Host
------------------------------------------------------------
ORA....G01.GSD Application Online Online rac10g01
Ora....g01.ons Application Online Online rac10g01
ORA....G01.VIP Application ONLINE OFFLINE
ORA....G02.GSD Application Online Online rac10g02
Ora....g02.ons Application Online Online rac10g02
ORA....G02.VIP Application ONLINE OFFLINE
2. Then use the command, Crs_start to start VIP, also error:
[Email protected] crs_1]# Crs_start ORA.RAC10G01.VIP
Attempting to start ' ora.rac10g01.vip ' on member ' RAC10G01 '
Start of ' ORA.RAC10G01.VIP ' on member ' RAC10G01 ' failed.
Attempting to start ' ora.rac10g01.vip ' on member ' RAC10G02 '
Start of ' ORA.RAC10G01.VIP ' on member ' RAC10G02 ' failed.
Crs-1006:no to consider
Crs-0215:could Not start resource ' ORA.RAC10G01.VIP '.
3. Check the following VIP's log: $CRS _home/log/$hostname/racg/ora.rac10g01.vip.log, inside the error:
2015-11-18 10:53:18.576: [racg][1470001856] [22927][1470001856][ORA.RAC10G01.VIP]: Wed Nov 10:53:18 CST 2015 [22932] /sbin/mii-tool eth0 Error
Wed Nov 10:53:18 CST [22932] defaultgw:started
Wed 10:53:18 CST [22932] defaultgw:completed with
Checkif:default Gateway is not defined (HOST=RAC10G01)
2015-11-18 10:53:18.576: [racg][1470001856] [22927][1470001856][ORA.RAC10G01.VIP]: Interface eth0 checked failed (host =RAC10G01)
Wed Nov 10:53:18 CST [22932] checkif:end for If=eth0
Invalid parameters, or failed to bring up VIP (HOST=RAC10G01)
2015-11-18 10:53:18.576: [racg][1470001856] [22927][1470001856][ORA.RAC10G01.VIP]: clsrcexecut:env ORACLE_CONFIG_ Home=/u01/app/oracle/crs_1
2015-11-18 10:53:18.576: [racg][1470001856] [22927][1470001856][ORA.RAC10G01.VIP]: Clsrcexecut:cmd =/u01/app/oracle /CRS_1/BIN/RACGEUT-E _usr_ora_debug=5 54/u01/app/
ORACLE/CRS_1/BIN/RACGVIP Start RAC10G01
2015-11-18 10:53:18.577: [racg][1470001856] [22927][1470001856][ORA.RAC10G01.VIP]: CLSRCEXECUT:RC = 1, time = 3.270s
2015-11-18 10:53:21.731: [racg][1470001856] [22927][1470001856][ORA.RAC10G01.VIP]: Wed Nov 10:53:18 CST 2015 [23007] Broadcast = 192.168.146.255
Wed Nov 10:53:18 CST [23007] Checking interface existance
Wed Nov 10:53:18 CST [23007] Calling Getifbyip
2015-11-18 10:53:21.731: [racg][1470001856] [22927][1470001856][ORA.RAC10G01.VIP]: Wed Nov 10:53:18 CST 2015 [23007] Getifbyip:started for 192.168.146.13
Wed Nov 10:53:18 CST [23007] getifbyip:returning IP
Wed Nov 10:53:18 CST [23007] completed Getifbyip
2015-11-18 10:53:21.732: [racg][1470001856] [22927][1470001856][ORA.RAC10G01.VIP]: Wed Nov 10:53:18 CST 2015 [23007] Calling Getifbyip-a
Wed Nov 10:53:18 CST [23007] getifbyip:started for 192.168.146.13
Wed Nov 10:53:18 CST [23007] getifbyip:returning IP
2015-11-18 10:53:21.732: [racg][1470001856] [22927][1470001856][ORA.RAC10G01.VIP]: Wed Nov 10:53:18 CST 2015 [23007] Completed Getifbyip
Wed Nov 10:53:18 CST [23007] Ping_vip 192.168.146.13 started
Wed Nov 10:53:21 CST [23007] ping_vip:192.168.146.13 is not pingable, _count = 1
4. In log, the VIP also shows that the ping does not pass. Debug the startup process:
[[email protected] bin]# crsctl debug Log res "Ora.rac10g01.vip:5"
Set Resource Debug Module:ora.rac10g01.vip level:5
[Email protected] bin]# Crs_start ORA.RAC10G01.VIP
Attempting to start ' ora.rac10g01.vip ' on member ' RAC10G01 '
Start of ' ORA.RAC10G01.VIP ' on member ' RAC10G01 ' failed.
Attempting to start ' ora.rac10g01.vip ' on member ' RAC10G02 '
Start of ' ORA.RAC10G01.VIP ' on member ' RAC10G02 ' failed.
Crs-1006:no to consider
Crs-0215:could Not start resource ' ORA.RAC10G01.VIP '.
Shown in log:
2015-11-18 11:01:34.258: [racg][662033088] [26208][662033088][ORA.RAC10G01.VIP]: Clsrcgetprsrctx:all 0.020s
2015-11-18 11:01:34.279: [racg][662033088] [26208][662033088][ORA.RAC10G01.VIP]: CLSRCNODEAPP:PRSR num_env = 0
2015-11-18 11:01:34.279: [racg][662033088] [26208][662033088][ORA.RAC10G01.VIP]: clsrcnodeapp:setting ORACLE_CONFIG _home=/u01/app/oracle/crs_1
2015-11-18 11:01:40.495: [racg][662033088] [26208][662033088][ORA.RAC10G01.VIP]: Wed Nov 11:01:34 CST [26213] B Roadcast = 192.168.146.255
Wed Nov 11:01:34 CST [26213] Checking interface existance
Wed Nov 11:01:34 CST [26213] Calling Getifbyip
2015-11-18 11:01:40.496: [racg][662033088] [26208][662033088][ORA.RAC10G01.VIP]: Wed Nov 11:01:34 CST [26213] G Etifbyip:started for 192.168.146.13
Wed Nov 11:01:34 CST [26213] getifbyip:returning IP eth0:1
Wed Nov 11:01:34 CST [26213] completed Getifbyip eth0:1
2015-11-18 11:01:40.496: [racg][662033088] [26208][662033088][ORA.RAC10G01.VIP]: Wed Nov 11:01:34 CST [26213] C Alling Getifbyip-a
Wed Nov 11:01:34 CST [26213] getifbyip:started for 192.168.146.13
Wed Nov 11:01:34 CST [26213] getifbyip:returning IP eth0:1
2015-11-18 11:01:40.496: [racg][662033088] [26208][662033088][ORA.RAC10G01.VIP]: Wed Nov 11:01:34 CST [26213] C ompleted Getifbyip eth0:1
Wed Nov 11:01:34 CST [26213] completed with initial interface test
Wed Nov 11:01:34 CST [26213] Checkif:start for If=eth0
2015-11-18 11:01:40.496: [racg][662033088] [26208][662033088][ORA.RAC10G01.VIP]: Wed Nov 11:01:34 CST 2015 [26213]/ Sbin/mii-tool eth0 Error
Ping to 192.168.146.1 via eth0 failed, rc = 1 (HOST=RAC10G01)
Ping to 192.168.146.1 via eth0 failed, rc = 1 (HOST=RAC10G01)
2015-11-18 11:01:40.496: [racg][662033088] [26208][662033088][ORA.RAC10G01.VIP]: Wed Nov 11:01:40 CST [26213] C HECKIF:RX Packets Checked If=eth0 OK
Wed Nov 11:01:40 CST [26213] checkif:end for If=eth0
5. See the ping gateway when the ping is not through, check the RACGVIP inside the DEFAULTGW settings
Discover defaultgw=
No settings were made. Set the defaultgw=192.168.146.1 manually, and modify the second node as well. After two nodes have been modified, restart the VIP resources, success.
[Email protected] bin]# Crs_start ORA.RAC10G01.VIP
Attempting to start ' ora.rac10g01.vip ' on member ' RAC10G01 '
Start of ' ORA.RAC10G01.VIP ' on member ' RAC10G01 ' succeeded.
[Email protected] bin]#
[Email protected] bin]# crs_stat-t
Name Type Target State Host
------------------------------------------------------------
ORA....G01.GSD Application Online Online rac10g01
Ora....g01.ons Application Online Online rac10g01
ORA....G01.VIP Application Online Online rac10g01
ORA....G02.GSD Application Online Online rac10g02
Ora....g02.ons Application Online Online rac10g02
ORA....G02.VIP Application ONLINE OFFLINE
[Email protected] bin]# Crs_start ORA.RAC10G02.VIP
Attempting to start ' ora.rac10g02.vip ' on member ' RAC10G02 '
Start of ' ORA.RAC10G02.VIP ' on member ' RAC10G02 ' succeeded.
[Email protected] bin]# crs_stat-t
Name Type Target State Host
------------------------------------------------------------
ORA....G01.GSD Application Online Online rac10g01
Ora....g01.ons Application Online Online rac10g01
ORA....G01.VIP Application Online Online rac10g01
ORA....G02.GSD Application Online Online rac10g02
Ora....g02.ons Application Online Online rac10g02
ORA....G02.VIP Application Online Online rac10g02
[Email protected] bin]#
10gRAC VIP start Error CRS-1006 CRS-0215