675 views
in RAC by ACE (20,920 points)

1 Answer

by ACE (20,920 points)
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+05:30

and add new one

TZ=Europe/Minsk

4. Start your RAC stack on the node

/etc/init.d/ohasd start
...