This post illustrates how to change timezone setting for Grid Infrastructure after installation.
To check the current time zone on Linux, use the command: “timedatectl | grep ‘Time zone’”
To check the current time zone on Windows, use the command: “systeminfo | findstr /C:”Time Zone”“
Grid Time Zone Setting
Once OS default timezone is changed, make sure:
- For 11.2.0.1, shell environment variable TZ is set correctly for grid user and root.
- For 11.2.0.2 and above, TZ entry in $GRID_HOME/crs/install/s_crsconfig_[nodename]_env.txt sets to correct time zone.
The TZ must be exactly as what the OS supports, i.e.:
# grep TZ s_crsconfig_[nodename]_env.txt TZ=US/Pacific
Below is a bad example since there’s irrelevant characters (An incorrectly set time zone may cause issues like session shows wrong timestamp when connecting through listener).
TZ=%s_Asia/Kuala Lumpur%
Backup before making a change with en editor. Once modified and verified as privileged user, GI can be restarted with new value. For pre-11.2 CRS, “init.cssd diag” can be used to confirm TZ setting for CRS; init.cssd could be located in /etc/init.d, /etc or /sbin/init.d depending on the platform.
OS Default Timezone Setting
Linux
– To change:
/usr/sbin/timeconfig
– To display current setting:
# cat /etc/sysconfig/clock ZONE="America/Los_Angeles" UTC=true ARC=false
– To find out all valid setting:
# ls -l /usr/share/zoneinfo
Anything that appears in this directory is valid to use, for example, CST6CDT and America/Chicago.
HP-UX
– To display current setting:
# cat /etc/default/tz PST8PDT
– To change:
# set_parms timezone
– To find out all valid setting:
# ls -l /usr/lib/tztab
Solaris
– To display current setting:
# grep TZ /etc/TIMEZONE TZ=US/Pacific
– To change on x64, modify TIMEZONE, also run below command:
# rtc -z US/pacific; rtc -c
– To find out all valid settings:
# ls -l /usr/share/lib/zoneinfo
For Solaris 11
In solaris 11 the /etc/TIMEZONE file is obsoleted. This is now done via the “timezone:default” service:
# svccfg -s timezone:default setprop timezone/localtime= astring:# svcadm refresh timezone:default
AIX
– To display current setting:
# grep TZ /etc/environment TZ=GMT