Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will be learning what SRVCTL (Server Control Utility) is in Oracle and what its Commands are.
SRVCTL is a service manager for controlling, adding, removing and relocating different CRS services or components in database installed as RAC.
Start Commands
1 2 3 | srvctl start database -d ABUZERDB -o nomount srvctl start database -d ABUZERDB -o mount srvctl start database -d ABUZERDB -o open |
Stop Commands
1 2 3 4 | srvctl stop database -d ABUZERDB -o normal srvctl stop database -d ABUZERDB -o immediate srvctl stop database -d ABUZERDB -o transactional srvctl stop database -d ABUZERDB -o abort |
Just to start the instance
1 | srvctl start instance -d ABUZERDB -i ABUZERDB1 |
Just to stop the instance
1 | srvctl stop instance -d ABUZERDB -i ABUZERDB1 |
To add database on CRS
1 | srvctl add database -d ABUZERDB -o /u01/app/oracle/product/11.2.0.4/dbhome_1 -p +DATA/ABUZERDB/parameterfile/spfileABUZERDB .ora |
To add database through CRS
1 | srvctl remove database -d ABUZERDB -f -y |
To add database instance on CRS
1 | srvctl add instance -d ABUZERDB - i ABUZERDB1 -n rachost1 |
To add database instance on CRS
1 | srvctl stop instance -d ABUZERDB - i ABUZERDB1 -n rachost1 |
To enable or disable the instance configuration
1 2 | srvctl enable instance -d DB_ABUZERDB -i ABUZERDB1 srvctl disable instance -d ABUZERDB -i ABUZERDB1 |
To enable or disable DB configuration
1 2 | srvctl enable database -d ABUZERDB srvctl disable database -d ABUZERDB |
To check the listener configuration of database named ABUZERDB
1 | srvctl config database -d ABUZERDB -t |
To check the configuration of database named ABUZERDB
1 | srvctl config database -d ABUZERDB -a |
