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:

p6880880_112000_Linux-x86-64.zip Latest OPatch utility
p20299013_112040_Linux-x86-64.zip PSU6

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.