Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RAC no more HA after upgrading to 9.2.0.6?

RE: RAC no more HA after upgrading to 9.2.0.6?

From: Magni Fabrizio <Fabrizio.Magni_at_rasnet.it>
Date: Tue, 1 Feb 2005 10:21:30 +0100
Message-ID: <BFCF159FFD14F444B205968F32DBD5BB6A550E@MAILEX01.rasgroup.ita.localnet>


My oracm configuration:

HeartBeat=3D15000
ClusterName=3DOracle Cluster Manager, version 9i PollInterval=3D1000
MissCount=3D50
PrivateNodeNames=3Dracnode1 racnode2
PublicNodeNames=3Drac1 rac2
ServicePort=3D9998
CmDiskFile=3D/dev/raw3
HostName=3Dracnode1
KernelModuleName=3Dhangcheck-timer

Just a part of my cm.log

>WARNING: PollingThread(): node(1) missed(50) checkin(s), tid =3D
PollingThread:5126 file =3D nmmember.c, line =3D 850 {Sun Jan 30 NMEVENT_SUSPEND [00][00][00][00][00][00][00][01] {Sun Jan 30 18:37:12 2005 }
RecvMsg(): terminating due to CM state change (2) {Sun Jan 30 18:37:12 2005 }
Debug Hang :CMNodeListener(PID=3D11440) UnRegistered with ORACM. {Sun = Jan
30 18:37:12 2005 }
HandleUpdate(): SYNC(4) from node(0) completed {Sun Jan 30 18:37:14 2005 }
HandleUpdate(): NODE(0) IS ACTIVE MEMBER OF CLUSTER, INCARNATION(1) {Sun Jan 30 18:37:14 2005 }
NMEVENT_RECONFIG [00][00][00][00][00][00][00][01] {Sun Jan 30 18:37:14 2005 }
Successful reconfiguration, 1 active node(s) node 0 is the master, my node num is 0 (reconfig 5) {Sun Jan 30 18:37:14 2005 }

After the reconfiguration the node alive doesn't repond anymore. The processes are up but none can connect and even with a sqlplus "/as sysdba" (doing any kind of interrogation) I obtain a:

ORA-01012: not logged on

It is not really a hang because when the interconnect link is up again (even without an oracm or an instance on the other node) all is back working.
It seems a new control is performed on the interconnect...

I wished to check if others had experienced this behaviour.

Fabrizio

> -----Original Message-----
> From: Parker, Matthew [mailto:matthewp_at_amazon.com]=20
> Sent: Tuesday, February 01, 2005 10:02 AM
> To: Magni Fabrizio; oracle-l_at_freelists.org
> Subject: RE: RAC no more HA after upgrading to 9.2.0.6?
>=20
>=20
> So what is your timeouts set to for the cluster.
> Does it hang indefinitely? (more than say 20 minutes).
> What are the errors in the alert.log and cm.log when this happens?
>=20
> -----Original Message-----
> From: Magni Fabrizio [mailto:Fabrizio.Magni_at_rasnet.it]=20
> Sent: Tuesday, February 01, 2005 12:55 AM
> To: Parker, Matthew; oracle-l_at_freelists.org
> Subject: RE: RAC no more HA after upgrading to 9.2.0.6?
>=20
>=20
> >=20
> > What version of oracm are you on?=20
> >=20
>=20
> oracm, version[ 9.2.0.6.0.52 ]
>=20
> New versions around? Have you a patch number?
>=20
> Fabrizio
>=20

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 01 2005 - 04:24:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US