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 to track 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

Next step is to select from one of three options, I selected option 1 i.e. to find instance specific instructions for 12.0.6 patch (6728000)

3. Once you get list of manual steps, follow instructions in report

4. Apply apps patches using AUTOPATCH utility (adpatch)

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

11 comments

paulinha says February 25, 2009

Hi Atul,
This post was very helpful, I had no idea how to use admsi.pl. I’m having an error while running it, maybe you can help. I’m new to oracle so please bear with me. I’m applying patch 6728000 (RUP6) and when I run admsi I get the following error:

[applmgr@hufflepuff bin]$ perl admsi.pl -patch_top=/usr/paula/patches/6728000/ -appspass=apps
Gathering Information..
Logfile for this session is located at admsi.log
Error:
Unable to connect to PROD database.

The log file doesn’t help, it says the exact same thing and nothing more. I’ve searched the internet and Metalink and I can’t find the cause of the error. Do you know what’s the issue and how to solve it?

Thanks in advance,
Paula

Atul Kumar says February 25, 2009

Paula,
Check your environment variable is set and apps password is correct.

– echo $TWO_TASK (this sould set same as SID)
– sqlplus apps/apps (where second apps is your apps password)

paulinha says February 25, 2009

It’s all correct… 🙁

Atul Kumar says February 25, 2009

Update output of

1. echo $TWO_TASK

2. sqlplus apps/apps

3. SQL> select instance_name from v$instance;

paulinha says February 25, 2009

1. applmgr@hufflepuff bin]$ echo $TWO_TASK
PROD

2. applmgr@hufflepuff bin]$ sqlplus apps/apps
SQL*Plus: Release 10.1.0.5.0 – Production on Wed Feb 25 11:06:44 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – Production
With the Partitioning, OLAP and Data Mining options

3. SQL> select instance_name from v$instance;
INSTANCE_NAME
—————-
PROD

Atul Kumar says February 25, 2009

Strange…

Try

perl admsi.pl -patch_top=/usr/paula/patches/6728000 -appspass=apps

No forward slash after patch directory if this is still an issue raise as bug with Oracle

» Oracle Apps 11i/R12 AutoPatch adpatch / admsi.pl Online Apps DBA: One Stop Shop for Apps DBA’s says August 12, 2009

[…] to track and perform manual steps during patching (applicable for R12 only). More information here PAA Tool in R12 4. OAM – Oracle Application Manager (OAM) is web based tool to apply oracle apps […]

Imran says June 16, 2010

Atul! What a genius you are. I am novice to Oracle Apps and I have no access to metalink. While everyone else is pointing to metalink articles you described it in layman language which at least I understood. I salute you for all your contributions. Thank you.