Friday 3 August 2012

RAC Server Time Change

Hi Friends,

I would like to share the activity that i was done last week.

In RAC server both the server timings were behind 20 minutes of IST.

I had to change, I thought it was a big activity if anything goes wrong server would crash down.

But it was very simple, its not complecated as changing the TIMEZONE.

You can find the below steps to do this on Linux operating system.
Login as Oracle user

a) First shut the enterprise manager $ emctl stop dbconsole ( do this on both nodes)
b) Shutdown the database $ srvctl stop database -d db_name                                
c) Stop nodeapps ( do this on both nodes) $ srvctl stop nodeapps -n node
Login as root
Stop ASM and CRS ( do this on both nodes)
# crsctl stop cluster -all   
     
Change the time
login as root ( do this on both the nodes)
Example # date –s "3 JUN 2012 20:00:00"

Reboot both the Nodes

Issues Faced:

Since it is 11g you no need to stop nodeapps and ASM. stop cluster -all would stop all one by one

CRS was coming down properly, So  I used crsctl stop crs -f . With force i was able to down the CRS.

Keep some 5 seconds difference between both nodes, secondary should be lagging.

Thanks.

Valuable comments are welcome.