Shutdown/Re-start RAC databases

Need to shutdown and restart almost 7 RAC databases on 2 unix boxes (2 nodes) only, because first time doing this, it'll be great, if someone can share, what is the best practice and how to go about, steps or link will highly be appreciated.

This is needed for some OS maintenance.

Thanks in advance.
Mushfique KhanDirector OperationsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
If you want to shutdown the database and all instances:
srvctl stop database

Stops a database, its instances, and its services. When the database later restarts, services with AUTOMATIC management start automatically but services with MANUAL management policy must be started manually.

http://docs.oracle.com/cd/E11882_01/rac.112/e41960/srvctladmin.htm#RACAD5039
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DavidSenior Oracle Database AdministratorCommented:
Reminder to read in context; the above referenced link explains more if you just look around in the document.
0
Mushfique KhanDirector OperationsAuthor Commented:
thanks ... but just for the verification purpose, is everything up, running & good too, what to execute & checked/verified, before and after too ... shutdown/restart?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

DavidSenior Oracle Database AdministratorCommented:
I use for a quick view on an instance status:

ps -ef |grep pmon

and to monitor which databases are open, from the grid user:

crsctl stat res -t

which is documented in http://www.dba-oracle.com/t_rac_cluster_registry_CRSCTL_command.htm.
0
slightwv (䄆 Netminder) Commented:
>>, is everything up, running & good too

What do you do now to verify everything is 'good'?

This is not meant to be mean.  It is hard to 'type' in an intended meaning.  It is meant to offer some professional advice.

If you don't know how to check the status of your Grid Cluster and/or databases/instances, I suggest a LOT of time in the documentation and if possible some Oracle training or onsite consulting.
0
Mushfique KhanDirector OperationsAuthor Commented:
mean to say, relevant to the db shutdown & restart only, is there any thing to check/verify?
0
slightwv (䄆 Netminder) Commented:
>>is there any thing to check/verify?

Pretty much make sure that everything running before is running after?

I'll have to defer to other Experts that have done much more with RAC than I have.

I'm far from  a RAC Expert.  I've only played with it a little bit.  Most of what I know about it is from reading about it to see how I can leverage what it offers.
0
DavidSenior Oracle Database AdministratorCommented:
Not that I've seen beyond the crsctl answer I gave above. It's the best practice I've come across to readily confirm RAC status.
0
Mushfique KhanDirector OperationsAuthor Commented:
was able to shutdown all the dbs, but still listeners are up, how to shutdown them?

because lsnrctl stop <name>

is giving error ...
0
slightwv (䄆 Netminder) Commented:
The online docs are your friend:
srvctl stop listener

Stops the default listener on the specified node_name, or the listeners represented in a given list of listener names, that are registered with Oracle Clusterware on the given node.

http://docs.oracle.com/cd/E11882_01/rac.112/e41960/srvctladmin.htm#CDCCGBAA
0
Mushfique KhanDirector OperationsAuthor Commented:
thanks was able to stop the LISTENER associated with the dbs, but what about this SCAN one, can see 2 on one node and 1 on another
0
slightwv (䄆 Netminder) Commented:
>> but what about this SCAN one, can see 2 on one node and 1 on another

What SCAN one?  Remember I'm not a RAC Expert.
0
manzoor_dbaCommented:
>>This is needed for some OS maintenance.<<

If your planning to reboot the server or you want all the gird/db/listener process to be down you can use the 'crsctl stop crs' command to shutdown the whole clusterware. This command will shutdown db/listener/scan etc... in one shot.  Execute this command on each node as root user. This will be located inside the bin folder under GRID HOME.

When the server reboots all the services will be up automatically, to bring up manually you can use 'crsctl start crs'.

Thanks.
0
Mushfique KhanDirector OperationsAuthor Commented:
No root access :-(
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.