Applying “version 4″ Time Zone Files on an Oracle Database

Applying “version 4″ Time Zone Files on an Oracle Database

Applying “version 4″ Time Zone Files on an Oracle Database if your timezone file version is less than 4
Yesterday I was upgrading the database form 10.2.0.3 to 10.2.0.5 on RHEL 5,
In readme of the 10.2.0.5 patch i came across the timezoe files,
We need to upgarde the timezone files of the base database to 4, is minimum requirement.
I found my timezone files 3,

you can use following query to find the timezone of the database:

SQL> select * from v$timezone_file;
FILENAME        VERSION
------------ ----------
timezlrg.dat          3

 

If  your database versions are 9.2.0.8 & 10.2.0.4,your  timezone file version will be 4 by default,

upgrading to 11.1.0.6.0  or 11.2.0.1.0 we need timezone version 4,

If your database is 9.2.0.7, we need to upgarde it to 9.2.0.8

 or database versions are 10.2.0.1, 10.2.0.2, 10.2.0.3, then we need to upgarde the database to 10.2.0.4 then to upgrade the 11.2.0.1

Another & Best way is to apply the  “version 4″ Time Zone Files on an Oracle Database  

you can file the patches for your version from the metalink ID ID 413671.1

Go to end of the article,  Identify your version from the table, apply the patch,
your timezonefile version will be updated to 4, & you can proceed for the upgradation to 11g R1, 11gR2
Please refer the following link for applying OPATCH
http://deveshdba.wordpress.com/2011/09/14/applying-opatch/
Check your opatch utility working fine,

[oracle@primary OPatch]$ cd $ORACLE_HOME/OPatch
[oracle@primary OPatch]$ ./opatch version
Invoking OPatch 10.2.0.3.0
OPatch Version: 10.2.0.3.0
OPatch succeeded.
[oracle@primary OPatch]$ ./opatch lsinventory
Invoking OPatch 10.2.0.3.0
Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation.  All rights reserved..

Oracle Home       : /oracle/10201
Central Inventory : /oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.3.0
OUI version       : 10.2.0.3.0
OUI location      : /oracle/10201/oui
Log file location : /oracle/10201/cfgtoollogs/opatch/opatch2011-07-07_12-08-57PM.log
Lsinventory Output file location : /oracle/10201/cfgtoollogs/opatch/lsinv/lsinventory2011-07-07_12-08-57PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 2                            10.2.0.3.0
There are 2 products installed in this Oracle Home.

Interim patches (2) :
Patch  5556081      : applied on Thu Jul 07 11:20:32 GMT+05:30 2011
   Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
   Bugs fixed:
     5556081
Patch  5557962      : applied on Thu Jul 07 11:20:24 GMT+05:30 2011
   Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
   Bugs fixed:
     4269423, 5557962, 5528974

--------------------------------------------------------------------------------

donwload the patch, unzip it, Follow the instructions in readme of the patch, & apply.

 
[oracle@primary OPatch]$ ./opatch apply
Invoking OPatch 10.2.0.3.0
Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation.  All rights reserved..

Oracle Home       : /oracle/10201
Central Inventory : /oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.3.0
OUI version       : 10.2.0.3.0
OUI location      : /oracle/10201/oui
Log file location : /oracle/10201/cfgtoollogs/opatch/opatch2011-07-07_12-13-56PM.log
ApplySession applying interim patch '5632264' to OH '/oracle/10201'
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/10201')
Is the local system ready for patching?
Do you want to proceed? [y|n]
Y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '5632264' for restore. This might take a while...
Backing up files affected by the patch '5632264' for rollback. This might take a while...
Patching component oracle.oracore.rsf, 10.2.0.3.0...
Copying file to "/oracle/10201/oracore/zoneinfo/timezone.dat"
Copying file to "/oracle/10201/oracore/zoneinfo/timezlrg.dat"
Copying file to "/oracle/10201/oracore/zoneinfo/readme.txt"
ApplySession adding interim patch '5632264' to inventory
Verifying the update...
Inventory check OK: Patch ID 5632264 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 5632264 are present in Oracle Home.
The local system has been patched and can be restarted.

restart the database & check the timezone file version,

 

SQL> startup
ORACLE instance started.
Total System Global Area  943718400 bytes
Fixed Size                  1265172 bytes
Variable Size             591397356 bytes
Database Buffers          348127232 bytes
Redo Buffers                2928640 bytes
Database mounted.
Database opened.
SQL> select * from v$timezone_file;
FILENAME        VERSION
------------ ----------
timezlrg.dat          4