• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How To Change Timezone for Oracle Grid Infrastructure

by admin

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

Filed Under: Linux, oracle, RAC, Solaris

Some more articles you might also be interested in …

  1. Understanding the nfsiostat command output (Examples Included)
  2. Oracle Database Interview Questions : Redo Logs and Archiving
  3. lshw: command not found
  4. Database Crashed With ORA-19815, ORA-19809, ORA-16038
  5. pngcheck Command Examples in Linux
  6. Linux OS Service ‘yum-updatesd’
  7. How to send mails with attachments using the solaris mailx command
  8. Linux OS Service ‘NetworkManagerDispatcher’
  9. How to Audit File Access on Linux
  10. Understanding How Umask Controls the Initial File / Directory Permissions in Linux

You May Also Like

Primary Sidebar

Recent Posts

  • qsub Command Examples in Linux
  • qsub: command not found
  • qrcp Command Examples in Linux
  • qmrestore Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright