Monday, July 28, 2014

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

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





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 installer
cd  /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.sh
Performing 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 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.
[root@localhost 11.2.0.4]# 




Click Ok to finish the installation.

Go to Upgrade .

http://oracle-mssql-dba.blogspot.in/2014/07/oracle-11gupgrade-1120x-version-to_29.html
 

No comments:

Post a Comment

Dear User,

Thank you very much for your kind response