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
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
No comments:
Post a Comment