Tuesday, 13 August 2013

Definition of AD utility

As salamo alaikum wa rahmatullah

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.

Thanking you
Mohammad Shahnawaz
oracle's passion


  1. Hi,

    AD Splicer

    AD Splicer can't be used to add custom, non-Oracle products to your APPL_TOP.

    AD Splicer must be run for each APPL_TOP and database combination.

    AD Splicer requires two type of configuration file.
    ->Product configuration file
    ->Product definition file

    Thanking you

    1. Hello,
      Thanking you Mr. Anonymous

      Mohammad Shahnawaz
      oracle's passion