Oracle 11g Release 2: SRVCTL commands PART 2 [Instance]

SRVCTL command for Instances 

To add the instance

• srvctl add instance –d db_name –i inst_name -n node_name
• srvctl add instance -d bhavik_test -i bhavik_test01 -n linuxrac01

To Remove the instance

• srvctl remove instance –d db_name –i inst_name
• srvctl remove instance -d bhavik_test -i bhavik_test01

To Start the instance

• srvctl start instance -d db_name -i inst_names [-o start_options] [-c connect_str|-q]
• srvctl start instance –d db_name –i inst_names [-o open]
• srvctl start instance –d db_name –i inst_names -o nomount
• srvctl start instance –d db_name –i inst_names -o mount
• srvctl start instance –d bhavik_test -i bhavik_test02

To start the instance in Oracle 11g:

• srvctl start instance -d db_unique_name {-n node_name -i "instance_name_list"} [-o start_options]
• srvctl start instance -d bhavik_test -n linuxrac02
• srvctl start instance -d bhavik_test -i "bhavik_test02,bhavik_test03"

To stop the instance

• srvctl stop instance -d db_name -i inst_names [-o stop_options] [-c connect_str|-q]
• srvctl stop instance –d db_name –i inst_names [-o normal]
• srvctl stop instance –d db_name –i inst_names -o transactional
• srvctl stop instance –d db_name –i inst_names -o immediate
• srvctl stop instance –d db_name –i inst_names -o abort
• srvctl stop instance –d bhavik_test -i bhavik_test03

To stop the instance in Oracle 11g:

• srvctl stop instance -d db_unique_name {[-n node_name]|[-i "instance_name_list"]} [-o stop_options] [-f]
• srvctl stop instance -d bhavik_test -n linuxrac01
• srvctl stop instance -d bhavik_test -i bhavik_test01

To check the status of the instance

• srvctl status instance –d db_name –i inst_names [-f] [-v] [-S level]
• srvctl status instance –d bhavik_test -i bhavik_test02

To check the status of the instance in Oracle 11g:

• srvctl status instance -d db_unique_name {-n node_name | -i "instance_name_list"} [-f] [-v]
• srvctl status instance -d bhavik_test -i "bhavik_test01,bhavik_test02" -v

To enable/disable the instance

• srvctl enable instance –d db_name –i inst_names
• srvctl enable instance -d bhavik_test -i "bhavik_test01,bhavik_test02"
• srvctl disable instance –d db_name –i inst_names
• srvctl disable inst -d bhavik_test -i "bhavik_test01,bhavik_test03"

To set dependency of instance to ASM

• srvctl modify instance -d db_name -i inst_name {-s asm_inst_name|-r} 
• srvctl modify instance -d db_unique_name -i instance_name {-n node_name|-z}
• srvctl modify instance -d bhavik_test -i bhavik_test01 -n linuxrac01
• srvctl modify instance -d bhavik_test -i bhavik_test01 -z

To move the database instance

• srvctl modify instance -d db_name -i inst_name -n node_name 
• srvctl modify instance –d bhavik_test –i bhavik_test02 –n linuxrac01

To remove the database instance

• srvctl modify instance -d db_name -i inst_name -r 
• srvctl modify instance –d bhavik_test –i bhavik_test01 –r

To get/set/unset the environment configuration of the instance

• srvctl getenv instance –d db_name –i inst_name [-t name_list]
• srvctl getenv instance –d bhavik_test –i bhavik_test01
• srvctl setenv instance –d db_name [–i inst_name] {-t "name=val[,name=val,...]" | -T "name=val"}
• srvctl setenv instance –d bhavik_test –i bhavik_test01 [options]
• srvctl unsetenv instance –d db_name [–i inst_name] [-t name_list]
• srvctl unsetenv instance –d bhavik_test –i bhavik_test01 [-t options]

Hope my post will help you and just keep watching there is some more options that will be coming soon in part 3