How to change the timezone

1. Change the timezone used in the OS:

Note: In the case of the FlashGrid cluster, this procedure must be performed on all cluster nodes (database and quorum)

List available timezones:

# timedatectl list-timezones

Set the desired timezone (e.g. America/New_York):

# timedatectl set-timezone America/New_York

Check if the timezone was set:

# timedatectl status

2. Change the timezone used in the Grid Infrastructure:

Note: For the FlashGrid cluster, this procedure must be performed only on database nodes.

As the user grid, change the variable TZ to match your desired timezone in the following file:

/u01/app/19.3.0/grid/crs/install/s_crsconfig_<your_db_node>_env.txt

and restart the Grid Infrastructure when possible.

The TZ variable must exactly match what the OS supports.

References:

How To Change Timezone for Grid Infrastructure (Doc ID 1209444.1)

Timestamps & time zones ;- Frequently Asked Questions (Doc ID 340512.1)