"Translated from MoS article" How to change time zone in 11gr2 gi?

Source: Internet
Author: User
Tags time zones how to change time

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?

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.