Skip to content

Upgrade to

Upgrade to

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 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

Step 2:

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

$ cd <path of 8202632 path>
$ unzip
$ cd Disk1/
$ ./runInstaller

after this please follow the floowing step:

cd $ORACLE_HOME/rdbms/admin
sqlplus "/as sysdba"
SQL>startup upgrade;
SQL>shutdown immediate;
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 to