AD Utilities for Apps DBA

From now to next few sessions I will be discussuing very important product from DBA’s prespective i.e. AD also called as Application DBA ( 😉 I think its named AD after Application DBA )

AD_TOP is product in Aplication which is under directory APPL_TOP/ad/11.5.0 ( If you are not familiar with TOP please read my previous post about TOP’s )

This top containin Utilities & program code which is very frequently used by DBA’s . So where are these utilities or program in file system ? (I think you all know but for begineers its in AD_TOP/bin )

Lets see one line definition of each

AD Utility ?
AD Utilities are a group of tools designed to install, upgrade, maintain, and patch applications.

is a utility that is used to apply individual patches, mini-packs, or maintenance packs to an Oracle Applications instance.

AD Administration (adadmin) is used performs maintenance/administration tasks on an Oracle Appls Instance. Task associated with adadmin are divided into two broad categories database and file system task.

Utility to determine status of worker (started by adpatch , adadmin or other ad utility) and to control ( restart/drop/skip) workers.

Used to relink apps executables with product libraries , if some library defination is changed or executable is corrupted.

To merge different patches & create single patch . This is helpful when you have too many patches , you can merge them & apply in one shot.

Utility to clone Insatnce from Test to Prod , Vice Versa

To configure different components in Aplications like changing port number or domainname or incresing number of JVM’s

utility to find version of a file in oracle applications (Identification )

To license a product in applications , you might have license to use only 10 products initially then later decided to use 5 more so license them first by this utility

You add a product in application, by default you might have 90-105 ( may be more ) products like AP, GL, AR and now oracle released one more product so add this product using this utility .

This is overview & usages of each application DBA Utility , now in next topic I will start with patching & how these utilities are used & options available with them . If you are amazed/confused whats this patching donot worry I will explain in deatil but if you are a DBA you might already be knowing patching & might have applied coupel of database patches using opatch now lets use ADPATCH to apply application or apps patches.

Donot forget to leave your comment & feedback .

Oracle Apps DBA / Apps training

Share This Post with Your Friends over Social Media!

About the Author Atul Kumar

Leave a Comment:

Anonymous says August 9, 2006

What is the difference between a patch and a minipack, family pack etc.

Anonymous says August 9, 2006

Next topic is applying patch i guess ?

Can you please let us know with a sample example, also link to download a small patch and apply the same.

Anonymous says August 9, 2006

very helpful. Thanks and keep the good work.

Atul Kumar says August 10, 2006

Sure, I will include demo patch or give a link to download it from my site . If I forget please do remind me to upload a sample demo patch .

Oracle Apps DBA

fhasweh says August 10, 2006

good work keep the good job


Atul Kumar says August 11, 2006

Hi Users,
I checked with Oracle Team , If I can pass on any Demo patch to User’s without metalink ID & they came back saying I am not allowed to do so , Hence I will not Upload any patches .

Anonymous says August 21, 2006

This is very good. please include cloning documenst for multinode to single ode on hp/solaris env and also on rapid clone ..

Atul Kumar says August 21, 2006

I will post multinode to single node clone & rapid clone. I am afraid I might not be able to go to detail specific to Operating System. I am trying to give overview of topics used by Apps DBA. I’ll definately point out specific metalink note specific to O.S.


sanjay says September 15, 2006

if i am applying one patch and some bug has been occured during application of patch. it is suggested that new new patch is to be applied what will be the steps ?

Atul Kumar says September 18, 2006

In such cases you have to come out of first patch session by ctrl + C or ctrl + D when you restart adaptch again it will prompt you if you want to restart from where you left last time say No & then select new patch you want to apply .


Anonymous says February 9, 2007

my question is still unanswered…
could you please let me know whats the option “Copy files to destination” in adadmin?

Atul Kumar says February 9, 2007

For Copy file to destination , It checks file version in respective location with one in patch directory & if it finds higher version in patch directory of a product it replaces them with one in patch directory .

Do you wish to copy UNCONDITIONALLY when a target file exists [No] ?

Processing files Application Object Library…

Processing files Application Utilities…

Processing files Applications DBA…

Processing files Common Modules-AK…

Processing files Subledger Accounting…

In logs you will see entry like

Version check:
version is equal to or lower than
File will not be copied to destination.

Up-to-date : cztag.jar
WARNING: The following path(s), defined in /u01/test/appl/cz/11.5.0/ja
va/make/czjar.dep as elements of the output file cztag.jar, could not be found i
n any area:


pavan says February 27, 2007

i want to know about ad utilities , ad patching n ad clone

Atul Kumar says February 27, 2007

Hi Pavan,
adpatch, adclone, adident, adadmin … are all ad utility . Do let me know on which ad utility you want to hear more & to what deapth . Few things about adpatch you can find in “PATCHING” at left menu bar of this blog

Anonymous says March 2, 2007

whats generate jar files?what exactly does adadmin do when it generates the jar files?

Atul Kumar says March 3, 2007

Hi Anonymous

This is from Apps maintenance utilities guide

It signs JAR files (if on the web server) and does the following:

Anonymous says March 6, 2007

I have already read this guide but it doesnt answer my question thats why tried ur generates jar files means???what exactly does it do while generation????

Atul Kumar says March 6, 2007

Anonymous JAR files are java archives (collection of java files with ext .java) these java files are used in java programming on which apps is built . Generate jar files wil generate these jar files in your JAVA_TOP & copy them to APPL_TOP. This option (generate jar files) also create some zip files (java related) & other java files.

Do let me know if you have any further doubt in this.

Anonymous says March 7, 2007

i think ur understanding is wrong. java code is never shipped. its the class files that are shipped and class files cant be compiled witout the java code. thats why i was wondering what exactly happens during this step???sorry to bug u but i guess u dont have the answer with u….

Atul Kumar says March 7, 2007

Hi Anonymous,
Thanks for the feedback.


Nikhil says April 26, 2007

Hi Atul!

U have done a great job!

These are all very usefull for DBA starters.

Keep Going!!


supriya reddy says August 11, 2007

hi atul!!

u have done really a good job!!
kepp going .

Nainesh says June 22, 2018

Learn something new from here….Thanks Atul sir.

Add Your Reply