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.
This is needed for some OS maintenance.
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Reminder to read in context; the above referenced link explains more if you just look around in the document.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>, 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.
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.
ASKER
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.
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.
ASKER
was able to shutdown all the dbs, but still listeners are up, how to shutdown them?
because lsnrctl stop <name>
is giving error ...
because lsnrctl stop <name>
is giving error ...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
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.
ASKER
No root access :-(