Leap Second

New trouble with this time ...

Now the earth is spinning smoothly, and therefore

after    June 30, 2015 23:59:59

become   June 30, 2015 23:59:60

not a    July 01, 2015 at 00:00:00

Encyclopedia for this problem:

http://matheusdba.com.br/2015/05/31/leap-second-impact-for-oracle-database-june-30-2015-at-235959/?utm_content=buffera3eff&utm_medium=social&utm_source=linkedin.com&utm_campaign=buffer

 

Ты готов к переводу стрелок часов ?

26 октября переведутся стрелки часов и надо подготовиться к этому моменту.

Патч на СУБД можно найти в нотах

The Russian Government re-introduces DST in 2014 - Impact on Oracle RDBMS (Doc ID 1907147.1)

Applying the DSTv23 update for the Oracle Database (Doc ID 1907093.1)

Его надо поставить заранее. На все Oracle Home какие только есть. :)

 В Экзадатовских патчах этого патча не будет:

Exadata and DST (timezones) (Doc ID 1343576.1):

"Exadata updates do not contain the updated timezone (tzdata) files."

ORA-30094: failed to find the time zone data file for version ... in $ORACLE_HOME/oracore/zoneinfo

We have the one 11.2.0.3 DB + latest time zone installed on it - version 19.
Imagine our surprise when we've got the message during the import:

ORA-39097: Data Pump job encountered unexpected error -30094
ORA-39065: unexpected master process exception in DISPATCH
ORA-30094: failed to find the time zone data file for version 17 in $ORACLE_HOME/oracore/zoneinfo


Why ? How it is possible ? Why Oracle not used latest time zone ?

We don't know, but we have the solution :



download the appropriate version of the DST (version 17 for our case, p12949905_112030_Linux-x86-64.zip) and unzip it somewhere:

[oracle@ed01db01 DST]$ unzip p12949905_112030_Linux-x86-64.zip
Archive:  p12949905_112030_Linux-x86-64.zip
   creating: 12949905/
  inflating: 12949905/README.txt
  inflating: 12949905/README.html
   creating: 12949905/files/
   creating: 12949905/files/oracore/
   creating: 12949905/files/oracore/zoneinfo/
  inflating: 12949905/files/oracore/zoneinfo/readme_17.txt

   creating: 12949905/files/oracore/zoneinfo/little/
  inflating: 12949905/files/oracore/zoneinfo/little/timezone_17.dat
  inflating: 12949905/files/oracore/zoneinfo/little/timezlrg_17.dat
  inflating: 12949905/files/oracore/zoneinfo/timezone_17.dat

   creating: 12949905/files/oracore/zoneinfo/big/
  inflating: 12949905/files/oracore/zoneinfo/big/timezone_17.dat
  inflating: 12949905/files/oracore/zoneinfo/big/timezlrg_17.dat
  inflating: 12949905/files/oracore/zoneinfo/timezlrg_17.dat

   creating: 12949905/etc/
   creating: 12949905/etc/config/
  inflating: 12949905/etc/config/inventory.xml
  inflating: 12949905/etc/config/actions.xml
  inflating: 12949905/etc/config/deploy.xml
   creating: 12949905/etc/xml/
  inflating: 12949905/etc/xml/GenericActions.xml
  inflating: 12949905/etc/xml/ShiphomeDirectoryStructure.xml


 
As we know, Oracle hold the time zone files in $OH/oracore/zoneinfo.
Therefore, simply copy red files from patch into $OH/oracore/zoneinfo directory.
Don't forget about directory structure and save latest $OH/oracore/zoneinfo/readme_19.txt (don't copy old readme_17.txt file from patch into your $OH)

For example:

[oracle@ed01db01 zoneinfo]$ rm /store/DST/12949905/files/oracore/zoneinfo/readme_17.txt
[oracle@ed01db01 zoneinfo]$ ls -l /store/DST/12949905/files/oracore/zoneinfo/*
-rw-rw-rw- 1 oracle oinstall 779003 Oct 14  2011 /store/DST/12949905/files/oracore/zoneinfo/timezlrg_17.dat
-rw-rw-rw- 1 oracle oinstall 341718 Oct 14  2011 /store/DST/12949905/files/oracore/zoneinfo/timezone_17.dat

/store/DST/12949905/files/oracore/zoneinfo/big:
total 1108
-rw-rw-rw- 1 oracle oinstall 779003 Oct 14  2011 timezlrg_17.dat
-rw-rw-rw- 1 oracle oinstall 341718 Oct 14  2011 timezone_17.dat

/store/DST/12949905/files/oracore/zoneinfo/little:
total 1108
-rw-rw-rw- 1 oracle oinstall 779003 Oct 14  2011 timezlrg_17.dat
-rw-rw-rw- 1 oracle oinstall 341718 Oct 14  2011 timezone_17.dat
 
[oracle@ed01db01 zoneinfo]$  cd $OH/oracore/zoneinfo
[oracle@ed01db01 zoneinfo]$ cp -r /store/DST/12949905/files/oracore/zoneinfo/* .
[oracle@ed01db01 zoneinfo]$ ls -l
total 15680
drwxr-xr-x 2 oracle oinstall   4096 May  8 12:33 big
drwxr-xr-x 2 oracle oinstall   4096 May  8 12:33 little
-rwxrwxrwx 1 oracle oinstall   7395 Dec 31 12:11 readme_19.txt
-rw-r--r-- 1 oracle oinstall   6068 Jun  7  2010 readme.txt
-rw-r--r-- 1 oracle oinstall  31525 Jun  7  2010 timezdif.csv
-rw-r--r-- 1 oracle oinstall 792894 Aug 18  2011 timezlrg_10.dat
-rw-r--r-- 1 oracle oinstall 787272 Aug 18  2011 timezlrg_11.dat
-rw-r--r-- 1 oracle oinstall 785621 Aug 18  2011 timezlrg_12.dat
-rw-r--r-- 1 oracle oinstall 782475 Aug 18  2011 timezlrg_13.dat
-rw-r--r-- 1 oracle oinstall 791430 Aug 18  2011 timezlrg_14.dat
-rw-r--r-- 1 oracle oinstall 779003 May  8 12:33 timezlrg_17.dat
-rwxr-xr-x 1 oracle oinstall 785786 Dec 31 12:11 timezlrg_19.dat
-rw-r--r-- 1 oracle oinstall 493675 Aug 18  2011 timezlrg_1.dat
-rw-r--r-- 1 oracle oinstall 507957 Aug 18  2011 timezlrg_2.dat
-rw-r--r-- 1 oracle oinstall 527717 Aug 18  2011 timezlrg_3.dat
-rw-r--r-- 1 oracle oinstall 531137 Aug 18  2011 timezlrg_4.dat
-rw-r--r-- 1 oracle oinstall 587487 Aug 18  2011 timezlrg_5.dat
-rw-r--r-- 1 oracle oinstall 586750 Aug 18  2011 timezlrg_6.dat
-rw-r--r-- 1 oracle oinstall 601242 Aug 18  2011 timezlrg_7.dat
-rw-r--r-- 1 oracle oinstall 616723 Aug 18  2011 timezlrg_8.dat
-rw-r--r-- 1 oracle oinstall 801410 Aug 18  2011 timezlrg_9.dat
-rw-r--r-- 1 oracle oinstall 345637 Aug 18  2011 timezone_10.dat
-rw-r--r-- 1 oracle oinstall 345356 Aug 18  2011 timezone_11.dat
-rw-r--r-- 1 oracle oinstall 345024 Aug 18  2011 timezone_12.dat
-rw-r--r-- 1 oracle oinstall 344425 Aug 18  2011 timezone_13.dat
-rw-r--r-- 1 oracle oinstall 344448 Aug 18  2011 timezone_14.dat
-rw-r--r-- 1 oracle oinstall 341718 May  8 12:33 timezone_17.dat
-rwxr-xr-x 1 oracle oinstall 343167 Dec 31 12:11 timezone_19.dat
-rw-r--r-- 1 oracle oinstall 274427 Aug 18  2011 timezone_1.dat
-rw-r--r-- 1 oracle oinstall 274900 Aug 18  2011 timezone_2.dat
-rw-r--r-- 1 oracle oinstall 286651 Aug 18  2011 timezone_3.dat
-rw-r--r-- 1 oracle oinstall 286264 Aug 18  2011 timezone_4.dat
-rw-r--r-- 1 oracle oinstall 286310 Aug 18  2011 timezone_5.dat
-rw-r--r-- 1 oracle oinstall 286217 Aug 18  2011 timezone_6.dat
-rw-r--r-- 1 oracle oinstall 286815 Aug 18  2011 timezone_7.dat
-rw-r--r-- 1 oracle oinstall 302100 Aug 18  2011 timezone_8.dat
-rw-r--r-- 1 oracle oinstall 351525 Aug 18  2011 timezone_9.dat
[oracle@ed01db01 zoneinfo]$