Tuesday, July 29, 2008

Srvctl cannot start instance, I get the following error PRKP-1001 CRS-0215, however sqlplus can start it on both nodes

Today I can not start database cluster by using "srvctl", but start by "sqlplus" command.

$ srvctl start database -d DB
PRKP-1001 : Error starting instance DB1 on node node1
CRS-0215: Could not start resource 'ora.DB.DB1.inst'.
PRKP-1001 : Error starting instance DB2 on node node2
CRS-0215: Could not start resource 'ora.DB.DB2.inst'.

When I find out information:

>>>

Srvctl cannot start instance, I get the following error PRKP-1001 CRS-0215, however sqlplus can start it on both nodes? What is the problem?

This could be many things but a popular issue is when you have a separate ASM Home and the listener is running out of this home (it was the first home installed). Srvctl needs a TNS_ADMIN alias to the network/admin directory in this home instead of using the default ORACLE_HOME/network/admin for the database you are trying to start. For srvctl to work you must

srvctl setenv nodeapps -n node -T TNS_ADMIN=full path

on each node in the cluster.
You cannot rely on a TNS_ADMIN environment variable.

>>>

So, I set ENV on CLUSTER with Database (that make me this idea) and then start again:

$srvctl setenv database -d DB -T TNS_ADMIN=/oracle/network/admin/

$ srvctl start database -d DB

... Start OK...

4 comments:

Anonymous said...

I just don't know how to thank you. Your article came as a God's gift to me in a very critical time. My sincere thanks you to for posting this valuable info.

Thank you again,

Erin M said...

Wonderful post with a clear solution. Much appreciated!!!

Anonymous said...

Hi ,
Sir i exactly got the same issue and tried but in my case it never worked it throwed me the error of
PRKR-1069 : Failed to set environment for cluster database devdb, PRKH-1001 : HASContext Internal Error

thanks

Surachart Opun said...

Please show command.

Or trace by yourself.
$ export SRVM_TRACE=TRUE
$ srvctl ...