Friday, May 6, 2011

How to Apply Patch Set on Oracle Database 10gR2 ?

Oracle Database upgrade to from, you need Patch Set No. 8202632. Download the patch set from oracle metalink.

Here is the guide for windows environment, how to apply this patch set.

Shut down the following Oracle Database 10g services in the order specified before installing the patch set:
    Shut down all services in the Oracle home that might be accessing a database, for example Oracle Enterprise Manager Database Control:
                C:\>cd C:\oracle\product\10.2.0\db_1\bin
                C:\oracle\product\10.2.0\db_1\bin>set oracle sid=ait
                C:\oracle\product\10.2.0\db_1\bin>emctl stop dbconsole
                C:\oracle\product\10.2.0\db_1\bin>isqlplusctl stop
You can also stop these services using the Services Control Panel. These services are referred to as OracleDBConsoleSID and OracleSIDiSQL*Plus respectively.
                C:\>sqlplus /nolog
                SQL> conn sys/password@ait as sysdba
                SQL> shutdown
Use the Services Control Panel to stop the Oracle Database service OracleServiceSID where SID is the system identifier of the database.
If any problem arises, then go to service control panel. Set all oracle service property to manual and restart the pc.
To install the Oracle Database 10g patch set interactively:
1. Log on as a member of the Administrators group to the computer on which you are going to install Oracle components. If you are installing on a Primary Domain Controller or a Backup Domain Controller, log on as a member of the Domain Administrators group.
2. Start Oracle Universal Installer located in the unzipped area of the patch set. For example, Oracle_patch\setup.exe.
3. On the Welcome screen, click Next.
4. In the Specify Home Details screen, select the name of the Oracle home that you want to update, or select the Path that you want to update from the list, then click Next
5. Enter your e-mail address and password for your My Oracle Support account to be informed of security issues, then click Next.
The registration and configuration can also be done manually after patch set installation.
The OCM registration page appears only while applying patch over existing Database instances alone.
6. If you are installing the patch set on an Oracle RAC cluster, click Next when the Selected Nodes screen appears.
7. On the Summary screen, click Install.
When the installation is complete, the End of Installation screen appears.
Start the listner..
For Oracle single-instance installations, start the listener as follows:
C:\> lsnrctl start
or use service control panel.
Start the Oracle Database Upgrade Assistant:
From the Start menu, select Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools and then Database Upgrade Assistant to start the Oracle Database Upgrade Assistant.
Complete the following steps displayed in the Oracle Database Upgrade Assistant screen:
  1. On the Welcome screen, click Next.
  2. On the Databases screen, select the name of the Oracle Database that you want to update, then click Next.
For Oracle RAC, enter the SYS password to do the upgrade.
  1. On the Recompile invalid objects screen, select the Recompile the invalid objects at the end of upgrade option, then click Next.
  2. If you have not taken the back up of the database earlier, on the Backup screen, select the I would like to take this tool to backup the database option, mention the Path, then click Next.
  3. On the Summary screen, check the summary, then click Finish.
  4. On the End of Upgrade screen, click Exit, then click Yes to exit from Oracle Database Upgrade Assistant.


  1. You have to understand patch set and Oracle database 10gR2 before studying this post. They mentioned how to apply patch set on 10gR2. All the steps are given to apply patch set. This is simple to implement.

  2. tnx for your suggetion .....upgrade 10G database...

  3. If I dont have access to ORACLE metalinks
    are there any other download sources??ie: forums ,..etc

  4. Sorry, There is no other download source for patchset. @ Ahmad Atef.

  5. is is the same procees to upgrade from 10201 to 10205 ?