The Geek Diary

How To Change Timezone for Oracle Grid Infrastructure

by

This post illustrates how to change timezone setting for Grid Infrastructure after installation.

Note:
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:

  1. For 11.2.0.1, shell environment variable TZ is set correctly for grid user and root.
  2. 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
Note: ‘timedatectl‘ command can be used to query and change the system clock/timezone in CentOS/RHEL 7.

– 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.

Note: The “Zone” field in /etc/sysconfig/clock could be different than what’s in /usr/share/zoneinfo in CentOS 6.x/RHEL 6.x, the one from /usr/share/zoneinfo should be used in $GRID_HOME/crs/install/s_crsconfig_[nodename]_env.txt

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

You May Also Like