Using Oracle Applications Current Patchset Comparison Utility

So far from my initial impression, this is the most comprehensive patch analysis tool among the several choices offered by oracle. Its output is very informative, showing your current running app/module versions against what is currently available from oracle.

Get it from:

ftp://ftp.oracle.com/support/outgoing/PATCHSET_COMPARE_TOOL/patchsets.sh

The program compares the currently installed patchsets and family packs to the most recently available ones generated by Oracle Development.

This script is updated nightly by oracle dev team appending patchset/family pack into it.
So this the info that this script generate will only be as up-to-date as of the last time you grabbed this from the ftp site.

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  connect=apps/apps debug=y
              $ ./patchsets.sh  connect=apps/apps debug=y (if you have a problem send this)
             
$ ./patchsets.sh applptch=/applptch_11i.txt htmlout=Report.html silent=y
              $ ./patchsets.sh  connect=apps/apps available=metalink
                            (Restrict to Metalink Available patchsets)
              $ ./patchsets.sh htmlout=$OA_HTML/Report.html silent=y

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

TO RUN UNDER NT with MKS:

a) Get to the drive where the appl_top is.
  C:> D:
  D:\>
  Make a tmp directory on that drives root.
  D:> mkdir tmp (this is where the patchset lists get created)

b) cd to the APPL_TOP path and then execute the envshell to setup the env variables.
  D:\> cd D:\apps\visappl
  D:\apps\visappl> envshell

  -> A new window spawns with the correct env settings, use it for step 3
c) Start the MKS SHELL,
  D:\apps\visappl> sh
  $
d) Run the patchsets program from the APPL_TOP/admin/ directory
  $ cd /admin/VIS
  $ ./patchsets.sh applptch=applptch.txt

————————————–
Doc ID:     139684.1

Advertisements

About this entry