CLSR-0002

Srvctl Start Service' Fails With PRKP-1030, CRS-0215 And ORA-1003, CLSR-0002 In Database Imon Logs [ID 818997.1]

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3 to 10.2.0.4 - Release: 10.2 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 07-Oct-2010***

Symptoms

PRKP-1030 and CRS-0215 encountered when starting a service with 'srvctl start service'.

Found the following errors (every 10 minutes) in the imon log of the database.

2009-04-23 13:31:43.486: [ RACG][275667888] [8801][275667888][ora.MYDB.MYDB2.inst]: ORA-01003: no statement parsed

2009-04-23 13:41:44.072: [ RACG][275667888] [8801][275667888][ora.MYDB.MYDB2.inst]: CLSR-0002: Oracle error encountered while executing clsrcsngtsn: open cursor

Cause

This is not a Clusterware problem and the main issue here is the ORA-1003 which prevents racgimon from performing any task on the instance.
The ORA-1003 is caused by unpublished Bug 5556555.

Solution

Workaround is:

• either kill racgimon using kill -9 <racgimon pid>.  After few minutes racgimon is restarted by crs
  
• or restart the rac instance.

Unpublished Bug 5556555 bug is fixed  11.1.0.6 and will be fixed in 10.2.0.5.
Patch 5556555 is available for some platforms on 10.2.0.3 and 10.2.0.4. For the inclusion of this patch  on Windows check Note 161549.1

Please note that on 10.2.0.3 after killing racgimon,  you may hit
Bug 5446160 - RACGIMON DIDN'T RETRIEVE ADVISORY FROM SYS$SERVICE_METRICS
Bug 5446160 is fixed in Clusterware bundle patch #3 for 10.2.0.3