Subscribe to Posts by Email

Subscriber Count

    696

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

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]