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.
ADPATCH ?
is a utility that is used to apply individual patches, mini-packs, or maintenance packs to an Oracle Applications instance.
ADADMIN ?
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.
ADCTRL ?
Utility to determine status of worker (started by adpatch , adadmin or other ad utility) and to control ( restart/drop/skip) workers.
ADRELINK ?
Used to relink apps executables with product libraries , if some library defination is changed or executable is corrupted.
ADMRGPCH ?
To merge different patches & create single patch . This is helpful when you have too many patches , you can merge them & apply in one shot.
ADCLONE ?
Utility to clone Insatnce from Test to Prod , Vice Versa
ADCONFIG ?
To configure different components in Aplications like changing port number or domainname or incresing number of JVM’s
ADIDENT ?
utility to find version of a file in oracle applications (Identification )
ADLICMGR ?
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
ADSPLICE ?
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