{"id":3824,"date":"2025-06-09T11:43:33","date_gmt":"2025-06-09T11:43:33","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&p=3824"},"modified":"2025-06-09T11:43:34","modified_gmt":"2025-06-09T11:43:34","slug":"oracle-srvctl-commands","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/oracle-dba-d2d-tasks\/oracle-srvctl-commands\/","title":{"rendered":"Oracle SRVCTL Commands"},"content":{"rendered":"\n

This guide is a practical cheat sheet for Oracle DBAs using srvctl<\/code> in RAC environments. Each section below covers a specific srvctl<\/code> command with a short heading, real-world examples, and optional parameters explained inline. Ideal for daily operations like starting\/stopping databases, managing services, and more.<\/p>\n\n\n\n

Start a Database<\/h3>\n\n\n\n
# Syntax: srvctl start database -d <db_name> -o <open|mount|nomount>\nsrvctl start database -d PRODB -o open<\/code><\/code><\/pre>\n\n\n\n
Stop a Database<\/h3>\n\n\n\n
# Syntax: srvctl stop database -d <db_name> -o <normal|immediate|transactional|abort>\nsrvctl stop database -d PRODB -o normal<\/code><\/code><\/pre>\n\n\n\n
Add a Database to CRS<\/h3>\n\n\n\n
# Syntax: srvctl add database -d <db_name> -o <ORACLE_HOME> -p <spfile_path>\nsrvctl add database -d PRODB -o \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1 -p +DATA\/PRODDB\/parameterfile\/spfilePRODB.ora<\/code><\/code><\/pre>\n\n\n\n
Remove a Database from CRS<\/h3>\n\n\n\n
# Syntax: srvctl remove database -d <db_name> [-f] [-y]\nsrvctl remove database -d PRODB -f -y<\/code><\/code><\/pre>\n\n\n\n
Start an Instance<\/h3>\n\n\n\n
# Syntax: srvctl start instance -d <db_name> -i <instance_name> -o <open|mount|nomount>\nsrvctl start instance -d PRODB -i PRODB1 -o open<\/code><\/code><\/pre>\n\n\n\n
Stop an Instance<\/h3>\n\n\n\n
# Syntax: srvctl stop instance -d <db_name> -i <instance_name> -o <normal|immediate|transactional|abort>\nsrvctl stop instance -d PRODB -i PRODB1 -o immediate<\/code><\/code><\/pre>\n\n\n\n
Add an Instance to CRS<\/h3>\n\n\n\n
# Syntax: srvctl add instance -d <db_name> -i <instance_name> -n <node_name>\nsrvctl add instance -d PRODB -i PRODB1 -n rachost1<\/code><\/code><\/pre>\n\n\n\n
Remove an Instance from CRS<\/h3>\n\n\n\n
# Syntax: srvctl remove instance -d <db_name> -i <instance_name>\nsrvctl remove instance -d PRODB -i PRODB1<\/code><\/code><\/pre>\n\n\n\n
Enable Auto-Restart of an Instance<\/h3>\n\n\n\n
# Syntax: srvctl enable instance -d <db_name> -i <instance_name>\nsrvctl enable instance -d PRODB -i PRODB1<\/code><\/code><\/pre>\n\n\n\n
Disable Auto-Restart of an Instance<\/h3>\n\n\n\n
# Syntax: srvctl disable instance -d <db_name> -i <instance_name>\nsrvctl disable instance -d PRODB -i PRODB1<\/code><\/code><\/pre>\n\n\n\n
Enable Auto-Restart of a Database<\/h3>\n\n\n\n
# Syntax: srvctl enable database -d <db_name>\nsrvctl enable database -d PRODB<\/code><\/code><\/pre>\n\n\n\n
Disable Auto-Restart of a Database<\/h3>\n\n\n\n
# Syntax: srvctl disable database -d <db_name>\nsrvctl disable database -d PRODB<\/code><\/code><\/pre>\n\n\n\n
Add a Service<\/h3>\n\n\n\n
# Syntax: srvctl add service -d <db_name> -s <service_name> -r <preferred_list> -a <available_list> -P <BASIC|NONE>\nsrvctl add service -d PRODB -s PRODB_SVC -r \"PRODB1\" -a \"PRODB2\" -P BASIC<\/code><\/code><\/pre>\n\n\n\n
Remove a Service<\/h3>\n\n\n\n
# Syntax: srvctl remove service -d <db_name> -s <service_name>\nsrvctl remove service -d PRODB -s PRODB_SVC<\/code><\/code><\/pre>\n\n\n\n
Start a Service<\/h3>\n\n\n\n
# Syntax: srvctl start service -d <db_name> -s <service_name>\nsrvctl start service -d PRODB -s PRODB_SVC<\/code><\/code><\/pre>\n\n\n\n
Stop a Service<\/h3>\n\n\n\n
# Syntax: srvctl stop service -d <db_name> -s <service_name>\nsrvctl stop service -d PRODB -s PRODB_SVC<\/code><\/code><\/pre>\n\n\n\n
Relocate a Service<\/h3>\n\n\n\n
# Syntax: srvctl relocate service -d <db_name> -s <service_name> -i <current_instance> -t <target_instance>\nsrvctl relocate service -d PRODB -s PRODB_SVC -i PRODB2 -t PRODB1<\/code><\/code><\/pre>\n\n\n\n
Check Service Status<\/h3>\n\n\n\n
# Syntax: srvctl status service -d <db_name> -s <service_name>\nsrvctl status service -d PRODB -s PRODB_SVC<\/code><\/code><\/pre>\n\n\n\n
Check Service Configuration<\/h3>\n\n\n\n
# Syntax: srvctl config service -d <db_name> -s <service_name>\nsrvctl config service -d PRODB -s PRODB_SVC<\/code><\/code><\/pre>\n\n\n\n
Create a TAF Policy<\/h3>\n\n\n\n
# Syntax: srvctl add service -db <db_name> -service <service_name> -preferred <instance> -available <instance> -tafpolicy <BASIC|NONE>\nsrvctl add service -db ORCLDB -service TAF_ORCL -preferred ORCLDB1 -available ORCLDB2 -tafpolicy BASIC\nsrvctl start service -db ORCLDB -service TAF_ORCL<\/code><\/code><\/pre>\n\n\n\n
Check SCAN Listener Configuration<\/h3>\n\n\n\n
# Syntax: srvctl config scan_listener\nsrvctl config scan_listener<\/code><\/code><\/pre>\n\n\n\n
Modify SCAN Listener Port<\/h3>\n\n\n\n
# Syntax: srvctl modify scan_listener -p <new_port>\nsrvctl modify scan_listener -p 1523<\/code><\/code><\/pre>\n\n\n\n
Check ASM Configuration<\/h3>\n\n\n\n
# Syntax: srvctl config asm\nsrvctl config asm<\/code><\/code><\/pre>\n\n\n\n
Check ASM Status<\/h3>\n\n\n\n
# Syntax: srvctl status asm\nsrvctl status asm<\/code><\/code><\/pre>\n\n\n\n
Stop Oracle Home Services<\/h3>\n\n\n\n
# Syntax: srvctl stop home -oraclehome <path> -statefile <path> -node <node_name>\nsrvctl stop home -oraclehome \/oracle\/product\/12.1.0.2\/dbhome_1 -statefile \/home\/oracle\/state.txt -node dbhost-1<\/code><\/code><\/pre>\n\n\n\n
Start Oracle Home Services<\/h3>\n\n\n\n
# Syntax: srvctl start home -oraclehome <path>\nsrvctl start home -oraclehome \/oracle\/product\/12.1.0.2\/dbhome_1<\/code><\/code><\/pre>\n\n\n\n
Manage MGMTDB<\/h3>\n\n\n\n
# Syntax: srvctl status|start|stop mgmtdb\nsrvctl status mgmtdb\nsrvctl stop mgmtdb\nsrvctl start mgmtdb<\/code><\/code><\/pre>\n\n\n\n
Enable SRVCTL Command Trace<\/h3>\n\n\n\n
# Syntax: export SRVM_TRACE=true\nSRVM_TRACE=true\nexport SRVM_TRACE\nsrvctl status database -d ORCL<\/code><\/code><\/pre>\n\n\n\n
Set Environment Variables via SRVCTL<\/h3>\n\n\n\n
# Syntax: srvctl setenv database -db <db_name> -env \"<VAR=VALUE>\"\nsrvctl setenv database -db ORCL -env \"ORACLE_HOME=\/oracle\/app\/oracle\/product\/12.1.0.2\/dbhome_1\"<\/code><\/code><\/pre>\n\n\n\n
Get Environment Variables via SRVCTL<\/h3>\n\n\n\n
# Syntax: srvctl getenv database -db <db_name>\nsrvctl getenv database -db ORCL<\/code><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
This guide is a practical cheat sheet for Oracle DBAs using srvctl in RAC environments. Each section below covers a specific srvctl command with a short heading, real-world examples, and optional parameters explained inline. Ideal for daily operations like starting\/stopping databases, managing services, and more. Start a Database Stop a Database Add a Database to […]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,984],"class_list":["post-3824","cposts","type-cposts","status-publish","hentry","category-notes","category-oracle-dba-d2d-tasks"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/3824","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=3824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=3824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}