Home

Welcome to DBA World!
Best Corporate Real Time Training on Oracle 12C/11G/10G DBA by Expert 10+yrs Exp
Call us for Enquiries : 9550720899

Patch Upgrade from 10.2.0 to 10.2.0.4

PatchSets For 10.1.0.X.0
************************
The BASE release of Oracle 10g Release 1 is 10.1.0.2 .( Click Here to Download)
(The above link takes to Oracle Technology Network and requires OTN username and password)


PatchSet                    Number      Link To Download
*******************************************************************
10.1.0.3.0                      3761843         Patch 3761843
10.1 Patch Set 1         
10.1.0.4.0                      4163362          Patch 4163362
10.1 Patch Set 2
10.1.0.5.0                      4505133     Patch 4505133
10.1 Patch Set 3 (Terminal )

PatchSets For 10.2.0.X.0
************************
The BASE release of Oracle 10g Release 2 is 10.2.0.1.( Click Here to Download)
(The above link takes to Oracle Technology Network and requires OTN username and password)



PatchSet                    Number      Link To Download
*******************************************************************
10.2.0.2.0                     4547817          Patch 4547817
10.2 Patch Set 1
10.2.0.3.0                5337014       Patch 5337014
10.2 Patch Set 2
10.2.0.4.0                 6810189      Patch 6810189
10.2 Patch Set 3

PatchSets For 11.1.0.X.0
************************
PatchSet                    Number      Link To Download
*******************************************************************
11.1.0.7.0                     6890831       Patch 6890831
   



Patch Upgrade from 10.1.0 to 10.2.0.4 for Linux x86
***************************************************

1) Download p6810189_10204_Linux-x86 from Metalink
2) For information about physical standby databases, review document 278641.1.
   For information about logical standby databases, review document 278643.1.
3) $ unzip p6810189_10204_Linux-x86.zip
4) Update Oracle Time Zone Definitions
   SELECT version FROM v$timezone_file;

SQL> SELECT version FROM v$timezone_file;

   VERSION
----------
         4

If lesser or higher than 4 then read NoteID 553812.1 "Actions for the DSTv4 update in the Release 10.2.0.4

patchset".

5) set Env Variables

  $ ORACLE_HOME=Oracle_home
  $ ORACLE_SID=sid
  $ export ORACLE_HOME ORACLE_SID

6) Run interactively

   % cd patchset_directory/Disk1
   % ./runInstaller
 
  When prompted, run the $ORACLE_HOME/root.sh