Oracle EBS Patching

http://hutianci.iteye.com/blog/1457287

L Example: Hit patch# 11843100:r12. Cac. B
Check to see if you already have this patch before you hit patch.
SELECT * from Ad_applied_patches where patch_name in (' 11843100 ', ');
SELECT * from ad_bugs where bug_number = 11843100;

Pre-install Tasks
You must shut-application tier services before performing the tasks in this section.
There is no tasks to being performed in this section.
To turn off the AP service:
After logging in Appldev, $ cd $ADMIN _scripts_home
$./adstpall.sh Stop AP Service

Note Set to maintenance mode before hitting any patch. To $ADMIN _scripts_home, execute adadmin.
Run Adadmin and set the instance in Maintenance Mode [under Adadmin menu, choose (5) then (1)].
Exit adadmin When Maintenance mode is changed. Pay attention to switch back after you have finished playing.

-------------------------------
Also note that when looking for patch files, the language is generic, there are special Chinese, also need to download to play.
You can go to Metalink under the patch with the Updater menu, select the language in the Patch Search section, select the Back simpled Chinese ...

After reading the readme, if there are some requirements like the following patch, then we need to
Query to see if there is.
You need to install following patches and all of its pre-requisites:
1) ORACLE e-business SUITE 12.1.2 RELEASE
2) 8252018:r12. Cac. B SERVICE REQUEST Escalation Contact SELECT
Last NAME l.o.v not working correctly
Query whether a pre-patch is already in place:
SELECT * from Ad_applied_patches where patch_name in (' 8252018 ', ');
SELECT * from ad_bugs where bug_number = 8252018
Query in the library has 8252018, generally return 2 records, identify one is the USA, one is Chinese (language).
If the above query is not available, you need to download:
P8252018_r12. Cac. B_r12_generic.zip
P8252018_r12. Cac. B_r12_zhs.zip
is playing p11843100_r12. Cac. B_r12_generic.zip the above two patches before the start of the call.
-------------------------------

Apply the Patch
This patch contains the following unified (unified) driver file to is applied with
AutoPatch:u11843100.drv (This is the unified driver), the file is in the extracted directory.
The patch interface prompts you to enter this driver name.
Unzip the file
$ cd/data02/after_clone_patch
$ unzip P11843100_r12. Cac. B_r12_generic.zip
$ CD 11843100
$ adpatch
Are you prompted that the Appl_top directory is the specified directory?
We can use the Echo $APPL _top to view environment variables. Follow the prompts to enter ....

Set to non-maintenance mode before hitting any patch. To $ADMIN _scripts_home, execute adadmin. Follow the menu prompts to disable off maintenance mode.

Oracle EBS Patching