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

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • 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 – How to recover from a lost datafile with no backup
  2. What are Command Rules in oracle Database
  3. Managing Oracle Database Backup with RMAN (Examples included)
  4. How to Shrink the datafile of Undo Tablespace in Oracle Database
  5. How to Modify spfile in Oracle Database
  6. How to Manage Oracle database Audit File Directory Growth with cron (ASM Instances Only)
  7. How to duplicate a Oracle Database to a previous Incarnation
  8. Oracle ASM 11gR2 instance is unable to start due to missing ASM spfile
  9. How to Use Udev Rules to Create oracleasm Disks in CentOS/RHEL 8
  10. Beginners Guide to Monitoring SQL Statements with Real-Time SQL Monitoring in Oracle Database

You May Also Like

Primary Sidebar

Recent Posts

  • MySQL: how to figure out which session holds which table level or global read locks
  • Recommended Configuration of the MySQL Performance Schema
  • MySQL: Identify what user and thread are holding on to a meta data lock that is preventing other queries from running
  • MySQL: How to kill a Long Running Query using max_execution_time
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary