ODA Workaround for Turkey Daylight Savings Time for October 2016 ( Oracle Database Appliance )

Asset ID:	1-72-2197632.1
Update Date:	2016-10-31
Keywords:

Solution Type Problem Resolution Sure

Solution 2197632.1 : ODA Workaround for Turkey Daylight Savings Time for October 2016 ( Oracle Database Appliance )

Applies to:

Oracle Database Appliance - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Symptoms

Oracle Database Appliance configuration impacted by Turkey's recent 2016 TZ rules change to retain the UTC +3:00 offset indefinitely.

NOTE: Not all users will require updating the TZ settings or the steps and information provided in this note:

IF you are not using Turkey Timezone offsets for your servers, clients,agent or business needs including scheduling or data you may want to wait until the upcoming 12.1.2.9 ODA Patch Bundle.
The upcoming ODA 12.1.2.9 patchset bundle will include the definitions for the Turkey Timezone changes as well as other TZ values as appropriate.

Changes

These steps are for Oracle Database Appliance users and configuration impacted by Turkey's recent 2016 TZ rules change to retain the UTC +3:00 offset indefinitely.

Cause

Change existing 2016 Timezone Offset definitions for Turkey due to suspending any future TZ changes.

Solution

This note will show steps to:

Use the Oracle Database Appliance (ODA) Stand-alone Configurator to alter an existing (or newly created) onecommand.params file
Alter the Timezone in the configurator to use a UTC +03:00 Named Offset Compliant Timezone which is not subject to Daylight Savings Time (DST) offsets
Run the ./GridInst.pl manual step to set the new UTC +03:00 Timezone offset
How to confirm that the UTC +03:00 Timezone offset has been enabled on each node

Countries in GMT+3 Time Zone

The following countries are known to use the static GMT+3 value as their Time Zone.

i.e. No Summer Time / Daylight Saving Time is used.

Bahrain Comoros , Djibouti , Eritrea , Kuwait , Kenya , Madagascar , Republic of Moldova (Transnistria Region only) Qatar Saudi Arabia , Somalia , Sudan , Tanzania , Uganda , Yemen

Kenya , Nairobi uses a fixed +03:00 offset* (No Summer Time / Daylight Saving Time)

Kenya , Nairobi can be used with the ODA configurator to alter onecommand.params file as an alternative Timezone

The onecommand.params files can also be manually altered directly as the user root or using the ODA configurator

[root...]# cd /opt/oracle/oak/onecmd

save a copy of the oncommand.params file

[root...]# cp onecommand.param onecommand.param.old

Second screen of the ODA Configurator will show System settings including Country / Region and Named Timezone

Configurator pg2 shows SYSTEM settings for TZ

Configurator pg2 shows SYSTEM settings for TZ Nairobi

Non-GUI

[root...]# vi onecommand.params file

- edit the line under the second section labeled ClusterInfo

# CLUSTERINFO
....
TIMEZONE= ..... value and change to
TIMEZONE=Africa/Nairobi

- Save the file (wq! oncommand.params)
and return back to the command line
- from the same directory execute ./GridInst -s 7

[root...]# ./GridInst -s 7

This should run the Step 7 SetTimezone which will be set on both nodes of the ODA

- Once completed you will see a logfile generated and the " Exiting.....
- You can confirm if the Timezone has been succesfully altered on BOTH nodes by issuing:

# date +'%:z'

- This should show as the following
# date +'%:z'
+03:00
- Issue the same command from the second node

# date +'%:z'
+03:00

*Comment: Some of the other regions with a fixed UTC +03:00 (not using DST include) Madagascar , Republic of Moldova (Transnistria Region only) Qatar Saudi Arabia , Somalia , Sudan , Tanzania , Uganda , Yemen.

Attachments

This solution has no attachment