Friday, May 7, 2010

Apply Oracle Database release 10.2.0.4 patch (6810189_10204) on Oracle Database 10g Release 2 (10.2.0.3) 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


Prerequisite Check


Oracle Configuration Manager


Installtion Summary Screen


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.
 
Dbua introduction screen


 
Select the instance for upgrade


I have selected the default option


To improve the performance of upgrade , please uncheck the invalid objects compilation. I have done this after the database upgrage.

Backup database , if you didn't taken earlier


Flash_recovery area setup

Summary


Progress Screen


100% Complete


Upgrade results.

after finish upgrade use the following command to compile invalid objects in the database:
$sqlplus / as sysdba

No comments: