Wednesday, March 21, 2012

Adphrept to get list of patches applied to Appstier using ADPatch

####################################################################
ADPHREPT REPORT TO GET LIST OF PATCHES APPLIED USING ADPATCH
####################################################################


METHOD 1
###########
Check Patches applied in Oracle Applications Manager (OAM).

a) Connect to OAM:

http://hostname.domain:PORT/servlets/weboam/oam/oamLogin

Go to Site Map-->Maintenance-->Applied Patches

Enter Patch ID and press 'Go'

See if Patch was returned.


METHOD 2
#########
Use 'adphrept' utility


Patch History report usage:

adphrept query_depth \
bug_number or ALL \
bug_product or ALL \
end_date_from (mm/dd/rr or ALL) \
end_date_to (mm/dd/rr or ALL) \
patchname/ALL \
patchtype/ALL \
level/ALL \
language/ALL \
appltop/ALL \
limit to forms server? (Y/N) \
limit to web server? (Y/N) \
limit to node server? (Y/N) \
limit to admin server? (Y/N) \
only patches that change DB? (Y/N)

Specify 1 or 2 or 3 for query_depth

1-> Details of patches only
2-> Details of patches and their Bug Fixes only
3-> Details of patches their Bug Fixes and Bug Actions

Example: To get the complete patch details for patches applied in Dec 2000:

On UNIX:

$ cd $AD_TOP/patch/115/sql
$ sqlplus APPS/<PWD>

SQL> @adphrept.sql 1 ALL ALL 10/01/11 11/08/11 ALL ALL ALL ALL ALL N N N N N

This report should take less than a minute.

If you are prompted for any parameters, please exit and review the parameter list you have submitted.

Gathering data for report. Report output will be written to adfilerep.xml.

Writing data to report file.
Your AD Patch History XML Report is ready  at adfilerep.xml.

Note:Please copy the file to OA_HTML top to view it thru browser

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

[applmgr@hostname: sql]$ cp adfilerep.xml /u1590/oracle/oad5/apps/apps_st/comn/webapps/oacore/html/.

No comments:

Post a Comment