Monday, July 28, 2014

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

Before upgrade start,Download the below files from oracle.com

1.p18139609_112040_Linux-x86-64

2.p13390677_112040_Linux-x86-64_1of7

3.p13390677_112040_Linux-x86-64_2of7

4.p13390677_112040_Linux-x86-64_3of7

5.p13390677_112040_Linux-x86-64_4of7

6.p13390677_112040_Linux-x86-64_5of7

7.p13390677_112040_Linux-x86-64_6of7

8.p13390677_112040_Linux-x86-64_7of7

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

Estimated time for downtime is around 10hours.

Step1.Install Oracle 11.2.0.4 yo different home.

a) Create directory inside current home

mkdir /u01/oracle/product/11.2.0.4

chown -R oracle:dba /u01/oracle/product/11.2.0.4

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

c)Connect to oracle & run the installercd /oracle11g/11.2.0.4/database

./runInstaller

Click next,Click on fix & check agaian.After that run /tmp/CVU_11.2.0.1.0_oracle/runfixup.sh 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 root.sh at root level.Logs--[root@localhost 11.2.0.4]# /u01/oracle/product/11.2.0.4/root.shPerforming root user operation for Oracle 11g

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

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 byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Finished product-specific root actions.[root@localhost 11.2.0.4]# Click Ok to finish the installation.