PATCH ACTION PLAN IN APPS 11i/R12

 PATCH ACTION PLAN IN APPS 11i/R12:
===============================


Adpatch:

Prerequisites:

1. Before Applying the we need to be ensure that weather patch has been applied or not.
select * from AD_BUGS where bug_number=’<patch number>’

a)count a invalid objects
S>select  count(*) from dba_objects where status='invalid';

2. Downoad the Patch from the  Oracle Support

3. Create a one Patch directory (R12Patches) which is having read &write permissions to the apps user

4. Review the ReadMe file and   verify the Prerequisites patches if any

5. Move the Patches to the R12Patches directory.

6. Unzip the patches using unzip utility    – unzip <patch number>

7. Ensure that there is sufficient temporary Memory and these directories defined by $APPLPTMP And $APPLTMP.
You Should also have space on the OS default temporary directory (/usr/tmp )

8. Login to the apps user and Source the Environment file

9.Stop the all the application services(Except DB Listener and Database)

10.Change the Maintenance mode using adadmin utility
( Hotpatch===> no need to enable the maintainence mode)

11.Run the auto patch from the Patch directory (R12Patches) using adpatch utility and respond the specific prompts

[appsuser@mydb /]$ adpatch options=hotpatch

Your default directory is ‘Path’.

Is this the correct APPL_TOP [Yes] ?.....................

12.Verify the patch log file for  patch has been applied succeessfully or not

13.Again count the  the invalid objects increased or not?

Logfiles:

Application Tier:
adpatch log – $APPL_TOP/admin/$SID/log/

Developer (Developer/Forms & Reports 10.1.2):
Patch – $ORACLE_HOME/.patch_storage

Web Server (Apache):
patch – $IAS_ORACLE_HOME/.patch_storage

Database Tier:
opatch log – $ORACLE_HOME/.patch_storage