DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Saturday, July 2, 2016

CRS-0215 & PRKP-1001 when starting RAC database

CRS-0215 & PRKP-1001 when  starting RAC database

Setup is with oracle , 2 node RAC database.

I have created a a new spfle and deleted old one.

old spfile location  SPFILE=+DATA1/RACDB/PARAMETERFILE/spfileRACDB.ora,

new spfile location  SPFILE=+DATA2/RACDB/PARAMETERFILE/spfileRACDB.ora

When starting the database using srvctl command

[oracle@racnode1]$srvctl start database -d RACDB

PRKP-1001 : Error starting instance RACDB1 on node RACNODE1
CRS-0215: Could not start resource ‘ora.RACDB.RACDB1.inst’.
PRKP-1001 : Error starting instance RACDB2 on node RACNODE2
CRS-0215: Could not start resource ‘ora.RACDB.RACDB2.inst’.

Manually start the database after changing the spfile location to the current location

Issue is crs is looking in for the spfile old path .  So while you are changing your Spfile, you need to also modify CRS

[oracle@racnode1]$srvctl stop database -d RACDB

[oracle@racnode1]$srvctl modify database -d RACDB -p ‘+DATA2/RACDB/PARAMETERFILE/spfileRACDB.ORA’ -s open

[oracle@racnode1]$srvctl start database -d RACDB

Hope this helps ...

No comments: