Sunday, 5 February 2017

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


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

Environment Details

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

Software requirement: 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

-rw-r-----  1 oracle oinstall   98352086 Oct 27 17:11

Upgrade OPatch utility enter A when it prompt.

$unzip -d /u01/app/oracle/product/
replace /u01/app/oracle/product/ [y]es, [n]o, [A]ll, [N]one, [r]ename: A
inflating: /u01/app/oracle/product/

Verify the OPatch version after upgrade

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

Now we have to perform the PSU6 Upgrade.

PSU6 Upgrade

Unizip the software and go to 20299013 Directory

$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 .

$which opatch

lnx-nsm-prod: opatch version
OPatch Version:

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,
Composite patch 20299013 successfully applied.
Log file location: /u01/app/oracle/product/

OPatch succeeded.

Check the PSU Upgrade.

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

OPatch succeeded.

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

No comments:

Post a Comment

Deploy Exadata Database Machine On Oracle Cloud Infrastructure

In this article we will demonstrate a quick steps to deploy Exadata Database Machine in Oracle Cloud Infrastructure (OCI). Prerequisites:...