Saturday, February 23, 2008

Applying an Applications Patch







Download patch from Metalink.

Check for Superseding patches:
After you have found the patch on Metalink, it will list the supersede patches







Then in the superseded list compare the Applications Release to see if the patch you are about to apply has been superseded.






Check all output files from patchsets.sh and search for the list of superseding patches and any pre-reqs that are needed.



FTP zip file to a patch directory

Eg: Using an FTP program copy the file to /home/oracle/Vindaloo/patches/
Unzip patchfilename.zip


Follow instructions in the Readme.txt

Example readme.txt

ACCOUNT WITH A PARENT SEGMENT VALUE IN SOURCE COLUMN
=========================================================

Patch - 1809991
Product - General Ledger
Release - 11i
Platform - Generic Platform




======================================
Instructions For Applying This Patch
======================================

This patch contains one or more driver files to be applied with AutoPatch.
Please apply the driver files in the following order (if they exist) :
c1809991.drv (This is the copy driver)
d1809991.drv (This is the database driver)
g1809991.drv (This is the generate driver)


=======================================================
Patch Description
=======================================================

Problem: Elimination accounts cannot be saved with a parent segment value in
the source field and null in the target field.

Solution: Now all elimination accounts can be saved.



Shutdown Concurrent Managers


Apply Patch:

From the directory where you copied the patch to, run ADPATCH.
Below is an example of the output of ADPATCH, You will be prompted to answer specific questions.

[draco/GTST]:/export/home/oratst/vindaloo/patches/1809991>adpatch

Copyright (c) 1998 Oracle Corporation
Redwood Shores, California, USA

Oracle Applications AutoPatch

Version 11.5.0

NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.

Your default directory is '/w14/oracle/gtstappl'.
Is this the correct APPL_TOP [Yes] ?

AutoPatch records your AutoPatch session in a text file
you specify. Enter your AutoPatch log file name or press [Return]
to accept the default file name shown in brackets.

Filename [adpatch.log] : CHANGE THIS TO A UNIQUE NAME FOR THE PATCH.

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?

Please enter the batchsize [1000] :


Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.

The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscores characters,
and must start with a letter.

Sample Applications System names are: "prod", "test", "demo" and
"Development_2".

Applications System Name [GTST] : GTST *


NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.

Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.

Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.


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 *


Please enter the name Oracle Applications will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle Applications
Environment, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.

AutoPatch has computed a default APPL_TOP name for you
based on the servers you have implemented in this APPL_TOP.


APPL_TOP Name [draco] : draco *



You are about to apply a patch to the installation of Oracle Applications
in your ORACLE database 'GTST'
using ORACLE executables in '/w14/oracle/gtstora/8.0.6'.

Is this the correct database [Yes]

AutoPatch needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema:

The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] :

Enter the directory where your Oracle Applications patch has been unloaded

The default directory is [/export/home/oratst/vindaloo/patches/1809991] :

Do you wish to apply this patch now [No] ? yes

You may need to enter
Enter the number of parallel workers [6] : except default.

---------------------------------------------------------------------------------


Patch then runs through
Check log for errors

Run any other drivers listed with patch in order specified.

Restart the Concurrent Managers

Login and test application is up and running.





SQL> select PATCH_LEVEL from fnd_product_installations
2 where patch_level like '%INV%';

PATCH_LEVEL
------------------------------
11i.INV.I


Adctrl – can be used to monitor trouble shoot workers




******************************
keywords apply patch
******************************



No comments: