Application Patching (ADPATCH)

Patch is a program to fix a particular problem or enhance/add a particular feature in existing environment.

To apply the patch, download the patch from metalink with specific OS versions.

Unzip the patch and read the pre-requisite.
vi README.txt

To check whether the patch is already applied.

*sqlplus apps/<apps password>@<tnsalias>   then
select * from AD_BUGS where bug_number=’<patch number>’


Maintenance Mode is mode of operation in which the oracle application system is ready for patching activities. It improves performance and availability by minimizing downtime.

Run the 'adadmin' from APPL_TOP
 
1.Generate applications file menu.
2.Maintain applications file menu.
3.Compile/Reload Applications Database Entities Menu.
4.Maintain Applications Database Entities Menu.
5.Change Maintenance Mode.
6.Exit ad Administration

Select the option '5' to change the maintenance mode.
1.Enable Maintenance mode.
2.Disable Maintenance mode.
3.Return to Main Menu.


If you wish to apply patch without putting applications in maintenance mode use options=hotpatch with adpatch.

adpatch options=hotpatch