How do I change the time zone in 11gr2 gi?
From:
How to change Timezone for 11gR2 Grid Infrastructure (document ID 1209444.1)
Suitable for:
Oracle database-enterprise edition-version 11.2.0.1 and later
Information in this document applies to any platform.
Goal:
This article is used to demonstrate how to change the time zone after the 11GR2 GI installation is complete.
Solution:
Translator Note:
The so-called timezone is actually divided into two parts: Grid time zone Setting and OS Default Timezone Setting. The following is a separate description
Grid Time Zone Setting:
Once the default time zone for the operating system changes, be sure to do the following:
1. For 11.2.0.1, the grid user and root user's shell environment variable TZ are set correctly
2. For 11.2.0.2 and later, the TZ entry in the $GRID _home/crs/install/s_crsconfig_<nodename>_env.txt file needs to be set to the correct time zone
TZ must be an OS-supported TZ, such as:
grep TZ s_crsconfig_<nodename>_env.txt tz=us/pacific
The following is an example of an incorrect TZ, because there are irrelevant characters in it (an incorrect time zone setting may result in an error when the session is connected to the database via the listener)
Tz=%s_asia/kuala lumpur%
Please back up before modifying. Once the modification is complete and authenticated by a user with permission, GI can be restarted.
For CRS before 11.2, "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 the time zone, use:
/usr/sbin/timeconfig
Displays the status of the current time zone:
Cat/etc/sysconfig/clockzone= "America/los_angeles" Utc=truearc=false
The following command displays all of the valid time zone settings:
Ls-l/usr/share/zoneinfo
Any time zone displayed in this directory (/usr/share/zoneinfo) is available for use, such as CST6CDT and America/chicago
Note: In ol6.3/rhel6.3, the "Zone" field in/etc/sysconfig/clock is different from the/usr/share/zoneinfo.
The time zone information in the/usr/share/zoneinfo should be used for $grid_home/crs/install/s_crsconfig_<nodename>_env.txt
HP-UX
Display the settings for the current time zone:
Cat/etc/default/tzpst8pdt
Change Time zone:
Set_parms timezone
To find all valid time zones:
Ls-l/usr/lib/tztab
Solaris
Displays the current settings:
grep tz/etc/timezonetz=us/pacific
To change on x64, modify TIMEZONE, also run "rtc-z us/pacific; Rtc-c "
To find out all valid Settings:ls-l/usr/share/lib/zoneinfo
For Solaris 11:
In Solaris 11,/etc/timezone This file is deprecated (obsoleted). In Solaris 11, you need to modify the time zone by Timezone:default service
# svccfg-s Timezone:default setprop timezone/localtime= astring: <timezone># svcadm Refresh Timezone:default
Aix:
Displays the current settings:
grep tz/etc/environmenttz=gmt
For the time zone on AIX, refer to:
Http://publib.boulder.ibm.com/infocenter/pseries/v5r3/index.jsp?topic=/com.ibm.aix.files/doc/aixfiles/environment.htm
"Translated from MoS article" How to change time zone in 11gr2 gi?