Patch is normally used to fix a problem , to upgrade to a higher version and to update (to add/enhance) the features in the existing product or software.
A patch can be applied in 2 ways: 1) Adpatch( Auto Patch Utility) 2) Opatch
All the Application related Patch can be applied via the Adpatch Utility(or also called Auto patch utility) and all the database related patch can be applied via the Optach utility.
The directory of the adpatch be : $AD_TOP/bin
The directory of the opatch be: $ORACLE_HOME/OPATCH
Before we are applying patches you need to understand some of the basic terminology which are very very important for patching concepts.
Maintenance Mode:
When we are choosing the maintenance mode while applying the patch, means we are protecting the other users to access the application i.e EBS Application. It's acts like an cold patch.
So the use of maintenance mode is to make sure non of the users have the access to application and only accessible to the patching activities. by doing so, it enhance the performance of the system by minimizing downtime.
Appl_Top
Also named as the Application Top. This is the top level where all the application and product files are resided. It is also called configuration file for proper functioning on Oracle Application.
adpatch option=hotpatch
The above following commands is used for, if some one applying the patch without putting the EBS application maintenance mode.i.e (Hot Patch)
Cold Patch- The EBS Application is down.( Maintenance Mode)
Hot Patch- The Application is up.
Steps to apply the Patch via adpatch Utility
Step1. Before you are going to apply the patch check whether the patch is already present or not.
select * from AD_BUGS where bug_number=’<patch number>’
Step2: Download the patch by login into the oracle metalink.
www.metalink.oracle.com
then Select the Patches option and after that select the search type.Query for patching by writing the patch number which you want to download the patch.
Step3: After download the patch now it's the time to move the zip folder to a directory from where we want to unzip it and apply the patch.
This can be done in two way: 1. Using winscp and 2) direct by typing the command MV in the unix box(in unix OS)
The command line to move the zip file from desktop to the execute directory.
mv <patch.zip> <destination patch directory>
example: mv 1312323_lip.zip /home/oretail/debashis
Step4. Now unzip the patch by entering the below command in the uni box.
unzip 1312323_lip.zip
This will unzip the patch in current directory & will make the required patch directories & sub directories.
Step5. Enable the Maintenance Mode
Here you need to set the environments file located at the Appl_Top. After that you need to run the administration utility by typing adadmin on unix console. Please answer the same which are present in the bracket related to the default questions regarding the ADADMIN utility.
After some steps of question and answers you will provide the below options and ask for the choices.
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.
Choose 5 from the list of choices and press enter.
Step6: After change the Maintenance Mode, you need to enable the Maintenance Mode
1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu
Choose 1 to Enable the Maintenance Mode
Step7. Run the auto patch from the patch directory by entering the log file into the console
$adpatch1234.log and press enter
When you press the enter key in th unix box it wil start the processing of some questions answer and try to finisha the adpatch task. It also recommended you to run the log file if there is any error found while the processing
The name of logfile which you need to check if there is any error found while doing the adpatch in the unix box is: adpatch.log which is present in the $APPL_TOP/admin/<SID>/ directory.
If it gets successful it will show you a message called autopatch is complete. and that's it about patching of the autopatch (in the application ).
In my nest post I will tell you how to apply patch in the database i.e optach.
How to apply the patch with out making the application turned into maintenance mode or down.
Step1: Please follow upto Step 4 from the above procedure .
Step2: After unzip the folder we need not to enable the Maintenance mode.
The below command make you apply the adpatch : i.e adpatch option=hotpatch
After it , it wil ask you the default questions and you need to provide the answers for the same .
like of
Your default directory is '/u01/oracle/FINPROD/apps/apps_st/appl'.
Is this the correct APPL_TOP [Yes] ?
Filename [adpatch.log] :
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?
Please enter the batchsize [1000] :
Applications System Name [FINPROD] : FINPROD *
Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *
Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *
Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
PPL_TOP Name [pians003] : pians003 *
Is this the correct database [Yes] ?
Enter the password for your 'SYSTEM' ORACLE schema:
Enter the ORACLE password of Application Object Library [APPS] :
And you are done. If u have corrected all the steps then the message you will get patching is completed otherwise will get the error message.
For more details please visit the Atul's Blog
How to apply adpatch in application with enabling the maintenance mode.
