Apply Oracle Database release 10.2.0.3 patch (5337014_10203) on Oracle Database 10g Release 2 (10.2.0.2) Installation On Red Hat Enterprise Linux 5 (RHEL5)

Preinstallaltion Task

• Shutdown the database instance cleanly
• Stop the database listner
• Stop the EM (emctl stop dbconsole)
• Set up environment variables ORACLE_HOME & ORACLE_SID  
• Backup the system

 

Installation

  

       Extract the path into a temprory directory

 

      Run the installer from the patch directory

 

$./runInstaller

Welcome Screen

Oracle Home Details

Installation Summary

 

After finish the installation click finish button.

 

Post Installation

 

  If you are interest to conitnue manual (non-iteractive process)process you can follow the same procedure on patch 1 post installation

 

Otherwise you can use dbua.

 

start the listner using the foloowing command

$lsnrctl start

$dbua

follow the instruction on the screen and start the database upgrade process. Uncheck the invalid objects compilation while upgrade. This will slowdown the upgrade process.

 

 

Upgrade process progress screen shot

After finish the upgrade process use the following command to compile the invalid objects

$sqlplus / as sysdba

$@$ORACLE_HOME/rdbms/admin/utlrp