Subscriber Count

    457

Subscribe2

Pages

SRVCTL Command: For Instance

SRVCTL for Instance

To add the instance

    Command: srvctl add instance -d db_name -i inst_name -n node_name
    Example: srvctl add instance -d racdb -i rac01 -n lnxrac1

To Remove the instance

    Command: srvctl remove instance -d db_name -i inst_name
    Example: srvctl remove instance -d racdb -i rac01

To Start the instance

    Command: srvctl start instance -d db_name -i inst_names [-o start_options] [-c connect_str|-q]
    Command: srvctl start instance -d db_name -i inst_names [-o open]
    Command: srvctl start instance -d db_name -i inst_names -o nomount
    Command: srvctl start instance -d db_name -i inst_names -o mount
    Example: srvctl start instance -d racdb -i rac02

To start the instance in Oracle 11g:

    Command: srvctl start instance -d db_unique_name {-n node_name -i "instance_name_list"} [-o start_options]
    Example: srvctl start instance -d racdb -n lnxrac2
    Example: srvctl start instance -d racdb -i "rac02,rac03"

To stop the instance

    Command: srvctl stop instance -d db_name -i inst_names [-o stop_options] [-c connect_str|-q]
    Command: srvctl stop instance -d db_name -i inst_names [-o normal]
    Command: srvctl stop instance -d db_name -i inst_names -o transactional
    Command: srvctl stop instance -d db_name -i inst_names -o immediate
    Command: srvctl stop instance -d db_name -i inst_names -o abort
    Example: srvctl stop instance -d racdb -i rac03

To stop the instance in Oracle 11g:

    Command: srvctl stop instance -d db_unique_name {[-n node_name]|[-i "instance_name_list"]} [-o stop_options] [-f]
    Example: srvctl stop instance -d racdb -n lnxrac1
    Example: srvctl stop instance -d racdb -i rac01

To check the status of the instance

    Command: srvctl status instance -d db_name -i inst_names [-f] [-v] [-S level]
    Example: srvctl status instance -d racdb -i rac02

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

    Command: srvctl status instance -d db_unique_name {-n node_name | -i "instance_name_list"} [-f] [-v]
    Example: srvctl status instance -d racdb -i "rac01,rac02" -v

To enable/disable the instance

    Command: srvctl enable instance -d db_name -i inst_names
    Example: srvctl enable instance -d racdb -i "rac01,rac02"
    Command: srvctl disable instance -d db_name -i inst_names
    Example: srvctl disable inst -d racdb -i "rac01,rac03"

To set dependency of instance to ASM

    Command: srvctl modify instance -d db_name -i inst_name {-s asm_inst_name|-r} 
    Command: srvctl modify instance -d db_unique_name -i instance_name {-n node_name|-z}
    Example: srvctl modify instance -d racdb -i rac01 -n lnxrac1
    Example: srvctl modify instance -d racdb -i rac01 -z

To move the database instance

    Command: srvctl modify instance -d db_name -i inst_name -n node_name 
    Example: srvctl modify instance -d racdb -i rac02 -n lnxrac1

To remove the database instance

    Command: srvctl modify instance -d db_name -i inst_name -r 
    Example: srvctl modify instance -d racdb -i rac01 -r

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

    Command: srvctl getenv instance -d db_name -i inst_name [-t name_list]
    Example: srvctl getenv instance -d racdb -i rac01
    Command: srvctl setenv instance -d db_name [-i inst_name] {-t "name=val[,name=val,...]" | -T "name=val"}
    Example: srvctl setenv instance -d racdb -i rac01 [options]
    Command: srvctl unsetenv instance -d db_name [-i inst_name] [-t name_list]
    Example: srvctl unsetenv instance -d racdb -i rac01 [-t options]