• 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. Oracleasm Service Fails to Start After Upgrade to oracleasm-support-2.1.11-1 RPM Package
  2. Oracle Net New Features in Oracle Database 12c
  3. Oracle RAC: How to modify private hostname, Private network IP & MTU
  4. Understanding Device Persistence and Oracle ASMLib
  5. How To Run ggsci In “silent” Mode
  6. WebLogic Server Domain: How To Disable the HTTP methods other than GET and POST (such as PUT, DELETE, etc.)
  7. JDeveloper Interview Questions
  8. Oracle 11g – New ASM features
  9. Oracle RMAN 11g New Feature – MultiSection Backups
  10. Basics of client connectivity in Oracle Data Guard configuration

You May Also Like

Primary Sidebar

Recent Posts

  • powertop Command Examples in Linux
  • powertop: command not found
  • powerstat: command not found
  • powerstat Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright