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...
Subscribe to:
Post Comments (Atom)
Posts
4 comments:
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,
Wonderful post with a clear solution. Much appreciated!!!
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
Please show command.
Or trace by yourself.
$ export SRVM_TRACE=TRUE
$ srvctl ...
Post a Comment