After Oracle Linux 7, Timezone settings method has been changed. Time Zone is configured during the deployment of the Exadata Database Machine. If there is a requirement to change the Time Zone settings after deployment, it requires modifying the following components:
- Storage Cells
- Compute Nodes
Pre-requirements
1. Stop CRS stack on all the compute nodes:
# [GI_HOME]/bin/crsctl stop crs
2. Stop processes on the cells:
# cellcli -e alter cell shutdown services all
3. Complete changes on all the storage cells before moving into the compute nodes.
Changing Time Zone on the Storage Cells
Please follow the instructions in the manual.
Change Time Zone Settings on Exadata Storage Servers
Changing Time Zone on the compute nodes
After modifying the time zone setting on the storage cells, you can change the time zone setting on the database servers.
Before starting this procedure, you should have already stopped the Oracle Clusterware stack and modified the time zone on the storage cells.
1. Change the Oracle Clusterware settings to prevent the CRS stack from starting automatically after restarting the database server.
# [GI_HOME]/bin/crsctl disable crs
2. As the root user, run the below command.
# timedatectl set-timezone [TIMEZONE]
For example:
# timedatectl set-timezone America/Chicago
3. Reboot the database server.
4. Verify the date has been changed on the database server. Use the date command verify the change for the time zone.
# date Tue Jan 29 13:08:46 EDT 2019
5. Change the Oracle Clusterware settings to automatically restart the CRS stack after restarting the database server.
# [GI_HOME]/bin/crsctl enable crs
6. Start the CRS stack on the database server.
# [GI_HOME]/bin/crsctl start crs