Steps for changing the time zone of Oracle10grac + javasuard In the AIX Environment

Due to the installation problem of the AIX operating system, the default time zone is the end of the DCT, and the time zone ending with the DCT is the summer time system. At on January 1, March 11, the system will automatically move forward for one hour.

Due to the installation problem of the AIX operating system, the default time zone is the end of the DCT, and the time zone ending with the DCT is the summer time system. At on January 1, March 11, the system will automatically move forward for one hour.

Due to the installation problem of the AIX operating system, the default time zone is the end of the DCT, and the time zone ending with the DCT is the summer time system. At on January 1, March 11, the system will automatically move forward for one hour, because the database collects system time, the application time is one hour ahead of schedule, and the database status is inconsistent due to the change time, you must follow the specific steps. The following describes how to change the rac + replicuard environment:

1. Change the dataguard time zone:

View the time zone of the standby physical database

# Echo $ TZ
CST6CDT

View the status of the standby physical database

SQL> select open_mode from v $ database;

OPEN_MODE
----------
MOUNTED

Stop backup physical database

SQL> conn/as sysdba
Connected.
SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
Oracle instance shut down.

Change the time zone to GMT + 8

Asia/Shanghai (GMT + 08:00) China Standard

Restart the server and change the time, but do not start the backup database.

# Shutdown-Fr