RAC no more HA after upgrading to 9.2.0.6? 2005-02-01 - By Magni Fabrizio
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 (See ORA-01012.ora-code.com): 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@(protected)]=20 > Sent: Tuesday, February 01, 2005 10:02 AM > To: Magni Fabrizio; oracle-l@(protected) > 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@(protected)]=20 > Sent: Tuesday, February 01, 2005 12:55 AM > To: Parker, Matthew; oracle-l@(protected) > 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
|
|