Tuesday, July 27, 2010

AD Utilities for Apps DBA

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 .

-------------------------------------------------------------------------------------------------

Source:- http://onlineappsdba.com/index.php/2006/08/09/ad-utilities-for-apps-dba/

-------------------------------------------------------------------------------------------------

No comments:

Post a Comment