oracle 1小时之前,客户端访问数据库时间快了1小时，如何解决？

This note is to illustrate how to change time zone setting for 11.2 Grid Infrastructure after installation.

Fix

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__env.txt sets to correct time zone.

The TZ must be exactly as what the OS supports, i.e.:

grep TZ s_crsconfig__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%

Once it's verified, GI can be restarted with new timezone.

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 depend on 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.

Note: the "Zone" field in /etc/sysconfig/clock could be different than what's in /usr/share/zoneinfo in OL6.3/RHEL6.3, the one from /usr/share/zoneinfo should be used in $GRID_HOME/crs/install/s_crsconfig__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, modify TIMEZONE, also run "rtc -z US/pacific; rtc -c"

To find out all valid settings: ls -l /usr/share/lib/zoneinfo

AIX

To display current setting:

grep TZ /etc/environment

TZ=GMT