Monday, July 28, 2014

Oracle 11g:Upgrade 11.2.0.x version to latest patchset:Installation

Oracle 11g:Upgrade 11.2.0.x version  to latest patchset

For Applying patchset on oracle database.We need to 1st download all the requiesite downloads from

Before upgrade start,Download the below files from









Now, follow below steps to complete the task of upgradation of to patchset.

Estimated time for downtime is around 10hours.

Step1.Install Oracle yo different home.

a) Create directory inside current home
mkdir /u01/oracle/product/
chown -R oracle:dba /u01/oracle/product/

b)unzip the above all .zip files to particular location.

c)Connect to oracle & run the installer
cd  /oracle11g/

Click next,
Click on fix & check agaian.
After that run /tmp/CVU_11. at root level.
Click Ok to continue.

 check ignore all.

Click Yes.

For real time production, Do not go further untill all requirement fulfill.

It will take next 30 minutes to finish the installation.

Run at root level.


[root@localhost]# /u01/oracle/product/
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/oracle/product/

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

Click Ok to finish the installation.

Go to Upgrade .