Applying a Patch


How to apply a Patch in Oracle Applications???

Hi, in this post, I will explain how to apply a patch to oracle applications and patching procedure.

Consider you have 3-node architecture (1-db; 1-concurrent node(db-ap), 1-AP node).

If you want to apply patch 6824767, follow these steps:

1.  Shutdown db-ap and ap nodes and keep db and db listener up.

2.  Take Invalid object List before patching.

COLUMN object_name FORMAT A30
SELECT owner, object_type, object_name, status FROM dba_objects WHERE status = ‘INVALID’
ORDER BY owner, object_type, object_name;

3.  Enable maintenance mode using adadmin.

4.  Apply patch on db-ap node.

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/defaults_file.txt  options=noautoconfig,nomaintainmrc,nocompilejsp \
patchtop=/patch/6824767 driver=u6824767.drv logfile=eap1_6824767.log workers=8

5.  Apply patch on ap node.

adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/defaults_file.txt options=noautoconfig,nomaintainmrc,nocompilejsp \
patchtop=/patch/6824767 driver=u6824767.drv logfile=eap1_6824767.log workers=8

6.  After applying the patch, again check for invalid objects and compare it with the before applying patch result.

If any new invalid found then run adadmin and compile apps schema.

7.  Disable maintenance mode using adadmin.

8.  Start db-ap and ap nodes.

9.  Do health check by logging into front-end and by submitting a simple concurrent request like “print environment variables”.

that’s all………U r done with it


Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."