Applying patch in oracle applications using adpatch utility

Step1: Check Database invalids and take the backup of database invalid objects.

SQL>select count(*) from dba_objects where status like’INVALID’;

SQL>create table dba_objects_backup as select * from dba_objects where status like ‘INVALID’;

Step 2:Check The given patch applied or not from ad_bugs table.

SQL>select creation_date, bug_number from ad_bugs where bug_number like’<Patch_Number>’;

Step 3:Down the Application services.

adstpall.sh

Check FNDLIBR executable  $ps –ef|grep FNDLIBR

$ps –ef|grep applprod|grep FNDLIBR

Step 4:Enable maintenance mode using adadmin.

• By Enabling maintenance mode workflow bussiness events will be disabled auotmatically and end user's can't access the business.
• During a Maintenance mode downtime, user login is restricted. 
• Users are redirected to a system downtime URL, which informs them that the maintenance session is in progress.

 $adadmin

Step 5: Open Readme.txt, read the instructions and Apply the patch.

Now check the database invalids, and compile.

SQL>select count(*) from dba_objects where status like'INVALID';

Disable maintenance mode and start the apps services.

cd $ADMIN_SCRIPTS

$adstrtall.sh