• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How to Change Timezone Settings on Exadata

by admin

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

Note: When run ipconf script, timedatectl command is executed for timezone changing.

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
Note: no need copy file /etc/localtime and /etc/sysconfig/clock from any of the storage cells to the database server.

Filed Under: Exadata, oracle

Some more articles you might also be interested in …

  1. Oracle Database 12c New Feature: SYSRAC administrative privilege
  2. ORA-06512: at line num
  3. Oracle RMAN Pluggable Database Point in Time Recovery
  4. How to relocate or move oracle database files using RMAN
  5. How to Recover From Lost or Missing Database Parameter Files (PFILE or SPFILE)
  6. SQL*Plus Editing Commands
  7. CentOS / RHEL 7 : Oracleasm Create Disk Failed “Instantiating disk: failed”
  8. Oracle Grid 12c: Read Only Instances on Leaf Nodes
  9. Oracle Database 12c New Feature – Move a Datafile Online
  10. Oracle RMAN: Monitoring Recovery Manager Jobs

You May Also Like

Primary Sidebar

Recent Posts

  • JavaFX ComboBox: Set a value to the combo box
  • Nginx load balancing
  • nginx 504 gateway time-out
  • Images preview with ngx_http_image_filter_module

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright