SRVCTL Commands for Managing Oracle RAC Services
3 min read
This guide covers essential SRVCTL commands for managing Oracle RAC databases, instances, services, and ASM configurations. It includes syntax examples for common tasks like starting, stopping, relocating databases and services, adding/removing instances, and configuring auto-restart—practical commands for everyday administration.
| # | Command Description | Syntax/Example |
|---|---|---|
| 1 | Stop Database | srvctl stop database -d db_name [-o stop_options]Example: srvctl stop database -d PRODB -o normal |
| 2 | Start Database | srvctl start database -d db_name [-o start_options]Example: srvctl start database -d PRODB -o open |
| 3 | Stop an Instance | srvctl stop instance -d db_unique_name [-i “instance_name_list”] [-o stop_options] [-f]Example: srvctl stop instance -d PRODB -i PRODB1 |
| 4 | Start an Instance | srvctl start instance -d db_unique_name [-i “instance_name_list”] [-o start_options]Example: srvctl start instance -d PRODB -i PRODB1 |
| 5 | Remove Database from CRS | srvctl remove database -d db_unique_name [-f] [-y] [-v]Example: srvctl remove database -d PRODB -f -y |
| 6 | Add Database to CRS | srvctl add database -d db_unique_name -o ORACLE_HOME [-p spfile]Example: srvctl add database -d PRODB -o /u01/app/oracle/product/12.1.0.2/dbhome_1 -p +DATA/PRODDB/parameterfile/spfilePRODB.ora |
| 7 | Remove an Instance from CRS | srvctl remove instance -d DB_UNIQUE_NAME -i INSTANCE_NAMEExample: srvctl remove instance -d PRODB -i PRODB1 |
| 8 | Add an Instance to CRS | srvctl add instance -d db_unique_name -i inst_name -n node_nameExample: srvctl add instance -d PRODB -i PRODB1 -n rachost1 |
| 9 | Enable/Disable Auto Restart of the Instance | srvctl enable instance -d DB_UNIQUE_NAME -i INSTANCE_NAMEsrvctl disable instance -d DB_UNIQUE_NAME -i INSTANCE_NAME |
| 10 | Enable/Disable Auto Restart of the Database | srvctl enable database -d DB_UNIQUE_NAMEsrvctl disable database -d DB_UNIQUE_NAME |
| 11 | Add a Service | `srvctl add service -d {DB_NAME} -s {SERVICE_NAME} -r {“preferred_list”} -a {“available_list”} [-P {BASIC |
| 12 | Remove a Service | srvctl remove service -d {DB_NAME} -s {SERVICE_NAME}Example: srvctl remove service -d PREDB -s PRDB_SRV |
| 13 | Start a Service | srvctl start service -d {DB_NAME} -s {SERVICE_NAME}Example: srvctl start service -d PREDB -s PRDB_SRV |
| 14 | Stop a Service | srvctl stop service -d {DB_NAME} -s {SERVICE_NAME}Example: srvctl stop service -d PREDB -s PRDB_SRV |
| 15 | Relocate a Service | srvctl relocate service -d {database_name} -s {service_name} -i {old_inst_name} -r {new_inst_name}Example: srvctl relocate service -d PREDB -s PRDB_SVC -i PREDB2 -t PREDB1 |
| 16 | Check the Status of a Service | srvctl status service -d {database_name} -s {service_name}Example: srvctl status service -d PREDB -s PRDB_SVC |
| 17 | Check the Configuration of a Service | srvctl config service -d {database_name} -s {service_name}Example: srvctl config service -d PREDB -s PRDB_SVC |
| 18 | Check SCAN Listener Configuration | srvctl config scan_listenerExample: SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1522 |
| 19 | Modify SCAN Listener Port | srvctl modify scan_listener -p {new-SCAN-port}Example: srvctl modify scan_listener -p 1523 |
| 20 | Manage MGMTDB in Oracle 12c | srvctl status mgmtdbExample: srvctl stop mgmtdbsrvctl start mgmtdb |
| 21 | Enable Trace for SRVCTL Commands | SRVM_TRACE=trueexport SRVM_TRACEExample: srvctl status database -d ORACL |
| 22 | Set Environment Variables through SRVCTL | srvctl setenv database -db ORCL -env "ORACLE_HOME=/oracle/app/oracle/product/12.1.0.2/dbhome_1"Example: srvctl getenv database -db ORCL |
| 23 | Check Status and Configuration of ASM Instance | srvctl config asmExample: srvctl status asm |
| 24 | Stop and Start Services Running from ORACLE_HOME | srvctl stop home -oraclehome /oracle/product/12.1.0.2/dbhome_1 -statefile /home/oracle/state.txt -node dbhost-1Example: srvctl start home -oraclehome /oracle/product/12.1.0.2/dbhome_1 |
| 25 | Create a TAF Policy | srvctl add service -db ORCLDB -service TAF_ORCL -preferred ORCLDB1 -available ORCLDB2 -tafpolicy BASICExample: srvctl start service -db OMPREDB -service TAF_ORCL |
