Showing posts with label AD Utilities for Apps DBA. Show all posts
Showing posts with label AD Utilities for Apps DBA. Show all posts

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/

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