Shulou(Shulou.com)06/01 Report--

Startup failure of Oracle 10g RAC under AIX 5.3-- vip Drift

System environment:

Operating system: AIX 5300-09

Cluster software: CRS 10.2.0.1

Database: Oracle 10.2.0.1

System architecture diagram

Failure phenomenon:

After the system reboot, the CRS failed to start or the CRS service started successfully on the node, and the CRS Resource could not ONLINE.

[root@aix213 racg] cat / etc/hosts

127.0.0.1 loopback localhost # loopback (lo0) name/address192.168.8.214 aix214192.168.8.106 aix106192.168.8.213 aix213192.168.8.115 aix213-vip10.10.10.213 aix213-priv192.168.8.113 aix214-vip10.10.10.214 aix214-priv

Each node is bound to the vip ip of other nodes, and the vip ip address is bound to all nodes!

[oracle@aix214] $ifconfig-a

En0: flags=5e080863,c0 inet 192.168.8.214 netmask 0xffffff00 broadcast 192.168.8.255inet 192.168.8.113 netmask 0xffffff00 broadcast 192.168.8.255inet 192.168.8.115 netmask 0xffffff00 broadcast 192.168.8.255 tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0

[oracle@aix213] $ifconfig-a

En0: flags=5e080863,c0 inet 192.168.8.213 netmask 0xffffff00 broadcast 192.168.8.255 inet 192.168.8.113 netmask 0xffffff00 broadcast 192.168.8.255 inet 192.168.8.115 netmask 0xffffff00 broadcast 192.168.8.255 tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0

[root@aix214 /] $crsctl check crs

CSS appears healthyCRS appears healthyEVM appears healthy

[root@aix214 /] $crs_stat-t

Name Type Target State Host-ora....13.lsnr application ONLINE OFFLINEora.aix213.gsd application ONLINE OFFLINEora.aix213.ons application ONLINE OFFLINE Ora.aix213.vip application ONLINE OFFLINE ora....14.lsnr application ONLINE OFFLINE ora.aix214.gsd application ONLINE OFFLINE ora.aix214.ons application ONLINE OFFLINE ora.aix214.vip application ONLINE OFFLINE ora.prod.db application ONLINE OFFLINE ora....d1.inst application ONLINE OFFLINE Ora....d2.inst application ONLINE OFFLINE

View the log:

[root@aix213 racg] cd / u01/crs_1/log/aix213/racg

[root@aix213 racg] $more ora.aix213.vip.logOracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle. All rights reserved.2014-05-09 17 7 ora.aix213.vip 05.624: [RACG] [1] [385112] [1] [ora.aix213.vip]: Invalid parameters Or failed to bring up VIP (host=aix213) 2014-05-09 17 RACG 07 USR_ORA_DEBUG=0 05.624: [RACG] [1] [385112] [1] [ora.aix213.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/u01/crs_12014-05-09 17 7V 07V 05.625: [RACG] [1] [385112] [1] [ora.aix213.vip]: clsrcexecut: cmd = / u01/crs_1/bin/racgeut-e _ USR_ORA_DEBUG=0 54 / U01/crs_1/bin/racgvip start aix2132014-05-09 17 ora.aix213.vip 0715: [RACG] [1] [385112] [1] [ora.aix213.vip]: clsrcexecut: rc = 1 Time = 0.345s2014-05-09 1715 07VR 06.832: [RACG] [1] [385112] [1] [ora.aix213.vip]: Invalid parameters, or failed to bring up VIP (host=aix213)

.

Preliminary judgment is that there is a problem with VIP configuration on the node!

Solution 1:

1. Close nodeapps on all node

[oracle@aix213] $srvctl stop nodeapps-n aix213

[oracle@aix213] $srvctl stop nodeapps-n aix214

[oracle@aix213] $srvctl modify nodeapps-A 192.168.8.115/255.255.255.0/en0-n aix213-o $ORACLE_HOME

[oracle@aix213] $srvctl modify nodeapps-A 192.168.8.113/255.255.255.0/en0-n aix214-o $ORACLE_HOME

2. Stop the crs of all nodes

[oracle@aix213 ~] $crsctl stop crs

[oracle@aix214 ~] $crsctl stop crs

3. Restart the crs of all nodes

[oracle@aix213 ~] $crsctl start crs

[oracle@aix214 ~] $crsctl start crs

Solution 2:

1. Update VIP information in CRS

[root@aix213 racg] cat / etc/hosts

127.0.0.1 loopback localhost # loopback (lo0) name/address192.168.8.214 aix214192.168.8.106 aix106192.168.8.213 aix213192.168.8.115 aix213-vip10.10.10.213 aix213-priv192.168.8.113 aix214-vip10.10.10.214 aix214-priv

2. Modify VIP

[root@aix214 /] $srvctl modify nodeapps-n aix213-o / u01/app/oracle/product/10.2.0/db_1/-A 192.168.8.115/255.255.255.0/en0 [root@aix214 /] $srvctl modify nodeapps-n aix214-o / u01/app/oracle/product/10.2.0/db_1/-A 192.168.8.113/255.255.255.0/en0

3. Execute vipca as root

4. Restart the CRS service

[root@aix214 /] $crsctl check crsCSS appears healthyCRS appears healthyEVM appears healthy

[root@aix214 /] $crs_stat-t

Name Type Target State Host-ora....13.lsnr application OFFLINE OFFLINE ora.aix213.gsd application ONLINE ONLINE aix213 ora.aix213. Ons application ONLINE ONLINE aix213 ora.aix213.vip application ONLINE ONLINE aix213 ora....14.lsnr application ONLINE OFFLINE ora.aix214.gsd application ONLINE ONLINE aix214 ora.aix214.ons application ONLINE ONLINE aix214 ora.aix214.vip application ONLINE ONLINE aix214 ora.prod.db application ONLINE OFFLINE ora....d1.inst application OFFLINE OFFLINE Ora....d2.inst application ONLINE OFFLINE

Start Listener service manually:

[root@aix214 /] $crs_stat | grep lsnNAME=ora.aix213.LISTENER_AIX213.lsnrNAME=ora.aix214.LISTENER_ AIX214.lsnr`root @ aix214 /] $crs_start-f ora.aix214.LISTENER_AIX214.lsnrAttempting to start `ora.aix214.LISTENER_ AIX214.lsnr`on member `aix214`Start of `ora.aix214.LISTENER_ AIX214.lsnr`on member `aix214` succeeded. [root@aix214 /] $crs_start-f ora.aix213.LISTENER_AIX213.lsnrAttempting to start `ora.aix213.LISTENER_ AIX213.lsnr`on member `aix213`Start of `ora.aix213.LISTENER_ AIX213.lsnr` on member `aix213` succeeded.

So far, CRS has been launched successfully:

[oracle@aix213] $crs_stat-t

Name Type Target State Host-ora....13.lsnr application ONLINE ONLINE aix213 ora.aix213.gsd application ONLINE ONLINE aix213 ora.aix213.ons application ONLINE ONLINE aix213 ora.aix213.vip application ONLINE ONLINE aix213 ora....14.lsnr application ONLINE ONLINE aix214 ora.aix214.gsd application ONLINE ONLINE aix214 ora.aix214.ons application ONLINE ONLINE aix214 ora.aix214.vip application ONLINE ONLINE aix214 ora.prod.db application ONLINE ONLINE aix213 ora....d1.inst application ONLINE ONLINE aix213 ora....d2.inst application ONLINE ONLINE aix214

@ at this point, the problem is basically solved

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.