In rac, the vip address of a node cannot be started on this node, but can be started on other nodes ., Racvip
This experiment is in a virtual machine!
The same problem with the experiment: http://blog.csdn.net/wanghui5767260/article/details/38850335
Problem description:
Node 1, node 2, and node 3 are disconnected at the same time. As a result, node 1 and node 2 are started normally, when the vip of Node 3 starts on its own node, an error is reported, while the vip of Node 3 starts normally on other nodes.
Note: node 3 is only loaded into the cluster.
View status:
[Root @ rac3 bin] #./crs_stat-t
Name Type Target State Host
------------------------------------------------------------
Ora... B1.inst application ONLINE rac1
Ora... B2.inst application ONLINE rac2
Ora. RACDB. db application ONLINE rac2
Ora... SM1.asm application ONLINE rac1
Ora... C1.lsnr application ONLINE rac1
Ora. rac1.gsd application ONLINE rac1
Ora. rac1.ons application ONLINE rac1
Ora. rac1.vip application ONLINE rac1
Ora... SM2.asm application ONLINE rac2
Ora... C2.lsnr application ONLINE rac2
Ora. rac2.gsd application ONLINE rac2
Ora. rac2.ons application ONLINE rac2
Ora. rac2.vip application ONLINE rac2
Ora. rac3.gsd application ONLINE rac3
Ora. rac3.ons application ONLINE rac3
Ora. rac3.vip application ONLINE rac1
An error is reported in the crs log of Node 3:
22:16:55. 013: [CRSRES] [2740304784] 0 Attempting to stop 'ora. rac3.vip 'on member 'rac1'
22:16:55. 204: [CRSRES] [2740304784] 0 Stop of 'ora. rac3.vip 'onmember 'rac1' succeeded.
22:16:55. 552: [CRSRES] [2740304784] 0ora. rac3.gsd target setto OFFLINE before stop action
22:16:55. 552: [CRSRES] [2740304784] 0 StopResource: setting CLIvalues
22:16:55. 627: [CRSRES] [2740304784] 0 Attempting to stop 'ora. rac3.gsd 'on member 'rac3'
22:16:56. 658: [CRSRES] [2740304784] 0 Stop of 'ora. rac3.gsd 'onmember 'rac3' succeeded.
22:17:06. 343: [CRSRES] [2740304784] 0 startRunnable: settingCLI values
22:17:06. 374: [CRSRES] [2740304784] 0 Attempting to start 'ora. rac3.gsd 'on member 'rac3'
22:17:07. 455: [CRSRES] [2740304784] 0 Start of 'ora. rac3.gsd 'on member 'rac3' succeeded.
22:17:07. 878: [CRSRES] [2740304784] 0 startRunnable: settingCLI values
22:17:07. 897: [CRSRES] [2740304784] 0 Attempting to start 'ora. rac3.vip 'on member 'rac3'
22:17:14. 916: [CRSAPP] [2740304784] 0 StartResource error forora. rac3.vip error code = 1
22:17:18. 262: [CRSRES] [2740304784] 0 Start of 'ora. rac3.vip 'on member 'rac3' failed.
Some checks are normal.
[Root @ rac3 bin] #./oifcfg getif
Eth0 192.168.90.0 global public
Eth1 192.168.91.0 global cluster_interconnect
[Root @ rac3 bin] #
[Root @ rac3 bin] #
[Root @ rac3 bin] #./crsctl start crs
Attempting to start CRS stack
The CRS stack will be started shortly
Check logs or report errors
22:27:37. 202: [crsti] [2253600] 0CSS is not ready. Receivedstatus 3 from CSS. Waiting for good status ..
22:27:38. 654: [COMMCRS] [114084752] clsc_connect: (0x94cfed0) no listener at (ADDRESS = (PROTOCOL = ipc) (KEY = OCSSD_LL_rac3_crs ))
22:27:38. 654: [CSSCLNT] [2253600] clsssInitNative: connect failed, rc 9
22:27:38. 654: [crsti] [2253600] 0CSS is not ready. Receivedstatus 3 from CSS. Waiting for good status ..
22:27:40. 096: [COMMCRS] [114084752] clsc_connect :( 0x95238e0) no listener at (ADDRESS = (PROTOCOL = ipc) (KEY = OCSSD_LL_rac3_crs ))
22:27:40. 096: [CSSCLNT] [2253600] clsssInitNative: connect failed, rc 9
22:27:40. 096: [crsti] [2253600] 0CSS is not ready. Receivedstatus 3 from CSS. Waiting for good status ..
22:27:41. 575: [COMMCRS] [114084752] clsc_connect: (0x95238e0) no listener at (ADDRESS = (PROTOCOL = ipc) (KEY = OCSSD_LL_rac3_crs ))
22:27:41. 575: [CSSCLNT] [2253600] clsssInitNative: connect failed, rc 9
22:27:41. 575: [crsti] [2253600] 0CSS is not ready. Receivedstatus 3 from CSS. Waiting for good status ..
Turn off the Virtual Machine and change the two NICs,
[Root @ rac3 bin] #./crs_stat-t
Name Type Target State Host
------------------------------------------------------------
Ora... B1.inst application ONLINE rac1
Ora... B2.inst application ONLINE rac2
Ora. RACDB. db application ONLINE rac2
Ora... SM1.asm application ONLINE rac1
Ora... C1.lsnr application ONLINE rac1
Ora. rac1.gsd application ONLINE rac1
Ora. rac1.ons application ONLINE rac1
Ora. rac1.vip application ONLINE rac1
Ora... SM2.asm application ONLINE rac2
Ora... C2.lsnr application ONLINE rac2
Ora. rac2.gsd application ONLINE rac2
Ora. rac2.ons application ONLINE rac2
Ora. rac2.vip application ONLINE rac2
Ora. rac3.gsd application ONLINE rac3
Ora. rac3.ons application ONLINE rac3
Ora. rac3.vip application ONLINE rac3
It may be caused by a problem with the VM Nic !!!
Oracle rac single-node vip cannot be started
One possibility is that your VIP is on the second node... In this way, you can use VIPCA or manually modify the corresponding IP address.
Another possibility is your OCR problem. Use the srvctl config database-d command to view the database status and check the corresponding status .. Check whether shared storage is mounted successfully!
Question about Oracle RAC crs-vip drift
This is a bit strange to you. Generally, two VIPs are on one node. Here, the positions of the two VIPs are changed.
Although you still cannot determine why this is the case based on your information, you can try the crs_stop and crs_start commands to disable vip and restart vip resources on the correct node. Then you can start the listener.