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)

Share This Post with Your Friends over Social Media!

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

Reply
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)

Reply
paulinha says February 25, 2009

It’s all correct… 🙁

Reply
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;

Reply
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

Reply
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

Reply
» 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 […]

Reply
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.

Reply
kishore says July 19, 2012

Hi, Am The new to Apps DBA.

Why we need to run adgrants.sql ..??

Please Reply me.

Reply
rahil says February 11, 2015

Hi,
Whenever iam trying to run admsi.pl

Iam getting error as follows:

Invoking Oracle Patch Application Assistant….
Please set the DISPLAY variable and re-run this script

Can anyone please help me how to solve this issue.

Reply
Atul Kumar says June 8, 2015

You need X server to run admsi.pl

Reply
Add Your Reply