Monday, February 12, 2007

[BUG] Oracle RAC 10.2.0.3:Solaris 10 G

have used Oracle 10.2.0.3 on Solaris 10 Sparc 64 bits
I found ons restart and down


#evmwatch -A

CRS ora.cgwdb01.ons is transitioning from state ONLINE to state OFFLINE on member cgwdb01
RAC: ora.cgwdb01.ons: down:
CRS ora.cgwdb01.ons stopped
CRS ora.cgwdb01.ons is transitioning from state OFFLINE to state ONLINE on member cgwdb01
RAC: ora.cgwdb01.ons: up:

ora.xxxx.ons.log file


2007-02-09 09:55:57.701: [ RACG][1] [18747][1][ora.cgwdb01.ons]: clsrcexecut: env ORACLE_CONFIG_HOME=/u01/oracle/product/10.2.0/crs

2007-02-09 09:55:57.701: [ RACG][1] [18747][1][ora.cgwdb01.ons]: clsrcexecut: cmd = /u01/oracle/product/10.2.0/crs/bin/racgeut -e _USR_ORA_DEBUG=0 540 /u01/oracle/product/10.2.0/crs/bin/onsctl ping

2007-02-09 09:55:57.701: [ RACG][1] [18747][1][ora.cgwdb01.ons]: clsrcexecut: rc = 1, time = 0.556s

2007-02-09 09:55:57.701: [ RACG][1] [18747][1][ora.cgwdb01.ons]: end for resource = ora.cgwdb01.ons, action = check, status = 1, time = 0.683s

2007-02-09 09:56:00.451: [ RACG][1] [18789][1][ora.cgwdb01.ons]: onsctl: shutting down ons daemon ...
Number of onsconfiguration retrieved, numcfg = 2
onscfg[0]
{node = cgwdb01, port = 6200}
Adding remote host cgwdb01:6200
onscfg[1]
{node = cgwdb02, port = 6200}
Adding remote host cgwdb02:6200

2007-02-09 09:56:02.391: [ RACG][1] [18867][1][ora.cgwdb01.ons]: Number of onsconfiguration retrieved, numcfg = 2
onscfg[0]
{node = cgwdb01, port = 6200}
Adding remote host cgwdb01:6200
onscfg[1]
{node = cgwdb02, port = 6200}
Adding remote host cgwdb02:6200
Number of onsconfiguration retrieved, numcfg = 2
onscfg[
2007-02-09 09:56:02.392: [ RACG][1] [18867][1][ora.cgwdb01.ons]: 0]
{node = cgwdb01, port = 6200}
Adding remote host cgwdb01:6200
onscfg[1]
{node = cgwdb02, port = 6200}
Adding remote host cgwdb02:6200
onsctl: ons started


# netstat -an | grep 6200
*.6200 *.* 0 0 49152 0 LISTEN
192.16.3.11.6200 192.16.3.12.36172 49640 0 49640 0 TIME_WAIT
192.16.3.11.6200 192.16.3.12.35872 49640 0 49640 0 TIME_WAIT
.
.
.

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

Bug 5749953 - Solaris: CRS crashes after applying 10.2.0.3 Patch Set
Doc ID: Note:5749953.8 Type: PATCH
Last Revision Date: 07-FEB-2007 Status: PUBLISHED
Click here for details of sections in this note.

Bug 5749953 Solaris: CRS crashes after applying 10.2.0.3 Patch Set
This note gives a brief overview of bug 5749953.
This bug is marked as an important issue.

Affects:
Product (Component) Oracle Application Server 10g Enterprise Edition (Oracle Nofication Service)
Range of versions believed to be affected Versions >= 10.2.0.3 but < 10.2.0.4
Versions confirmed as being affected 10.2.0.3

Platforms affected Solaris 64bit


Fixed:
This issue is fixed in 10.2.0.4 (Server Patch Set)


Symptoms: Related To:
Install Is Not Performed Correctly
RAC (Real Application Clusters) / OPS


Description
The "ons" binary shipped as part of the 10.2.0.3 patchset on Solaris
crashes CRS when there is more than one node up.

It is recommended to download the patch for this issue
and follow the steps in the README.txt for the onsctl script.

No comments: