Skip to Main Content
  • Questions

  • Steps to perform clean startup and shutdown of 12c RAC cluster database

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, REGINALD.

Asked: November 21, 2016 - 7:33 am UTC

Last updated: November 22, 2016 - 1:18 am UTC

Version: 12c

Viewed 10K+ times! This question is

You Asked

I have a 12c 3 node cluster database running on OL 7.2. We have a scheduled maintenance activity and I need to shutdown the database and cluster so that I can reboot all the 3 hosts. What should be the steps followed? I am new to RAC. I am confused with the crsctl start/stop crs vs crsctl start/stop cluster.

and Connor said...

crsctl stop cluster, stops the clusterware stack

and then

crsctl stop crs, to stop the HA services

From the docs:

"If you intend to stop Oracle Clusterware on all or a list of nodes, then use the crsctl stop cluster command, because it prevents certain resources from being relocated to other servers in the cluster before the Oracle Clusterware stack is stopped on a particular server. If you must stop the Oracle High Availability Services on one or more nodes, then wait until the crsctl stop cluster command completes and then run the crsctl stop crs command on any particular nodes, as necessary."

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, November 21, 2016 - 12:01 pm UTC

Thanks Connor for your quick response.
So, considering I need to bring down the entire cluster, my steps should be, right?

to shutdown (in all 3 nodes)
$ srvctl stop database -d <db_unique_name>
$ crsctl stop cluster -all
$ crsctl stop crs -all

to startup (in all 3 nodes)
$ crsctl start crs -all
$ crsctl start cluster -all
$ srvctl start database -d <db_unique_name>

Connor McDonald
November 22, 2016 - 1:18 am UTC

It depends on what you also might have running (eg asm, custom resources, etc).

Check this link - there's a whole appendix on the topic

http://docs.oracle.com/database/121/RILIN/procstop.htm
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.