Sunday, 5 February 2017

Apply Patchset Update (PSU) on Oracle Database 11.2.0.4 (NON RAC)

Overview:

In this article we performing PSU6 upgrade on Oracle 11.2.0.4 using slient mode on NON RAC.

Environment Details

Hostname
Primary server :–lnx-nsm-prod
Operating system
Linux
Database Environment
NSMDB


Software requirement:

https://support.oracle.com/epmos/common/images/save_ena.pngp6880880_112000_Linux-x86-64.zip Latest OPatch utility



Download Oracle Opatch and PSU from MOS
Copy downloaded softwares to staging area.

$ cd /u01/app/oracle/software/
$ mkdir 11204

OPactch upgrade

Before applying PSU we need to have latest version of OPatch utility
$ cd /u01/app/oracle/software/11204
$ls -ltr
-rw-r-----  1 oracle oinstall   71580583 Oct 27 17:11 p20299013_112040_Linux-x86-64.zip

-rw-r-----  1 oracle oinstall   98352086 Oct 27 17:11 p6880880_112000_Linux-x86-64.zip


Upgrade OPatch utility enter A when it prompt.

$unzip p6880880_112000_Linux-x86-64.zip -d /u01/app/oracle/product/11.2.0.4/db/

Archive:p6880880_112000_Linux-x86-64.zip
replace /u01/app/oracle/product/11.2.0.4/db/OPatch/opatch.bat? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
inflating: /u01/app/oracle/product/11.2.0.4/db/OPatch/opatch.bat

Verify the OPatch version after upgrade

$cd / u01/app/oracle/product/11.2.0.4/db/OPatch/
lnx-nsm-prod : ./opatch version
OPatch Version: 11.2.0.3.15
OPatch succeeded. 

Now we have to perform the PSU6 Upgrade.

PSU6 Upgrade


Unizip the software and go to 20299013 Directory

$unizip p20299013_112040_Linux-x86-64.zip
$cd 20299013
$ls -ltr
total 88
drwxr-xr-x 4 oracle oinstall  4096 Mar  4  2015 17478514
drwxr-xr-x 4 oracle oinstall  4096 Mar  4  2015 18522509
drwxrwxr-x 4 oracle oinstall  4096 Mar  4  2015 20299013
drwxr-xr-x 4 oracle oinstall  4096 Mar  4  2015 19121551
drwxr-xr-x 4 oracle oinstall  4096 Mar  4  2015 18031668
drwxrwxr-x 4 oracle oinstall  4096 Mar  4  2015 19769489
-rw-r--r-- 1 oracle oinstall  3068 Mar  4  2015 patchmd.xml
-rw-r--r-- 1 oracle oinstall    21 Mar  4  2015 README.txt
-rw-rw-r-- 1 oracle oinstall 54747 Apr 12  2015 README.html

Check the opatch version and path is set .

$export PATH=$PATH:$ORACLE_HOME/OPatch
$which opatch
/u01/app/oracle/product/11.2.0.4/db/OPatch/opatch

lnx-nsm-prod: opatch version
OPatch Version: 11.2.0.3.15

OPatch succeeded.

Make DB and Listener down on the server.

$ps -ef |grep smon
oracle   15230 18477  0 10:27 pts/0    00:00:00 grep smon

$ps -ef |grep tns
oracle   15230 18477  0 10:27 pts/0    00:00:00 grep smon

If DB and Listener are ruining.Perform the following step.

Stop DB

$sqlplus /  as sysdba
sql> shutdown immediate.

Stop Listener

$lsnrctl stop


Now updrade the PSU
$cd /u01/app/oracle/software/11204/20299013
$opatch apply
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Composite patch 20299013 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0.4/db/cfgtoollogs/opatch/opatch2016-10-28_10-28-01AM_1.log

OPatch succeeded.

Check the PSU Upgrade.

$opatch lspatches
20299013;Database Patch Set Update: 11.2.0.4.6 (20299013)

OPatch succeeded.

Conclusion:
In this article we have learnt how to apply PSU6 on 11.2.0.4 software on NON RAC using oracle response file in silent mode.

No comments:

Post a Comment