Friday, September 10, 2010

CLSR-0002 ORA-01003 in IMON logs

Failed to start the service with "srvctl" command-line.
$ srvctl start service -d db -i db1 -s servicedb
PRKP-1030 : Failed to start the service servicedb.
CRS-0215: Could not start resource 'ora.db.servicedb.db1.srv'.
So, check imon* file.
$ tail -f imon_db.log
2010-09-10 00:16:51.561: [ RACG][1252133216] [29774][1252133216][ora.db.servicedb.db1.srv]: CLSR-0002: Oracle error encountered while executing clsrcsngtsn: open cursor
2010-09-10 00:16:51.561: [ RACG][1252133216] [29774][1252133216][ora.db.servicedb.db1.srv]: ORA-01003: no statement parsed
2010-09-10 00:16:51.566: [ RACG][1252133216] [29774][1252133216][ora.db.servicedb.db1.srv]: CLSR-0002: Oracle error encountered while executing clsrcsngtsn: open cursor
2010-09-10 00:16:51.566: [ RACG][1252133216] [29774][1252133216][ora.db.servicedb.db1.srv]: ORA-01003: no statement parsed
2010-09-10 00:16:52.676: [ RACG][1252133216] [29774][1252133216][ora.db.servicedb.db1.srv]: CLSR-0002: Oracle error encountered while executing clsrcsngtsn: open cursor
2010-09-10 00:16:52.676: [ RACG][1252133216] [29774][1252133216][ora.db.servicedb.db1.srv]: ORA-01003: no statement parsed
2010-09-10 00:19:31.233: [ RACG][1252133216] [29774][1252133216][ora.db.db1.inst]: CLSR-0002: Oracle error encountered while executing clsrcsngtsn: open cursor
2010-09-10 00:19:31.233: [ RACG][1252133216] [29774][1252133216][ora.db.db1.inst]: ORA-01003: no statement parsed

then checked metalink ID 818997.1 : ORA-1003 is caused by unpublished Bug 5556555(fixed 11.1.0.6 and will be fixed in 10.2.0.5) . Idea: • either kill racgimon using kill -9 • restart the rac instance. So, I choose to kill:

[ RACG][1252133216] [29774][1252133216][ora.db.servicedb.db1.srv]: ORA-01003: no statement parsed
$ ps -aef | grep 29774
oracle 29774 1 0 2009 ? 01:56:57 /oracle/10gR2/bin/racgimon startd db

$ kill -9 29774
and then started service again.
$ srvctl start service -d db -i db1 -s servicedb

$ tail -f imon_db.log
2010-09-10 00:22:22.214: [ RACG][2540875008] [2334][2540875008][ora.db.servicedb.db1.srv]: racgimon started
Everything fine. I can start service.

1 comment:

Yurtdışı Eğitim said...
This comment has been removed by a blog administrator.