i am facing error while starting the databse by using srvctl in single node database.
srvctl status database -d <dbname> is working fine and it is giving output. i am able to start the database manually too.
srvctl start database -d <dbname>
PRCR-1133 : Failed to stop database <dbname> and its running services
PRCR-1132 : Failed to stop resources using a filter
ORA-12547: TNS:lost contact
Edited by: user11982371 on Apr 20, 2012 6:53 AM
search for "ORA-12547: TNS:lost contact" in MOS and you will find a ton of possible reasons.
Most likely check your environment, if everything is set correctly. Make sure you use the srvctl from the database home. etc.
Edited by: Sebastian Solbach (DBA Community) on Apr 20, 2012 7:05 AM
everything is being set properly. and srvctl status database command is working fine and it is able to give the correct status.
it is not able to start/stop the db using srvctl.
may i know what you have done before....srvctl start...etc...
do you have done any changes?
post your oracle version and OS....
please find below notes from metalink..it may helpful to you....
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.
See Note 420977.1
Another cause is non-existent spfile, see Note 732683.1
Edited by: dbc001 on Mar 23, 2013 10:55 AM