Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Friday, 8 August 2014

Apply patches on to upgrade

The Oracle patchset is available from Oracle's Metalink Web site. To register for Metalink, you will need a valid Support Identifier (CSI). CSI numbers are unique support identifiers given to each customer with a current support contract. When you download the patchset from Metalink, it will be accompanied by a detailed, step-by-step guide for how to apply the patchset.
The basic steps for applying the Oracle patchset are:
§               Download the patch from Metalink.
§               Unzip it on the database server.
§               Shut down all databases using the Oracle9i home.
§               Apply the patchset to the Oracle binaries.
§               Start up all databases using the Oracle9i home and run required SQL scripts within each database.

Patch set release includes all fixes in patch set and earlier as well as new fixes for patch set This you can apply this patch set to any earlier release 9.2 installations. You do not have to install intermediate patch sets.
Patch sets contain generic fixes that apply to all platforms. Patch sets may also include additional platform-specific patches.
Note: Oracle provides both 32-bit and 64-bit versions of Oracle9i for Windows. Currently, the 32-bit version of the patch set must only be installed on the 32-bit version of the database. The 64-bit version of the patch set must only be installed on the 64-bit version of the database.

Users applying this patch set must use Oracle Universal Installer release (provided as part of this patch set) or later to ensure that their Oracle home can be patched in the future. Oracle Universal Installer release is also installed when you install this patch set.
There are two documents oracle 9i release 2 patchset. Both of these documents are included with the patchset.
1.      Oracle9i Patch Set Notes, Release 2 ( Patch Set 6 for Microsoft Windows (32-bit)
2.      Oracle9i List of Bugs Fixed, Release 2 ( Patch Set 6
This document provides:
§         System requirements and information about how to install or reinstall the patch set
§         A list of all bugs fixed to date that are specific to Oracle9i release 2 for Microsoft Windows (32-bit)
§         A list of known issues relating to Oracle9i release 2 for Microsoft Windows (32-bit)
The following are the system requirements for this patch set:
System Architecture: Intel Pentium and AMD processors
Operating System:
§         Windows Server 2003
§         Windows 2000 (Service Pack 2 or higher)
§         Windows XP Professional
Note: Windows 98 and Windows NT are no longer supported.
Oracle9i release 2 ( or later

For more details about pre-installation and post-installation task do not forget to read the README for 4163445 - Release 2 ( Patch Set 6 for Microsoft Windows (32-Bit).

Upgrading Oracle database from to on Windows server 32 bit.
Step1: Backup your database for precaution.
Step2: check your current database name and version.
SQL>Select database_name from v$database;
SQL> select * from v$version;
Oracle9i Enterprise Edition Release - Production
PL/SQL Release - Production
CORE  Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production

Step 3: Login to you’re MY ORACLE SUPPORT
and Click on PATCHES & UPDATES for downloading your patch for windows 32 bit.
In PATCHES & UPDATES enter Patch Number 4163445.

Step 4: Search and Download this patch on the disk drive and its associated Read me too. and unzip it somewhere else (For Example: D:\patch) outside actual ORACLE_HOME.

Note: You must Read the Associated Read and Patchset notes before applying actual process.
Step 5: Shutdown your database
SQL>shutdown immediate;

Step 6: Stop all the services and Listener.
You can do it either from the command prompt (C:\oracle1\net strop, C:\oracle1\lsnrctl stopand type services.msc on RUN and Stop it by right click on the required services.
OracleOraHome92ManagementServer (asks for credentials - use sysman/oem_temp)

Step 7: Launch your patch setup.
From your drive location where patch downloaded Clicking on the Setup.exe (D:\patch\Disk1\Setup.exe). Before upgrading the database you must check Tablespace size and set parameter values if required.
This start the OUI  (Newer Version of OUI). The Welcome screen will appear. Then Click NEXT.
Enter the OraHome92 into the name field and this will update the path to your ORACLE_HOME. Then Click NEXT. If any services are still running you will see this message:
Stop the services (if any) and Retry.
Click "Install" and wait for End of installation.
Step 8: After installation of patch set you must perform the following task:
i. Start all the services and listener
Use the same concept shown on the above screenshot just by clicking on start
ii.  Upgrade your dictionary.
Run SQL*Plus as SYS, Restart the database and run the upgrade script. It will take approx. 30 Min.
SQL> spool d:\patch.log
This script provides a direct upgrade path from this release ( to the new release ( Review patch.log for any errors (if any)
Note: OR you can run the catupgrd.sql script from ORACLE_HOME/rdbms/admin path. For that you have to start your database using STARTUP UPGRADE.
iii.  Restart your database for change to take effect:
iv.  Compile Invalid Objects & Verify Database version.
Run the utlrp.sql script to recompile all invalid PL/SQL packages.
SQL> @ D:\Oracle\ora92\rdbms\admin\utlrp.sql 
SQL>Select database_name from v$database;
SQL> select * from v$version;
Oracle9i Enterprise Edition Release - Production
PL/SQL Release - Production
CORE  Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version – Production

If you find to get the details which patchset your database, then simply query with the DBA_registry.
SQL>Select comp_id, comp_name, version, modified from dba_registry;
If you applied all of the above post installation task then finally you will get the result of above query as:
COMP_NAME                           STATUS      VERSION
----------------------------------- ----------- ----------
Oracle9i Catalog Views              VALID
Oracle9i Packages and Types         VALID
Oracle Workspace Manager            VALID
JServer JAVA Virtual Machine        VALID
Oracle XDK for Java                 VALID
Oracle9i Java Packages              VALID
Oracle interMedia                   VALID
Spatial                             VALID
Oracle Text                         VALID
Oracle XML Database                 VALID
Oracle Ultra Search                 VALID
Oracle Data Mining                  VALID
OLAP Analytic Workspace             UPGRADED
Oracle OLAP API                     UPGRADED
OLAP Catalog                        VALID

In fact upgrading is not difficult and is nothing more than following a series of stepsmentioned in README documentation. 
I hope it will help you all.......

Best Regards
Shahid Ahmed


  1. really its help me to learn new thing in your blog

  2. It will be of grt help if you also provide Upgrading Oracle Database from 9i to 10g
    Thanks for making such a wonderful blog Shahid.

    1. Search the post with "upgrade", i already uploaded Oracle 9i to 10g database upgrade. for your more info click or paste this link on your url: