Steps for applying patches to OracleEBS

It can be divided into four main points: 1) use Telnet to log on to the application server and view the Unix server type. Currently, IBMAIX, SUNSolaris, and HPUX are mostly used.

It can be divided into four main points: 1) use Telnet to log on to the application server and view the Unix server type. Currently, most of them are (ibm aix, SUN Solaris, and HP UX

1. Patch preparation

There are four main points:
1) use Telnet to log on to the application server and check the Unix server type. Currently, there are three types of server (ibm aix, SUN Solaris, and hp ux.
2) view the version number of the program to be repaired (on the server ):
View plaincopy to clipboardprint?
Strings-a $ AU_TOP/forms/US/GLXFCRVL. fmb | grep '$ head'
Record version: FDRCSID ('$ Header: GLXFCRVL. fmb 120.17 r12conv ship
Log on to the Form interface of the client and click Help-> About Oracle Applications to view the version.
Log on to the OAF Page and click "About this Page-> Page" to view the version number:
The record version is/oracle/apps/pos/supplier/webui/SuppSummPG 120.13.1201511.9.
3) download patches
Go to oracle metalink, switch to the Patch & Updates page, and download the Patch Based on the SR (Service Requests) Patch number provided by ORACLE,
Download the Patch corresponding to all languages installed under the application (install several patches in several languages)
4) switch the application to the maintenance mode.
Use adadmin to switch to Mode 5-> then select Enable Maintenance Mode-> press enter to switch until the end

2. Patching Process
1) Upload the file to a directory on the server (usually named "Patch". If there is no directory, create a directory named "Patch)
2) decompress the patch
Unzip p8513126_R12.AP.A_R12_GENERIC.zip.
Unzip p8819747_R12.GL. B _R12_zhs.zip.
3) read the supplemented readme.html to view detailed patch information.
README.html includes Abstract, Instructions, Description, and Bugs Fixed.
3) Start patching
When readme.html prompts to install the patch adpatch driver = u8819747.drv
Press enter to switch, until the SYSTEM password is required, the default is manager; press enter to switch until the prompt (whether to install the patch immediately), enter: Yes; press enter to switch until the installation is complete
4) Exit the maintenance mode.
Use adadmin to switch to Mode 5-> then select Unable Maintenance Mode-> press enter to switch until the end

3. Check the patch.
1) patch prepared by SQL query:
View plaincopy to clipboardprint?
SELECT * FROM ad_applied_patches app WHERE app. patch_name = '2013 ';
Select * from ad_bugs where bug_nuber = '201312 ';
-- Patch_name indicates the name of the patch to be installed. ad_applied_patches only saves the patch installed after the application is installed. The patch before installation is saved in ad_bugs.
SELECT * FROM ad_bugs AB WHERE AB. bug_number = '2013 ';
-- Bug_number indicates the patch number. ad_bugs saves the patch before installation and stores it in ad_bugs. The ad_bugs table stores the bug record of patch repair.
2) check whether the patch is installed
Use the following command on the Form interface:
View plaincopy to clipboardprint?
Strings-a $ AU_TOP/forms/US/GLXFCRVL. fmb | grep '$ head'
Or log on to the Form interface to check whether the Form version has changed.
OAF interface command:
View plaincopy to clipboardprint?
1. Enter the class directory
$ JAVA_TOP/oracle/apps/ce/forecast/cf/server
2. view the version
Strings-a ForecastAMImpl. class | grep '$ Header'
Log on to the OAF Page, click About this Page-> Page to view the JAVA package version, and view the installed patch under About this Page-> Patches.

4. Considerations for Patching
1) install the patch in English first (all patches in other languages have been changed in multiple languages based on the patch in English, and the patch in English is used as the basis for installation)
The content of the patch in English is different from that in other languages.
Patches in English include the logic information and language information of the program, Package information, and various information about the database objects.
Other languages include multilingual information, such as the multi-language Form and the multi-language OAF interface, and more information about the customer interface.
2) When installing a patch, you must switch the application to the maintenance mode to prevent the installation of the patch from incorrect operations on the interface.
3) after the installation is complete, if the system cannot run properly, restart the application.