Recently, the Oracle 10g RAC migration under the virtual machine, after the migration is completed, the Oracle cluster resource VIP cannot start normally, received the CRS-0233: Resource or relatives are currently involved with another operation error prompt. Why? It turns out that the migrated address has changed. You have to use the new address in your house ....
1. Environment Description
Oracle 10g RAC + SUSE 10
Note: After the RAC virtual machine is migrated, we usually choose to copy it when adding the Virtual Machine (this has not been tried before and I don't know if there is a problem)
Second, because of the selection of replication, the virtual machine needs to generate a new UUID (UUID refers to the number generated on a machine, which guarantees the uniqueness of the machine in the same virtual environment ).
At the same time, the MAC address and network interface name will also change accordingly (the original eth0 and eth1 of the virtual machine are not available for the first time), which usually needs to be modified.
Different Linux systems have different processing methods for new network interfaces. Oracle Linux and RedHat can directly Delete the original network interface and rename the new network interface name to the original one.
For more information about SuseLinux, see:
2. CRS-1006/CRS-0215/CRS-0233 Error
# Restart two nodes after modifying the NIC
# Resource vip status: offline
Oracle @ bo2dbp: ~> ./Crs_stat.sh | grep bo2dbp
Resource name Target State
-------------------------
Ora. bo2dbp. ASM1.asm ONLINE on bo2dbp
Ora. bo2dbp. LISTENER_BO2DBP.lsnr ONLINE OFFLINE
Ora. bo2dbp. LISTENER_ORA10G_BO2DBP.lsnr ONLINE OFFLINE
Ora. bo2dbp. gsd ONLINE on bo2dbp
Ora. bo2dbp. ons ONLINE OFFLINE
Ora. bo2dbp. vip ONLINE OFFLINE
Ora. ora10g. db ONLINE on bo2dbp
Ora. ora10g. ora10g1. inst ONLINE on bo2dbp
# Try to manually start ons
Oracle @ bo2dbp: ~> Crs_start ora. bo2dbp. ons
Attempting to start 'ora. bo2dbp. ons 'on member 'bo2dbp'
Start of 'ora. bo2dbp. ons 'on member 'bo2dbp' failed.
CRS-1006: No more members to consider
CRS-0215: cocould not start resource 'ora. bo2dbp. ons '.
# Onsctl-based startup also receives failure messages
Oracle @ bo2dbp: ~> Onsctl start
Number of onsconfiguration retrieved, numcfg = 2
Onscfg [0]
{Node = bo2dbp.2gotrade.com, port = 6200}
Adding remote host bo2dbp.2gotrade.com: 6200
Onscfg [1]
{Node = bo2dbs.2gotrade.com, port = 6200}
Adding remote host bo2dbs.2gotrade.com: 6200
Number of onsconfiguration retrieved, numcfg = 2
Onscfg [0]
{Node = bo2dbp.2gotrade.com, port = 6200}
Adding remote host bo2dbp.2gotrade.com: 6200
Onscfg [1]
{Node = bo2dbs.2gotrade.com, port = 6200}
Adding remote host bo2dbs.2gotrade.com: 6200
Onsctl: ons failed to start
# Try to manually start the vip and receive a CRS-0233 Error
Oracle @ bo2dbp: ~> Crs_start ora. bo2dbp. vip
CRS-0233: Resource or relatives are currently involved with another operation.