PRKP-1001 : Error starting instance

srvtl start instance or start database gives error, but sqlplus can start it without any errors.

srvctl start instance -d FDRPRD -i FDRPRD1
PRKP-1001 : Error starting instance fdrprd1 on node ls1orafdrr1sb
CRS-0215: Could not start resource 'ora.fdrprd.fdrprd1.inst'.

Issue was instance name in spfile and CRS was not having the same CASE

1) run crs_stat (this is customized script ) this should show the contents in lower case

HA Resource Target State
ora.fdrlup.db OFFLINE OFFLINE
ora.fdrlup.fdrlup1.inst ONLINE OFFLINE
ora.fdrlup.fdrlup2.inst ONLINE OFFLINE
ora.fdrlup.fdrlup3.inst ONLINE OFFLINE
ora.ls1orafdrr1sb.gsd ONLINE ONLINE on ls1orafdrr1sb
ora.ls1orafdrr1sb.ons ONLINE ONLINE on ls1orafdrr1sb
ora.ls1orafdrr1sb.vip ONLINE ONLINE on ls1orafdrr1sb
ora.ls1orafdrr2sb.gsd ONLINE ONLINE on ls1orafdrr2sb
ora.ls1orafdrr2sb.ons ONLINE ONLINE on ls1orafdrr2sb
ora.ls1orafdrr2sb.vip ONLINE ONLINE on ls1orafdrr2sb
ora.ls1orafdrr3sb.gsd ONLINE ONLINE on ls1orafdrr3sb
ora.ls1orafdrr3sb.ons ONLINE ONLINE on ls1orafdrr3sb
ora.ls1orafdrr3sb.vip ONLINE ONLINE on ls1orafdrr3sb


2) check the imon file for error
/opt/oracle/product/10.2.0/log/ls1orafdrr1sb/racg/imon_FDRPRD.log ,
you should an error similar like
SQL> ORA-01506: missing or illegal database name Disconnected


ora.FDRPRD.FDRPRD1.inst.log

Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle. All rights reserved.
2009-02-20 15:08:10.022: [ RACG][3086904064] [2840][3086904064][ora.default]: Cannot read string from /opt/oracle/product/10.2.0/racg/init/ls1orafdrr1sb/FDRPRD/.connect
2009-02-20 15:08:12.450: [ RACG][3086904064] [2840][3086904064][ora.FDRPRD.FDRPRD1.inst]: clsrcremaction: clsrcrpcreq message returned: 1 '
SQL*Plus: Release 10.2.0.3.0 - Production on Fri Feb 20 15:08:11 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter user-name: Connected to an idle instance.
SQL> ORA-01506: missing or illegal database name
SQL> Disconnected


3) Remove the instance and database

srvctl remove instance -d FDRPRD -i FDRPRD1
Remove instance FDRPRD1 from the database FDRPRD? (y/[n]) y
srvctl remove instance -d FDRPRD -i FDRPRD2
Remove instance FDRPRD2 from the database FDRPRD? (y/[n]) y
srvctl remove instance -d FDRPRD -i FDRPRD3
[ls1orafdrr1sb:oracle]/opt/oracle/product/10.2.0/log/ls1orafdrr1sb/racg>

srvctl remove database -d FDRPRD
Remove the database FDRPRD? (y/[n]) y

4) Check the ocrdumpfile by running ocrdump command .You shouldn't see
any reference for the instance or db.


5) Add the instance and database


srvctl add database -d FDRPRD -o $ORACLE_HOME -p
/dev/raw/spfileFDRPRDRD -r PHYSICAL_STANDBY -s mount
[ls1orafdrr1sb:oracle]/opt/oracle/product/10.2.0/log/ls1orafdrr1sb/racg>

srvctl add instance -d FDRPRD -i FDRPRD3 -n ls1orafdrr3sb
[ls1orafdrr1sb:oracle]/opt/oracle/product/10.2.0/log/ls1orafdrr1sb/racg>

srvctl add instance -d FDRPRD -i FDRPRD2 -n ls1orafdrr2sb
[ls1orafdrr1sb:oracle]/opt/oracle/product/10.2.0/log/ls1orafdrr1sb/racg>

srvctl add instance -d FDRPRD -i FDRPRD1 -n ls1orafdrr1sb


6) recheck the ocrdumpfile by running ocrdump command and You should
see any reference for the instance or db.



7) rerun the crs_stat to check the contents


HA Resource Target State
----------- ------ -----
ora.FDRPRD.FDRPRD1.inst OFFLINE OFFLINE
ora.FDRPRD.FDRPRD2.inst OFFLINE OFFLINE
ora.FDRPRD.FDRPRD3.inst OFFLINE OFFLINE
ora.FDRPRD.db OFFLINE OFFLINE
ora.ls1orafdrr1sb.gsd ONLINE ONLINE on ls1orafdrr1sb
ora.ls1orafdrr1sb.ons ONLINE ONLINE on ls1orafdrr1sb
ora.ls1orafdrr1sb.vip ONLINE ONLINE on ls1orafdrr1sb
ora.ls1orafdrr2sb.gsd ONLINE ONLINE on ls1orafdrr2sb
ora.ls1orafdrr2sb.ons ONLINE ONLINE on ls1orafdrr2sb
ora.ls1orafdrr2sb.vip ONLINE ONLINE on ls1orafdrr2sb
ora.ls1orafdrr3sb.gsd ONLINE ONLINE on ls1orafdrr3sb
ora.ls1orafdrr3sb.ons ONLINE ONLINE on ls1orafdrr3sb
ora.ls1orafdrr3sb.vip ONLINE ONLINE on ls1orafdrr3sb


8) srvctl start database -d FDRPRD