The activity is to patch Oracle version 10.2.0.1.0 to version 10.2.0.4.0 using the following environments,
Windows Server 2003 64 bit
Oracle 10g
Oracle VirtualBox
Prerequisites
Rectify the current installed Oracle database version and download the necessary installer from the Oracle website.
Stop all the following Oracle services
• Shutdown the Oracle database
• Oracle Enterprise Manager Console
• iSQLPlus
• Oracle Listener
Installation
Launch the Oracle Universal Installer. Click Next.
Specify the home details. Enter the name for the installation and the full path of where you want to install the product.
The next screen is the Product-Specific Prerequisite Checks. The installer will verifies that your environment meets all of the minimum requirements for installing, configuring and upgrading the Oracle database. You must check and solved any found errors before continuing to the next stage. Click Next.
If you do have Metalink account, you can select to Enable Oracle Configuration Manager. The option allows you to associate your configuration information with your Metalink account. Else, just click Next.
The summary screen. Click Install.
The progress!
The installation is completed. Click Exit.
Upgrade
Set the environment variables for ORACLE_HOME, ORACLE_SID & PATH.
Bring up the Oracle listener. Ensure no dbconsole service is stopped and service control panmel/.
Run the Oracle Database Upgrade Assistant. You can launch the program from below navigation,
Start > All Programs > Oracle > Configuration and Migration Tools > Database Upgrade Assistant
On the Database Upgrade Assistant welcome 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 the option Recompile invalid objects at the end of upgrade. Click Next.
Always backup your database before doing the patch! If you have already backed up the database, select the first option and click Next.
Click Next.
The database upgrade summary screen. Verify the entered configuration earlier – if you want to do changes, please click on Back button to return to the specific page. Once confirmed, click Finish.
The patch is running.
The Oracle patch is complete and we have successfully patch Oracle from 10.2.0.1 to 10.2.0.4
Now, login to the SQL level to verify the Oracle patch version.
SQL*Plus: Release 10.2.0.4.0 - Production on Sat Jan 11 22:47:06 2014 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select INSTANCE_NAME, VERSION from V$INSTANCE; INSTANCE_NAME VERSION -------------- --------- ely 10.2.0.4.0
