Wednesday, 11 September 2013

CRS-0215: Could not start resource 'ora.sample.sample1.inst'

PRKP-1001 : Error starting instance sample1 on node server01
CRS-0215: Could not start resource 'ora.sample.sample1.inst'.

$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.sample.db  application    OFFLINE   OFFLINE
ora....e1.inst application    ONLINE    UNKNOWN   server01
ora....e2.inst application    ONLINE    UNKNOWN  server02
ora....02.lsnr application    ONLINE    ONLINE    server01
ora....c02.gsd application    ONLINE    ONLINE    server01
ora....c02.ons application    ONLINE    ONLINE    server01
ora....c02.vip application    ONLINE    ONLINE    server01
ora....04.lsnr application    ONLINE    ONLINE    server02
ora....c04.gsd application    ONLINE    ONLINE    server02
ora....c04.ons application    ONLINE    ONLINE    server02
ora....c04.vip application    ONLINE    ONLINE    server02

SRVCTL has problems while starting the database (SRVCTL STOP DATABASE works ok).
Also, the database can be started and stopped fine using SQL*Plus. No problems there.

I encountered this issue in my cluster. May be this also one of the reason. 

$ ./srvctl start database -d sample
PRKP-1001 : Error starting instance sample1 on node server01
CRS-0215: Could not start resource 'ora.sample.sample1.inst'.
PRKP-1001 : Error starting instance sample2 on node server02
CRS-0215: Could not start resource 'ora.sample.sample2.inst'.

check the logs 
/u001/app/oracle/product/10.2.0/db_1/log/server01/racg 
view imonsample.log

Oracle Database 10g RACG Release 10.2.0.5.0 Production Copyright 1996, 2005, Oracle.  All rights reserved.
2013-09-10 20:08:47   : Could not make directory /u001/app/oracle/product/10.2.0/db_1/racg/init/server01/ reason: Permission denied
Oracle Database 10g RACG Release 10.2.0.5.0 Production Copyright 1996, 2005, Oracle.  All rights reserved.
2013-09-10 20:08:59   : Could not make directory /u001/app/oracle/product/10.2.0/db_1/racg/init/server01/ reason: Permission denied
Oracle Database 10g RACG Release 10.2.0.5.0 Production Copyright 1996, 2005, Oracle.  All rights reserved.
2013-09-10 20:09:47   : Could not make directory /u001/app/oracle/product/10.2.0/db_1/racg/init/server01/ reason: Permission denied
Oracle Database 10g RACG Release 10.2.0.5.0 Production Copyright 1996, 2005, Oracle.  All rights reserved.
2013-09-10 20:10:52   : Could not make directory /u001/app/oracle/product/10.2.0/db_1/racg/init/server01/ reason: Permission denied

now check the permission for the required directory.
root@server01 # cd /u001/app/oracle/product/10.2.0/db_1/racg

root@server01 # ls -tlr
total 12
drwxr-x---   2 ora102   oinstall    1024 Sep 10 09:32 mesg
drwxr-x---   2 ora102   oinstall     512 Sep 10 09:34 log
drwxr-x---   2 ora102   oinstall     512 Sep 10 09:34 tmp
drwxr-x---   2 ora102   oinstall     512 Sep 10 09:34 dump
drwxr-x---   2 ora102   oinstall     512 Sep 10 13:47 lib
drwxr-----   3 root     root       512 Sep 10 15:47 init

if the init directory owned by root user,
change into oracle user.
root@server01 # chown -R ora102:oinstall init
root@server01 # ls -ltr
total 12
drwxr-x---   2 ora102   oinstall    1024 Sep 10 09:32 mesg
drwxr-x---   2 ora102   oinstall     512 Sep 10 09:34 log
drwxr-x---   2 ora102   oinstall     512 Sep 10 09:34 tmp
drwxr-x---   2 ora102   oinstall     512 Sep 10 09:34 dump
drwxr-x---   2 ora102   oinstall     512 Sep 10 13:47 lib
drwxr-----   3 ora102   oinstall     512 Sep 10 15:47 init

$ ./crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.sample.db  application    ONLINE    ONLINE    server02
ora....e1.inst application    ONLINE    ONLINE    server01
ora....e2.inst application    ONLINE    ONLINE    server02
ora....02.lsnr application    ONLINE    ONLINE    server01
ora....c02.gsd application    ONLINE    ONLINE    server01
ora....c02.ons application    ONLINE    ONLINE    server01
ora....c02.vip application    ONLINE    ONLINE    server01
ora....04.lsnr application    ONLINE    ONLINE    server02
ora....c04.gsd application    ONLINE    ONLINE    server02
ora....c04.ons application    ONLINE    ONLINE    server02
ora....c04.vip application    ONLINE    ONLINE    server02