• About Me
  • Disclaimer
  • Now it’s time to change my Oracle ACE to Oracle ACE Director.

Oadba's Blog

~ The Infinite Reference for Oracle Apps DBAs

Oadba's Blog

Category Archives: Application Patching

Application Patching

Oracle Applications Current Patchset Comparison Utility – patchsets.sh

24 Thursday Mar 2011

Posted by oadba in Application Patching

≈ Leave a comment


Overview:
PATCHSETS.SH 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 OAM also provides a means to check your patch history directly from the Product.

How it Works:
This program utilizes the the applptch.txt file for 10.7-11.0. For 11i and R12, 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, 11.5.x, 12.0.x, and 12.1.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.

Latest Patchsets Comparison Download Locations
Unix or NT: ftp://ftp.oracle.com/support/outgoing/PATCHSET_COMPARE_TOOL/patchsets.sh

 

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

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.

Setup Requirements:
Must have connectivity to EBS database via sql*net with $TWO_TASK set
Source $APPL_TOP/APPSxx.env file or just setup database env such as ORACLE_HOME and TWO_TASK

11i – $ . $APPL_TOP/APPSORA.env
R12 – $ . $APPL_TOP/APPS{sid}_{machine}.env
Note: As long as you can connect with sqlplus and $TWO_TASK, the script should have the access it needs.

Usage: $ patchsets.sh [connect=11i_login/pw|applptch=/path/applptch.txt] [-h] [silent=y] default is n, [htmlout=file]

Subscribe

  • Entries (RSS)
  • Comments (RSS)

Archives

  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • February 2014
  • January 2014
  • December 2013
  • September 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • February 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • May 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • August 2010
  • July 2010
  • February 2009
  • January 2009

Categories

  • AD Utilities
  • Administration
  • Application Patching
  • Career Management
  • Certification
  • Cloning
  • DEMOs
  • Essential OS Commands
  • General
  • Installation
  • Monitoring & Troubleshooting
  • MOS Docs
  • My Oracle Support (MOS)
  • Oracle Cloud
  • Oracle Fusion Apps
  • Oracle Utilities
  • Oracle VM
  • Oracle Workflow
  • Patching
  • Performance & Tuning
  • RAC Specific
  • Scripts
  • Security
  • Troubleshooting
  • Uncategorized
  • Upgrades

Meta

  • Register
  • Log in

Blog Stats

  • 86,082 hits

OADBA Blog Search

May 2022
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« May    
Locations of visitors to this page

Documentation

  • Release 12.1 Documentation Library

Blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Oadba's Blog
    • Join 239 other followers
    • Already have a WordPress.com account? Log in now.
    • Oadba's Blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar