Wednesday, October 31, 2012

Changing timezone in Oracle 11g RAC

In order to change timezone of all processes running under control of Oracle 11g RAC (alter log dates and other relevant information), you should edit on the each node of the cluster file CRS_HOME/crs/install/s_crsconfig_HOSTNAME_env.txt and change variable TZ. For an instance:

1. Stop all RAC processes on the node:

/etc/init.d/ohasd stop

2. vi /crs/crs/install/s_crsconfig_xxx_env.txt

3. Comment out old timezone definition
#TZ=GMT+03:00

and add new one

TZ=Europe/Minsk

4. Start your RAC stack on the node

/etc/init.d/ohasd start

No comments:

Post a Comment