Steps to Patch Oracle 10.2.0.4.0 to 10.2.0.5.0

This activity will patch the Oracle database version from 10.2.0.4.0 to 10.2.0.5.0 in Windows Server 2003 64 bit.

Installation

Launch the Oracle Universal Installer. From the initial welcome screen, click Next.

Specify the home details.

Click Next.

Ensure the prerequisite check is passed. Then, click Next.

Review the summary and click Install.

Installation begin.

The installation is complete.

Upgrade

Open the Database Upgrade Assistant. From the initial screen, click Next.

Select the database that you want to upgrade. Click Next.

Select Do Not Move Database Files as Part of Upgrade. Click Next.

Select to Recompile invalid objects at the end of upgrade. Based on the number of CPUs detected, Oracle has set the following default degree of parallelism. Click Next.

Backup the database before the patching. If you have already backed up the database, click Next.

Click Next.

Review the summary. On confirmed, click Install.

The patching begin.

The patching is complete.

Verify.

SQL> select INSTANCE_NAME, VERSION from V$INSTANCE;

INSTANCE_NAME    VERSION
---------------- -----------------
ely              10.2.0.5.0