Oracle Applications Current Patchsets Comparison Utility (Script to Analyze)
-----------------------------------
Purpose
This program (a unix shell script) was created to help customers evaluate the currently installed Oracle Applications' patchsets and Family Packs. The program compares the currently installed patchsets and family packs to the most recently available ones generated by Oracle Development. This is an Oracle Support provided script and therefore has limited support, but there are plans to have a Development based version integrated into the product. This note will be updated at that point with the details on how to obtain it.
How it Works
This program utilizes the the applptch.txt file for 10.7-11.0. For 11i, it utilizes a combination of tables such as AD_BUGS and AD_APPLIED_PATCHES to create the installed patch list. If the 11i release does not use these AD tables (11.5.4 or lower and have not applied 11i.AD.E or higher) it still supports using applptch.txt for 11i. In order to keep this script up to date, it is put out on the Oracle ftp site on a nightly basis with the most recent patchset/family pack listings included in it. Therefore, the patchset analysis that you do is only as up to date as the last time you download this script.
Scope & Application
This script can be used for 10.7,11.0.x and 11.5.x. The patchset listings are generated automatically from the latest release information from Development. If a patchset referenced by this tool is not available on the external ftp site, an i-Tar can be logged to obtain it.
Contents
1. Latest Patchsets Comparison Download Locations
2. Running the Patchsets Comparison Tool
3. Understanding the Patchset Comparison Output
4. More Details on the Patchsets Comparison Tool
5. Possible problems with this Tool
1. Latest Patchsets Comparison Download Locations
Unix or NT:
ftp://oracle-ftp.oracle.com/apps ... E_TOOL/patchsets.sh(External Access)
http://poseidon.us.oracle.com:7500/shtml/patchsets.sh(Oracle Internal Access)
Note: The NT version works with the MKS shell that is required for Release 11i. For comparison of Releases prior to 11i, copy the applptch.txt to a Unix machine and run the script there with the explicit path to the applptch.txt file. ie.$ patchsets.sh applptch=/tmp/applptch.txt
top
2. Running the Patchsets Comparison Tool
Warning:The patchsets.sh program is generated every night with the latest patchsets data in it.
So, this means that you need to get the latest version to get an up-to-date report.
Usage: $ patchsets.sh [connect=11i_login/pw|applptch=/path/applptch.txt] [-h]
[silent=y] default is n, [htmlout=file]
Example Help:
$ patchsets.sh -h
$ ./patchsets.sh -h
OUT_DIR set to: /tmp by default (set CUST_TEMP if you want to customize this)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Check Applied Patchsets Tool - patchsets.sh
#############################################################################
##Name: patchsets.sh
Version: 4.19
##By: SSANDREW
Last Modified: Apr 18, 2005
##
Written: 6/22/99
#############################################################################
##
##Usage: patchsets.sh connect=11i_login/pw [ad_bug_date=DD-MON-YY] (11i only)
##
[htmlout=file_name] [applptch=applptch_file.txt]
##
[silent=y] default is n
##
##
connect=apps/apps@connection (11i only)
##
[ad_bug_date=DD-MON-YY] (11i only)
##
[patch_list=ad_applied_patches|your_file.csv]
##
default is to use: ad_bugs table
##
It is alot faster to go against ad_applied_patches
##
but this only works if you are NOT using admrgpch to
##
merge patchsets. Also, if providing your_file.csv the
##
format is: short_name, possible_patchset_number
##
(The short_name is not used but a value is required)
##
## patchsets.sh -h|?|help (for Help)
##
##
Additional Parms: If 11i and latest AD Patchset E or F or > 11.5.4
##
connect=apps/apps@connection
##
[patch_list=ad_applied_patches|your_file.csv]
##
default is to use: ad_bugs table
#############################################################################
Purpose: To Aid in analysis of the latest available patchsets in relationship
to all patchsets that have been applied. If patches in the db the
program uses ad_bugs & ad_applied_patches table or applptch.txt file.
Typical Usage:
# 11i Usage when latest AD patchsets (E or more) have been applied or > 11.5.4
$ ./patchsets.sh connect=apps/apps (Most Common Usage)
$ ./patchsets.sh connect=apps/apps patch_list=ad_applied_patches
$ ./patchsets.sh connect=apps/apps@VIS1157 ad_bug_date=01-FEB-02
$ ./patchsets.sh
$ ./patchsets.sh applptch=/tmp/applptch.txt
$ ./patchsets.shconnect=apps/apps debug=y
$ ./patchsets.shconnect=apps/apps debug=y (if you have a problem send this)
$ ./patchsets.shconnect=apps/apps available=metalink
(Restrict to Metalink Available patchsets)
# All other Oracle Applications Installs
$ ./patchsets.sh
defaults to $APPL_TOP/admin/$TWO_TASK/applptch.txt or equiv
$ ./patchsets.sh applptch=/tmp/my_applptch.txt
NOTE: Removed 10sc, 10.7 and 10.7NCA support in version 4.12
Put back 10.7 in 4.13 due to need still in upgrade assistants program.
- For more information on this program, get the latest version,
and find examples of its use you can go to the following:
http://zen.us.oracle.com/~ssandrew/ (Internal)
or
ftp://oracle-ftp/apps/patchsets/ ... E_TOOL/patchsets.sh (External)
Example Run:
$ ./patchsets.sh applptch=/applptch_11i.txt
whoami: Setup_Env 55: ./patchsets.sh 1912: not found
The raw patchsets files have been put in your /tmp:
====================================================
/tmp/107NCA_patchsets.txt/tmp/110_patchsets.txt /tmp/16_patchsets.txt
/tmp/107_patchsets.txt /tmp/11i_patchsets.txt
====================================================
The Report.txt and Patch.csv files can be found
in your Current Directory:D:/lap/Scripts/patchsets
Report.txt - Patchset Comparison with ARU
Patch.csv - Listing(csv) of all patches applied
====================================================
Warning: This report is only as up-to-date as when it
was most recently downloaded by you...
Download the most recent version whenever you want to
get the updated ARU patchset listings.
Find Updates at:
http://zen.us.oracle.com/~ssandrew/ (Internal)
or
ftp://oracle-ftp/apps/patchsets/ ... E_TOOL/patchsets.sh (External)
Example Html Output in Silent Mode:
$ ./patchsets.sh applptch=/applptch_11i.txt htmlout=Report.html silent=y
top
3. Understanding the Patchset Comparison Output
The patchsets.sh script is build every night by a cron job. The cron job first runs several sql scripts against our internal ARU system (maintained by Development) to get the latest patchset listing for each of the current releases. These listings are then merged by the cron into the patchsets.sh script which is then put on the oracle ftp site. This is why the results from running this script are only current at the time you download the script. This is IMPORTANT to remember.
For 10.7-11.0, the script simply greps the applptch.txt file to build a list of all the unique patch numbers. For 11i, the script generates the applied patchset listing from the ad_bugs and ad_applied_patches tables. It also utilizes other tables.At this time the program also generates a simple summary listing (Patch.csv) in comma delimited format of all the unique patches that will be compared. This Excel readable format may be useful for other purposes in your organization.
In 10.7-11.0,the top of the applptch.txt file has the Current Oracle Applications Release version (CURRENT_RELEASE: 1x.x.x).Based on this release version the program compares that versions current patchsets one-by-one and creates the Report.txt file showing if it is a patchset that you have applied, and the current ARU Status of that patchset. This patchsets listing includes all patchsets, not just the most recent. This allows for a complete listing of all the patchsets that have been applied to this applptch.txt file.
When using 11i, the Current Release is based on FND tables. This is then the basis of the Baseline patchset listing that are generated from and stored in the patchsets.sh program. These baseline patches along with your applied (ad_xx tables) patches is what is used to compare to the complete list of all 11i patchsets. (11i_patchsets.txt which is also generated when the patchsets.sh program executes against 11.5.X).
NOTE:The Output might not show the Minipack for some modules if they are not available on metalink for download. this might occur if they are only "Distributed" with Family Packs."
Typical Output of the Report.txt
A
$ more Report.txt
=============================================================================
=============================================================================
Report Generated: Tue Apr 19 12:16:55 EDT 2005
Tool Version:4.19
Patchsets List Updated: Apr 18 22:30
Machine/OS: SunOS poseidon 5.8 Generic_108528-15 sun4u sparc SUNW,Sun-Blade-100
Domain: us.oracle.com
applptch Source: Patch.csv
Version from APPLPTCH: 11.5.5
Database: VIS1155
Limited Report to: APPLFULL and APPLSHAR products
APPLFULL: AK ALR AMS AP AR AS ASF ASO AST AU AX AZ BEN BIC BIL BIM BIS BIX BOM CCT CE CHV CN CRP CS CSC CSD CSF CSP CSR CSS CUF CUS CZ EC ECX ENG FA FII FLM FND FPT GL GMA GMD GME GMF GMI GML GMP GMS GR HRI HXC HXT HZ IBA IBE IBP IBU IBY ICX IEB IEM IEO IES IEU IEX IGW INV ISC JA JE JG JL JTF ME MRP MSC MSD MSO MSR OKC OKE OKS OKX ONT OPI OTA OZF OZP OZS PA PAY PER PJM PMI PN PO POA POM PSB PSP QA QP RG RHX RLM SSP VEA WIP WPS WSH WSM XDP XLA XNC XNM XNP XNS XTR
APPLSHAR: AD AMV ASG CUA CUI CUN CUP DT FF GHR IPA MFG OE PQH PQP RLA SHT VEH
Pseudo Products:ADX AME AML BPA CAC CSK CTB EDW EWS FWK HCT IGP IPATCH IRC ISX ITA JTA JTH JTO JTP JTT JTU JTY MSX OAM OCM OIE OIR OIT OWF PJR POV RCM RTC TXK UMX
Written By: Oracle Support, COE, SSANDREW
Program Updates: ftp://oracle-ftp/apps/patchsets/PATCHSET_COMPARE_TOOL/
Download Patchsets: Go to link below or click on Patches
http://metalink.oracle.com/metalink/plsql/dis_download.startup
=============================================================================
Applied Patchsets that Match ARU:
FAMILY PACKS
ProdPatchset
Bug RELEASED Release StatusDistribution
=======================================================================================
dmf_pf11i.DMF_PF.D1551167 31-JAN-01 Patchset SupersededBy_Metalink
dmf_pf11i.DMF_PF.E1745355 24-MAY-01 Patchset SupersededBy_Metalink
fin_pf11i.FIN_PF.C2380068 16-AUG-02 Patchset SupersededBy_Metalink
om_pf 11i.OM_PF.D 1550583 01-FEB-01 Patchset SupersededBy_Metalink
om_pf 11i.OM_PF.E 1745389 31-MAY-01 Patchset SupersededBy_Metalink
opm_pf11i.OPM_PF.E1614311 05-FEB-01 Patchset SupersededBy_Metalink
opm_pf11i.OPM_PF.F1688968 30-MAR-01 Patchset SupersededBy_Metalink
prc_pf11i.PRC_PF.D1554100 01-FEB-01 Patchset SupersededBy_Metalink
prc_pf11i.PRC_PF.E1745369 18-MAY-01 Patchset SupersededBy_Metalink
scp_pf11i.SCP_PF.D1552650 31-JAN-01 Patchset SupersededBy_Metalink
scp_pf11i.SCP_PF.E.11801717 14-MAY-01 Patchset SupersededBy_Metalink
B
Applied Patchsets that Match ARU:
APPLIED PATCHSETS
ProdPatchset
Bug RELEASED Release StatusDistribution
=======================================================================================
abm 11i.ABM.D 1741310 31-MAY-01 Patchset SupersededBy_Dev
ad11i.AD.A
1351004 07-OCT-00 Patchset SupersededBy_Metalink
ad11i.AD.C
1475426 19-JAN-01 Patchset SupersededBy_Metalink
ad11i.AD.D
1627493 04-FEB-01 Patchset SupersededBy_Metalink
ad11i.AD.E
1945611 02-NOV-01 Patchset SupersededBy_Metalink
ad11i.AD.F
2141471 21-FEB-02 Patchset SupersededBy_Metalink
ad11i.AD.G
2344175 05-NOV-02 Patchset SupersededBy_Metalink
ak11i.AK.A
1343449 05-SEP-00 Patchset SupersededBy_Metalink
ak11i.AK.B
1455027 15-DEC-00 Patchset SupersededBy_Metalink
ak11i.AK.C
1553747 05-FEB-01 Patchset SupersededBy_Metalink
alr 11i.ALR.A 1348277 07-SEP-00 Patchset SupersededBy_Metalink
alr 11i.ALR.B 1459186 12-OCT-00 Patchset SupersededBy_Metalink
alr 11i.ALR.C 1575525 02-FEB-01 Patchset SupersededBy_Metalink
ams 11i.AMS.B 1339203 07-OCT-00 Patchset SupersededNot_Distributed
ams 11i.AMS.C 1568669 18-FEB-01 Patchset SupersededBy_Dev
amv 11i.AMV.D 1615230 27-FEB-01 Patchset SupersededBy_Metalink
...
xtr 11i.XTR.C 1565561 02-FEB-01 Patchset SupersededBy_Metalink
xtr 11i.XTR.D 1711366 18-MAY-01 Patchset SupersededBy_Metalink
xtr 11i.XTR.G 2223523 12-APR-02 Patchset SupersededBy_Metalink
C
The Most Recent Release Family Packs (Not Included Above) are:
=======================================================================================
atg_pf11i.ATG_PF.H3438354 11-NOV-04 Patchset ReleasedBy_Metalink
bis_pf11i.BIS_PF.D.14054609 21-JAN-05 Patchset ReleasedBy_Metalink
cc_pf 11i.CC_PF.R 3202573 05-NOV-04 Patchset ReleasedBy_Metalink
com_pf11i.COM_PF.A2036253 04-NOV-01 Patchset ReleasedBy_Dev
dmf_pf11i.DMF_PF.J2771139 17-SEP-04 Patchset ReleasedNot_Distributed
exchg_pf11i.EXCHG_PF.C2147366 31-JAN-02 Patchset ReleasedBy_Metalink
fin_pf11i.FIN_PF.F3153675 05-NOV-04 Patchset ReleasedBy_Metalink
...
The Most Recent Release Patchsets (Not Included Above) are:
=======================================================================================
ad11i.AD.I.1
4038964 02-DEC-04 Patchset ReleasedBy_Metalink
adx 11i.ADX.E.1 3817226 08-JUL-04 Patchset ReleasedBy_Metalink
ak11i.AK.G
3263645 04-NOV-04 Patchset ReleasedBy_Metalink
alr 11i.ALR.G 3261254 04-NOV-04 Patchset ReleasedBy_Metalink
ame 11i.AME.A 3962268 01-DEC-04 Patchset ReleasedBy_Metalink
aml 11i.AML.B 3236242 08-OCT-04 Patchset ReleasedNot_Distributed
ams 11i.AMS.I 3025816 08-OCT-04 Patchset ReleasedNot_Distributed
amv 11i.AMV.I 3134012 07-OCT-04 Patchset ReleasedNot_Distributed
...
D
Base Patchset List for 11.5.5 included below:
=============================================================================
1612182 - bic Customer Intelligence, Minipack I
1610593 - bim Marketing Intelligence, Minipack H
1612601 - bil Sales Intelligence, Minipack I
1791967 - bix Call Center Intelligence, Minipack K
...
Note: This does not include the prior Baseline listings which are also used to build the applied list (B).Those listings can be found in the /tmp directory as 11XX_Base.txt.
Over Each Section:
A The top of the script tells overviews when the patchsets were last updated that this report was run against: "Patchsets List Updated: Apr 4 22:30", when the report was run: "Report Generated: Thu Apr5 12:07:08 EDT 2001", the current Release Version from the applptch.txt file: "Version from APPLPTCH: 11.5.1" and where to get a new version of the patchsets.sh script with the latest patchset data.
B This is a complete list of the patchsets applied after install or matching the compared applptch.txt file.
C These are the patchsets that have a "Released" Status and were not found in A. In other words, these are the most recent patchsets for each of the Products that have not yet been applied.
D The baseline for any given product includes patchsets that are applied to that release before it is packaged up and put on the CD. This is the listing that is used along with all the previous version patchset baselines to build your installed baseline listing. ie. If you are currently on 11.5.4, the baseline listing is 11.5.1-11.5.4. These baseline patchset listings are taken from the "Release Notes" for each release.More recently, that baseline has been augmented with the FND_PRODUCT_INSTALLATIONS.PATCH_LEVEL listing when the base release CD was published.
Misc Notes about the Report.txt Report
Note:APPLFULL and APPLSHAR
This Most Recent Released Patchsets are limited to the installed and shared
products listed in APPLFULL and APPLSHAR variables. For 11i, this is based on
an fnd table when using connect= and an ad_bugs table exists.
Note2: Baseline Details
Starting with version 3.6 of this program, the Baseline patchsets
and Family Packs are included in the above listing so the list is
alot more than you have applied. To see what was delivered for each
baseline review the /tmp/11XX_Base.txt files.
Note3:
Not_Distributed: the patch is only available by a Family Pack. No one off patch available
By_Dev
: the patch is only available by a Family Pack. No one off patch available
By_Metalink: the patch can be downloaded by Metalink or by ftp to updates.oracle.com
Note4:
Some products have have started patchset releases that are not in APPLFULL or APPLSHAR listing.
This means the program will have to be changed to support listing the latest of all patchsets and not
just the FULL/SHARED patchsets based products. An example of this is JTF is now distributed as
JTA and JTT, but both still patch JTF_TOP.
Typical Output of the Report_11i.txt
$ more Report_11i.txt
=============================================================================
Report Generated: Tue Apr 19 12:17:10 EDT 2005
Tool Version:4.19
Patchsets List Updated: Apr 18 22:30
Machine/OS: SunOS poseidon 5.8 Generic_108528-15 sun4u sparc SUNW,Sun-Blade-100
Domain: us.oracle.com
applptch Source: Patch.csv
Version from APPLPTCH: 11.5.5
Database: VIS1155
Limited Report to: APPLFULL and APPLSHAR products
APPLFULL: AK ALR AMS AP AR AS ASF ASO AST AU AX AZ BEN BIC BIL BIM BIS BIX BOM CCT CE CHV CN CRP CS CSC CSD CSF CSP CSR CSS CUF CUS CZ EC ECX ENG FA FII FLM FND FPT GL GMA GMD GME GMF GMI GML GMP GMS GR HRI HXC HXT HZ IBA IBE IBP IBU IBY ICX IEB IEM IEO IES IEU IEX IGW INV ISC JA JE JG JL JTF ME MRP MSC MSD MSO MSR OKC OKE OKS OKX ONT OPI OTA OZF OZP OZS PA PAY PER PJM PMI PN PO POA POM PSB PSP QA QP RG RHX RLM SSP VEA WIP WPS WSH WSM XDP XLA XNC XNM XNP XNS XTR
APPLSHAR: AD AMV ASG CUA CUI CUN CUP DT FF GHR IPA MFG OE PQH PQP RLA SHT VEH
Pseudo Products:ADX AME AML BPA CAC CSK CTB EDW EWS FWK HCT IGP IPATCH IRC ISX ITA JTA JTH JTO JTP JTT JTU JTY MSX OAM OCM OIE OIR OIT OWF PJR POV RCM RTC TXK UMX
Written By: Oracle Support Services
Program Updates: ftp://oracle-ftp/apps/patchsets/PATCHSET_COMPARE_TOOL/
Download Patchsets: Go to link below or click on Patches
http://metalink.oracle.com/metalink/plsql/dis_download.startup
=============================================================================
FAMILY PACK PATCHES
Product Baseline VersionRunning Version Latest Available,Status
------- ----------------- --------------- -----------------------
atg_pf
11i.ATG_PF.H(3438354), Rel-By_Metal
bis_pf
11i.BIS_PF.D.1(4054609), Rel-By_Metal
cc_pf
11i.CC_PF.R(3202573), Rel-By_Metal
com_pf
11i.COM_PF.A(2036253), Rel-By_Dev
dmf_pf11i.DMF_PF.E(1745355) 11i.DMF_PF.E(1745355) 11i.DMF_PF.J(2771139), Rel-Not_Dist
exchg_pf
11i.EXCHG_PF.C(2147366), Rel-By_Metal
fin_pf
11i.FIN_PF.C(2380068) 11i.FIN_PF.F(3153675), Rel-By_Metal
finap_pf
11i.FINAP_PF.A(1712173), Obs-By_Metal
finar_pf
11i.FINAR_PF.A(1712197), Obs-By_Metal
...
FULLY INSTALLED PRODUCTS
Product Baseline VersionRunning Version Latest Available,Status
------- ----------------- --------------- -----------------------
ak11i.AK.C(1553747) 11i.AK.C(1553747) 11i.AK.G(3263645), Rel-By_Metal
alr 11i.ALR.C(1575525)11i.ALR.C(1575525)11i.ALR.G(3261254), Rel-By_Metal
ams 11i.AMS.B(1339203)11i.AMS.C(1568669)11i.AMS.I(3025816), Rel-Not_Dist
ap11i.AP.E(1715446) 11i.AP.J(2375849) 11i.AP.M(3151444), Rel-Not_Dist
...
SHARED INSTALL PRODUCTS
Product Baseline VersionRunning Version Latest Available,Status
------- ----------------- --------------- -----------------------
ad11i.AD.D(1627493) 11i.AD.G(2344175) 11i.AD.I.1(4038964), Rel-By_Metal
amv 11i.AMV.D(1615230)11i.AMV.D(1615230)11i.AMV.I(3134012), Rel-Not_Dist
asg 11i.ASG.D(1580949)11i.ASG.D(1580949)11i.ASG.R(3263401), Rel-By_Metal
cua 11i.CUA.B(1422989)11i.CUA.B(1422989)11i.CUA.B(1422989), Rel-By_Metal
...
PSEUDO PRODUCTS
Product Baseline VersionRunning Version Latest Available,Status
------- ----------------- --------------- -----------------------
adx
11i.ADX.E.1(3817226), Rel-By_Metal
ame
11i.AME.A(3962268), Rel-By_Metal
...
ipatch
11i.IPATCH.B(2495518), Rel-By_Dev
jta
11i.JTA.F(3262486), Rel-By_Metal
jth
11i.JTH.R(3100686), Rel-By_Metal
jto
11i.JTO.R(3105667), Rel-By_Metal
jtp
11i.JTP.A(2014756), Obs-By_Metal
jtt
11i.JTT.E(3127042), Rel-By_Metal
...
oam
11i.OAM.H(3258830), Rel-By_Metal
ocm
11i.OCM.B(3373464), Rel-By_Dev
oie 11i.OIE.B(1633913)11i.OIE.E(1960506)11i.OIE.J(3618125), Rel-By_Metal
oir
11i.OIR.C(2396507)11i.OIR.F(3151380), Rel-By_Metal
oit 11i.OIT.B(1675976)11i.OIT.B(1675976)11i.OIT.D(2397276), Rel-By_Metal
owf
11i.OWF.H(3258819), Rel-By_Metal
...
Report_11i.txt Details
This is generally the same as the Report.txt report except it provides the Baseline, Running and Available all on one line. It does not include the patchsets availability, which can be obtained on Metalink or by looking at the Report.txt report. Some patchsets, may not be distributed only in Family Packs. Please review the following definitions:
Baseline Version:This is the baseline release version that came with your release i.e. 11.5.X
Running Version:This would be at a higher level than the Baseline if any patchsets have been applied for that Product.
Latest Available, Status:This is the highest available version available for that release.The Status part of this field shows two parts. 1) Patchsets/Family Pack Status 2) Distribution Status. They are explained below.
Status Field
1) PATCHSET STATUS:
Rel=Released, Sup=Superseded, Obs=Obsoleted
2) DISTRIBUTION STATUS:
By_Metal=On Metalink, Not_Dist=Not Available, By_Dev=Available from Development only
The Status Field was added in version 4.14.To have the report only show patchsets available for download from metalink, use the optional command line flag: latest=metalink
What are PSEUDO PRODUCTS? These are products that are not part of the core applications, but supporting these core products. A couple of good examples would be Workflow (OWF), and Oracle Application Manager (OAM). These were added in V. 4.17.
What are Consolidated Updates (CU) ? It is the latest Family of Patches for ATG and all critical patches since the latest ATG patchset. So with the new CU for ATG, 11i.ATG_PF.H(3438354) is the last Family Pack for ATG. All future code code updates for ATG will be released by CUs. The CUs only require that you apply the latest one.
top
4. More Details on the Patchsets Comparison Tool
This tool can be downloaded automatically from the Oracle ftp site and then run as a cron job with the output going to a web page. This will allow an internal web site that will always show what patchsets have been applied to that APPL_TOP.
------------------139684.1 |
