Upgrade 10.2.0.1 to 10.2.0.5
I had done this in VMWARE in OEL REDHAT 5
the process remains same for almost all the other server act just can vary with some minute OS level difference.
download the patch 8202632 for your operating system.
in this case LINUX
unzip this file
Check that the
Step 1: Prerequisites check before applying the patch set (8202632).
Check your dba_registry view oracle database components status is valid or not, version is 10.2.0.1. Have a look at the below output
SQL> Select comp_name, version, status from sys.dba_registry;
Check your v$version view
SQL> select * from v$version;
Check your database objects are valid or not
SQL> select object_name,status from dba_objects where status='INVALID'; No rows selected
In my environment, here are no invalid objects. If you have any invalid objects then you have to really
Validate your database objects through the below scripts
SQL> exec utl_recomp.recomp_serial (); -> this is for all user’s objects across the database
Then stop all the process like sql, emctl, tnslistener and shutdown your database.
$ sqlplus / as sysdba SQL> shutdown immediate $ isqlplusctl stop $ emctl stop dbconsole $ lsnrctl stop
Do take Cold Backup of your oracle database 10g and $ORACLE_HOME using Operating system ( This is just in case of any failuir)
Install the patch set 10.2.0.5
$ cd <path of 8202632 path> $ unzip p8202632_10205_Linux.zip $ cd Disk1/ $ ./runInstaller
after this please follow the floowing step:
cd $ORACLE_HOME/rdbms/admin sqlplus "/as sysdba" SQL>startup upgrade; SQL>@catupgrd.sql SQL>shutdown immediate; SQL>startup; SQL>@utlrp.sql SQL> select object_name,status from dba_objects where status='INVALID';
Validate INVALID Objests if any
Congratulation's now you have upgraded the Database from 10.2.0.1 to 10.2.0.5....