Saturday, January 21, 2012

Patch Application Assistant (admsi.pl) in Oracle Apps R12


PAA (Patch Application Assistant) is tool/Perl script to generate customized installation instructions for a patch in Oracle Applications R12 which helps user totrack and perform manual steps during patching.

1. admsi.pl is under $AD_TOP/bin
2. You can run admsi.pl (Patch Application Assistant) in two mode
i) GUI (Graphical User Interface)
ii) CLI (Command Line Interface)
3. Once you complete manual steps as instructed in PAA report, you can record that step as completed.
.
How to Run PAA (Patch Application Assistant) in R12
1.Source environment file i.e. $ORACLE_R12_BASE/ apps/ apps_st/ appl/ APPS[SID]_[hostname].env
2.Run PAA using admsi.pl in either CLI or GUI
2.1 CLI
perl admsi.pl -patch_top=[patch-top-directory]-appspass=[apps-password]
For example to generate PAA report for 12.0.6 patch (6728000) run it as  
perl $AD_TOP/bin/admsi.pl -patch_top=/stage/ oracle/ patches/ r12/ 6728000 -appspass=apps
Gathering Information..
Logfile for this session is located at admsi.log
Generating installation instructions for patch 6728000..
Updating database….
install_6728000.html generated successfully
install_6728000.txt generated successfully
Now view report (text or html format) containing manual steps for 12.0.6
 .
2.2 GUI
 Invoke PAA in GUI by running admsi.pl as shown below

3. Once you get list of manual steps, follow instructions in report
4. Apply apps patches using AUTOPATCH utility (adpatch)

Source : http://onlineappsdba.com/index.php/2008/11/11/admsipl-patch-application-tool-in-oracle-apps-r12/


2 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Use full post ...

    U can also find usefull stuff on

    http://www.appstier.blogspot.in/

    ReplyDelete