Sunday, July 24, 2011

SRVCTL

Add/ Start/ Knw the Services using SRVCTL :

2 Add Service :

$srvctl add service -d ORAPLAYERS -s SERVICE_NAME -r ORAPLAYERS1,ORAPLAYERS2 -a ORAPLAYERS3

Note : Here -r indicate the instance(s) the services will preferably directs to where as -a indicates the Instance where it will direct to if preferred instances are not accessible.

Tip : Using -r -a options you can make certain jobs to run on a particular instance by assigning them to a service defined in the way you like.

2 Start Service :

$srvctl start service -d ORAPLAYERS -s SERVICE_NAME

2 know the Services running per instance in detail:

$srvctl config service -d ORAPLAYERS

2 knw the running Jobs

dba_scheduler_jobs

2 knw where they r running

dba_scheduler_running_jobs

UR's Key Run ;-) 

No comments:

Post a Comment