Link to home
Start Free TrialLog in
Avatar of Mushfique Khan
Mushfique Khan

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Reminder to read in context; the above referenced link explains more if you just look around in the document.
Avatar of Mushfique Khan
Mushfique Khan

ASKER

thanks ... but just for the verification purpose, is everything up, running & good too, what to execute & checked/verified, before and after too ... shutdown/restart?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>>, 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.
mean to say, relevant to the db shutdown & restart only, is there any thing to check/verify?
>>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.
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.
was able to shutdown all the dbs, but still listeners are up, how to shutdown them?

because lsnrctl stop <name>

is giving error ...
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
>> 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.
>>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.
No root access :-(