Tuesday, May 11, 2021

Oracle RAC instance start and stop

Oracle RAC instance start and stop

[oracle@sajidserver1~]$srvctl status database -d sajiddb
Instance sajiddb2 is running on node sajidserver2
Instance sajiddb1 is running on node sajidserver1

[oracle@sajidserver1]srvctl stop instance –d sajiddb –i sajiddb1 -f
PRKO-3122 : -instance option or -node option is required for stopping an instance of database null

There is nothing wrong with the above command, but it suddenly stopped working. Anyhow, if you notice the error (PRKO-3122 : -instance option or -node option is required for stopping an instance of database null). To make it work, use the below command.

[oracle@sajidserver1]srvctl stop instance –db sajiddb –instance sajiddb1 -f
[oracle@sajidserver1]

The above command works for various oracle database versions 19c/18c/12c. Similarly to start the instance you can use the below command.

[oracle@sajidserver1]srvctl start instance –db sajiddb –instance sajiddb1
[oracle@sajidserver1]