Home » Server Options » RAC & Failsafe » Query on depenedency between DB Instance and Service? (Oracle 10g R2 RAC on AIX)
Query on depenedency between DB Instance and Service? [message #589537] Mon, 08 July 2013 06:57 Go to next message
sysdba007
Messages: 28
Registered: November 2012
Junior Member
Hello

Could anybody suggest on the dependenecy between the database service and the database instance?
srvctl start instance -i db1 

will this start service as well for which the above instance is either preferred or available instance?
will it start the listener as well?

srvctl stop instance -i db1 

will this stop service as well for which the above instance is either preferred or available instance?
will it stop the listener as well?

srvctl start service -d db -s dbserve

will this start service as well for which the above instance is either preferred or available instance?

srvctl stop servive -d db -s dbserve

will this stop service as well for which the above instance is either preferred or available instance?

srvctl start database -d db

will it start instance, listener and service as well?

srvctl stop database -d db

will it stop instance, listener and service as well?

Thanks and Regards
Sysdba007
Re: Query on depenedency between DB Instance and Service? [message #589554 is a reply to message #589537] Mon, 08 July 2013 09:13 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Well, you could simply run those commands and see what is started and what is stopped. However, in general, there are no dependencies that you can define with the srvctl utility, other than that between a database and disk groups. You may find it helpful to look at the dependencies with the crsctl utility. For example, connect to your Grid home and run

crsctl status resource -p

This will show you detail of all the registered resources. For each one, look for defined dependencies, on the DEPENDENCIES line. You will see that they are marked as hard, soft, or pullup. That determines whether stopping or starting one will stop or start others.


Previous Topic: Oracle 11gR2 grid infrastructure installation hung at 65% of completion
Next Topic: PX Deq Credit: send blkd
Goto Forum:
  


Current Time: Thu Mar 28 17:19:19 CDT 2024