AIX 5.3 Under Oracle 10g RAC boot failure--crs boot failure

Source: Internet
Author: User

Tags: Oracle

AIX 5.3 Under Oracle 10g RAC boot failure--crs boot failure

System environment:

Operating System: AIX 5300-09

Cluster Software: CRS 10.2.0.1

Database: Oracle 10.2.0.1


System Architecture Diagram


650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/26/B1/wKioL1NspizDELFmAAFqCT5td6k065.jpg "title=" r2.jpg "alt=" Wkiol1nspizdelfmaafqct5td6k065.jpg "/>


Failure phenomena:

After the system restarts, the CRS startup fails on the node or the CRS service starts successfully, CRS resource cannot be online.

[[email protected] RACG] Cat/etc/hosts


127.0.0.1 loopback localhost # loopback (lo0) name/address

192.168.8.214 aix214

192.168.8.106 aix106

192.168.8.213 aix213

192.168.8.115 AIX213-VIP

10.10.10.213 Aix213-priv

192.168.8.113 AIX214-VIP

10.10.10.214 Aix214-priv

Each node is bound to the VIP IP of the other nodes, and the VIP IP address is bound to all the nodes!

[[Email protected] ~] $ifconfig-A

En0:flags=5e080863,c0<up,broadcast,notrailers,running,simplex,multicast,grouprt,64bit,checksum_offload ( ACTIVE),pseg,largesend,chain>

inet 192.168.8.214 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

[[Email protected] ~] $ifconfig-A

En0:flags=5e080863,c0<up,broadcast,notrailers,running,simplex,multicast,grouprt,64bit,checksum_offload ( ACTIVE),pseg,largesend,chain>

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


[[email protected]/] $CRSCTL check CRS

CSS appears healthy

CRS appears healthy

EVM appears healthy

[[email protected]/] $crs _stat-t

Name Type Target State Host

------------------------------------------------------------

Ora .... 13.lsnr application ONLINE OFFLINE

ORA.AIX213.GSD application ONLINE OFFLINE

Ora.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

To view logs :

[Email protected] RACG]CD/U01/CRS_1/LOG/AIX213/RACG

[[email protected] RACG] $more Ora.aix213.vip.log

Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle. All rig

HTS reserved.

2014-05-09 17:07:05.624: [racg][1] [385112][1][ORA.AIX213.VIP]: Invalid parameters, or

Failed to bring up VIP (host=aix213)

2014-05-09 17:07:05.624: [racg][1] [385112][1][ORA.AIX213.VIP]: clsrcexecut:env ORACLE

_config_home=/u01/crs_1

2014-05-09 17:07: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 aix213

2014-05-09 17:07:05.625: [racg][1] [385112][1][ORA.AIX213.VIP]: CLSRCEXECUT:RC = 1, ti

me = 0.345s

2014-05-09 17:07:06.832: [racg][1] [385112][1][ORA.AIX213.VIP]: Invalid parameters, or

Failed to bring up VIP (host=aix213)

......

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


Workaround:


1. Update the VIP information in CRS

[[email protected] RACG] Cat/etc/hosts


127.0.0.1 loopback localhost # loopback (lo0) name/address

192.168.8.214 aix214

192.168.8.106 aix106

192.168.8.213 aix213

192.168.8.115 AIX213-VIP

10.10.10.213 Aix213-priv

192.168.8.113 AIX214-VIP

10.10.10.214 Aix214-priv


2. Modify VIP

[[email protected]/] $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

[[email protected]/] $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

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/26/BB/wKioL1NsqdfwzjktABaoQqgmyBY106.jpg "title=" Img_2110.jpg "alt=" wkiol1nsqdfwzjktabaoqqgmyby106.jpg "/>4, re-start the CRS service

[Email protected] racg]$

[[email protected]/] $CRSCTL check CRS

CSS appears healthy

CRS appears healthy

EVM appears healthy

[[email protected]/] $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

Manually start the Listener service:

[[email protected]/] $crs _stat |grep LSN

Name=ora.aix213.listener_aix213.lsnr

Name=ora.aix214.listener_aix214.lsnr

[[email protected]/] $crs _start-f Ora.aix214.LISTENER_AIX214.lsnr

Attempting to start ' Ora.aix214.LISTENER_AIX214.lsnr ' on member ' aix214 '

Start of ' Ora.aix214.LISTENER_AIX214.lsnr ' on member ' aix214 ' succeeded.

[[email protected]/] $crs _start-f Ora.aix213.LISTENER_AIX213.lsnr

Attempting to start ' Ora.aix213.LISTENER_AIX213.lsnr ' on member ' aix213 '

Start of ' Ora.aix213.LISTENER_AIX213.lsnr ' on member ' aix213 ' succeeded.

The CRS started successfully:

[[Email protected] ~] $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


This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1408998

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

Tags Index: