How Stop / Start Multiple Database Instances Under One Oracle Home in Single srvctl Command?

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
There are different situations (e.g: patching) to shutdown or startup multiple databases instance under one ORACLE HOME under one RAC node. 

 Syntax: 

 You will have to bring down all the instance at a time under one ORACLE_HOME. You cannot select instances under the oracle home.

 
srvctl stop home -o <DB HOME> -s <state filename with absolute path> -t <db shutdown option> -n NODE

While bringing up the instance you can select the instances to be brought up by editing the state file.

srvctl start home -o <DB HOME> -s <state filename with absolute path> -n NODE

Example: Command to Shutdown all instances under oracle home

srvctl stop home -o /data_acc/app/oracle/product/12.1.0/db_1 -s /home/oracle/node2_inst -t immediate -n racnode1

Sample entries of state file which mentioned in the -s option of the command. This file will get created during the stop command.

$ cat node2_inst
db-emdb
db-mmdb
db-onldb
advertisements
 
If the state file already present in the location mentioned in the -s option, it will throw below error.

PRKO-3244 : The '-statfile <state_file>' option value "/home/oracle/node2_inst" already exists

Command to startup all instances under oracle home

srvctl stop home -o /data_acc/app/oracle/product/12.1.0/db_1 -s /home/oracle/node2_inst -t immediate -n racnode1

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer