Components still show 9.2.0.1 version after Applying 9.2.0.7 patchset also

There is an issue while applying patchset 9.2.0.7 on 9.2.0.1. Please see the below steps and explanation for more information.

Step 1 : I installed 9.2.0.1 software on a windows xp professional machine for testing purpose. But no database was created at the time.

Step 2 : And later i applied 9.2.0.7 patch on that 9.2.0.1 software, the patch installation went fine without any issues or errors.

Step 3 : And after the sucessfull patch insallation i created a database using DBCA. it was sucessfull.

Step 4 : I connected the database as sys user and checked the version using V$VERSION view. it displayed

SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.7.0 - ProductionPL/SQL Release 9.2.0.7.0 - ProductionCORE 9.2.0.7.0 ProductionTNS for 32-bit Windows: Version 9.2.0.7.0 - ProductionNLSRTL Version 9.2.0.7.0 - Production

Step 5: As a precautionary measure i thought of checking the components version from
dba_registry and it showed the old version that is 9.2.0.1. Please see below

SQL> select comp_name,version from dba_registry;
COMP_NAME VERSION
-------------------------------------------------- ---------------------------
Oracle9i Catalog Views 9.2.0.1.0
Oracle9i Packages and Types 9.2.0.1.0
Oracle Workspace Manager 9.2.0.1.0
JServer JAVA Virtual Machine 9.2.0.1.0
Oracle XDK for Java 9.2.0.1.0
Oracle9i Java Packages 9.2.0.1.0
Oracle interMedia 9.2.0.1.0
Spatial 9.2.0.1.0
Oracle Text 9.2.0.1.0
Oracle XML Database 9.2.0.1.0
Oracle Ultra Search 9.2.0.1.0
Oracle Data Mining 9.2.0.1.0
OLAP Analytic Workspace 9.2.0.1.0
Oracle OLAP API 9.2.0.1.0
OLAP Catalog 9.2.0.1.0
15 rows selected.

So its a problem. So we have to manualy upgrade the components by running scripts which is mentioned in the README file which came with the patch.

So i ran the scripts by connecting as a SYS user to the database as below

sqlplus sys/******* as sysdba
SQL> Shutdown immediate
SQL> startup migrate
SQL> @C:\oracle\rdbms\admin\catpatch.sql

after the sucessfull execution of the above script executed the second script as mentioned in the README file.

SQL>Shutdown immediate
SQL> startup
SQL>@C:\oracle\rdbms\admin\utlrp.sql

after the sucessfull execution of both the scripts again i checked the components version and found that everything is fine, Please see below.


SQL> select comp_name,version from dba_registry;
COMP_NAME VERSION
-------------------------------------------------- ---------------------------
Oracle9i Catalog Views 9.2.0.7.0
Oracle9i Packages and Types 9.2.0.7.0
Oracle Workspace Manager 9.2.0.1.0
JServer JAVA Virtual Machine 9.2.0.7.0
Oracle XDK for Java 9.2.0.9.0
Oracle9i Java Packages 9.2.0.7.0
Oracle interMedia 9.2.0.7.0
Spatial 9.2.0.7.0
Oracle Text 9.2.0.7.0
Oracle XML Database 9.2.0.7.0
Oracle Ultra Search 9.2.0.7.0
Oracle Data Mining 9.2.0.7.0
OLAP Analytic Workspace 9.2.0.7.0
Oracle OLAP API 9.2.0.7.0
OLAP Catalog 9.2.0.7.0
15 rows selected.

Thanks ..
Navaneeth