{"id":4508,"date":"2022-12-02T07:00:00","date_gmt":"2022-12-02T04:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=4508"},"modified":"2024-02-02T14:36:31","modified_gmt":"2024-02-02T11:36:31","slug":"chrisimes-entoles-gia-na-diacheirizoma","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/chrisimes-entoles-gia-na-diacheirizoma\/","title":{"rendered":"Useful commands to manage Oracle Grid Infrastructure \/ RAC (crsctl \/ srvctl)"},"content":{"rendered":"

In this article we will see some useful commands to manage databases installed on Oracle Grid Infrastructure<\/strong>. The Oracle Cluster Resources<\/em><\/strong> (CRS) we manage them through the tool CRSCTL<\/code> and Oracle Database<\/strong> , Listener <\/strong>and Services <\/strong>with the tool SRVCTL<\/code>. <\/p>\n\n\n\n

Useful CRSCTL commands<\/h2>\n\n\n\n

All commands CRSCTL<\/code> run by default with root<\/code> user.<\/p>\n\n\n\n

To start \/ stop Cluster Services on the server we are connected to:<\/p>\n\n\n\n

crsctl start crs\n\ncrsctl stop crs<\/pre>\n\n\n\n
To stop\/start Cluster Services on all servers:<\/p>\n\n\n\n
crsctl stop cluster -all\n\ncrsctl start cluster -all<\/pre>\n\n\n\n
To see if the health of the Cluster Services on the local node:<\/p>\n\n\n\n
crsctl check crs<\/pre>\n\n\n\n
To see the status of each Cluster Service running on all nodes:<\/p>\n\n\n\n
crsctl status resource -t<\/pre>\n\n\n\n
<\/p>\n\n\n\n
Useful SRVCTL commands<\/h2>\n\n\n\n
All commands SRVCTL<\/code> run by default with oracle<\/code> user.<\/p>\n\n\n\n
To see the database parameters:<\/p>\n\n\n\n
srvctl config database -d racdb<\/pre>\n\n\n\n
To stop\/start the database on all nodes:<\/p>\n\n\n\n
srvctl stop database -d racdb \n\nsrvctl start database -d racdb \n<\/pre>\n\n\n\n
When we stop \/ start the base, we can also give an option (e.g. abort, mount):<\/p>\n\n\n\n
srvctl stop database -d racdb -o immediate\n\nsrvctl start database \u2013d racdb -o mount<\/pre>\n\n\n\n
To stop \/ start specific instance only:<\/p>\n\n\n\n
srvctl stop instance -d racdb -i racdb2\n\nsrvctl start instance -d racdb -i racdb2<\/pre>\n\n\n\n
To remove a database from the Cluster:<\/p>\n\n\n\n
srvctl remove database -d racdb -f -y<\/pre>\n\n\n\n
To add a database to the Cluster beyond its name we need the ORACLE_HOME<\/code> and its location SPFILE<\/code>:<\/p>\n\n\n\n
srvctl add database -d racdb -o \/oracle\/nfs\/app\/oracle\/product\/12.1.0.2\/dbhome_1 -p \/oracle\/oradata\/racdb\/racdb\/spfileracdb.ora<\/pre>\n\n\n\n
To remove an instance from the Cluster:<\/p>\n\n\n\n
srvctl remove instance -d racdb -i racdb2<\/pre>\n\n\n\n
To add an instance to the Cluster, in addition to the name of the instance we also need its hostname:<\/p>\n\n\n\n
srvctl add instance -d racdb -i racdb2 -n oracledev2<\/pre>\n\n\n\n
If we want to stop \/ start the database to start automatically in the Cluster:<\/p>\n\n\n\n
srvctl disable database -d racdb\n\nsrvctl enable database -d racdb<\/pre>\n\n\n\n
To stop \/ start listeners on nodes:<\/p>\n\n\n\n
srvctl stop listener \u2013n racdb1 , racdb2\n\nsrvctl start listener \u2013n racdb1 , racdb2<\/pre>\n\n\n\n
To see the SCAN Listener parameters:<\/p>\n\n\n\n
srvctl config scan_listener<\/pre>\n\n\n\n
For Database Services<\/h4>\n\n\n\n
To create a new service that will connect with priority to instance racdb1 but can also connect to racdb2 if something happens:<\/p>\n\n\n\n
srvctl add service -d racdb -s REPORTING -r \"racdb1\" -a \"racdb2\" -P BASIC<\/pre>\n\n\n\n
To start \/ stop the service:<\/p>\n\n\n\n
srvctl start service -d racdb -s REPORTING\n\nsrvctl stop service -d racdb -s REPORTING<\/pre>\n\n\n\n
To remove the service:<\/p>\n\n\n\n
srvctl remove service -d racdb -s REPORTING<\/pre>\n\n\n\n
To modify a service to run only on instance racdb1:<\/p>\n\n\n\n
srvctl modify service \u2013d racdb \u2013s REPORTING \u2013n \u2013i racdb1<\/pre>\n\n\n\n
To move a service running on racdb2 the connections to racdb1:<\/p>\n\n\n\n
srvctl relocate service -d racdb -s REPORTING -i racdb2 -t racdb1<\/pre>\n\n\n\n
To check where a service is currently running:<\/p>\n\n\n\n
srvctl status service -d racdb -s REPORTING<\/pre>\n\n\n\n
To make a service for Transparent Application Failover<\/strong><\/em> (TAF):<\/p>\n\n\n\n
srvctl add service -db racdb -service racdb_taf -preferred racdb1 -available racdb2 -tafpolicy PRECONNECT -failovertype SELECT -q true<\/pre>\n\n\n\n
To start a service:<\/p>\n\n\n\n
srvctl start service -db racdb -service racdb_taf<\/pre>\n\n\n\n
To see all the parameters of a service:<\/p>\n\n\n\n
srvctl config service -d racdb -s racdb_taf<\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
Sources:<\/p>\n\n\n\n