Thursday 28 December 2017

AD Utilities for Oracle Apps DBA

Dear DBA-Mates,
Again came back with some important stuff, which is very important for every DBA. As, I was busy with some Upgrade project. So, was not able to write and meet here you all.
I am writing these in hurry, If there is any corrections please let us know. And I have good News for you all, I have collected a very very IMP Questions for Interviews which we will be publish very shortly.
For Example:
What to do if Concurrent Program is Running Long?
What to do if Secondary is not syncing from Primary in DR?

I have many more Questions but because lack of time, I am not able to provide you all the Questions and Answers. But promise I will do very soon.
If you need only Questions , please let me know.

1.  What are AD Utilities?
2.  What is AutoPatch (or adpatch)?
3.  What is AD Administration (or adadmin)?
4.  What is AD Controller (or adctrl)?
5.  What is AD Relink (or adrelink)?
6.  How does ADADMIN know which form files to regenerate?

1.  What are AD Utilities?
Answer
------
AD Utilities are a group of tools designed to install, upgrade,
maintain, and patch a specific set of products contained in a
given release of Oracle Applications.


2.  What is AutoPatch (or adpatch)?
Answer
------
AutoPatch (adpatch) is a utility that is used to apply
individual patches, mini-packs, or maintenance packs to an
existing Oracle Applications instance.

For more details as per real time scenario, please check below:

3.  What is AD Administration (or adadmin)?
Answer
------
AD Administration (adadmin) performs maintenance tasks on an
installed Oracle Applications system to ensure that it runs
smoothly.  The tasks performed with this utility fall into
two categories: database and file system. 

1.   Generate Applications Files menu

2. Maintain Applications Files menu

3. Compile/Reload Applications Database Entities menu

4. Maintain Applications Database Entities menu

5. Change Maintenance Mode

6. Exit AD Administration



4.  What is AD Controller (or adctrl)?
Answer
------
AD Controller (or adctrl) is used in conjunction with other
AD Utilities (such as AutoInstall/AutoUpgrade, adadmin or
adpatch) to determine the status of workers and restart failed
tasks.
Manages parallel workers in AD Administration and AutoPatch.



Note: There is 8th hidden option to skip the workers.

5.  What is AD Relink (or adrelink)?
Answer
------
AD Relink (or adrelink) allows you to relink Oracle Applications
executable programs with the Oracle Server product libraries.
You can run the adrelink utility manually to relink individual
executable programs, or use the relink option in the AD
Administration utility to relink all executable programs.

Administration doesn’t relink AD executable.

For Example:
To relink adpatch, adsplice and adadmin:
adrelink.sh force=y “ad adpatch” “ad adsplice” “ad adadmin”

To relink all AD executables:
adrelink.sh force=y “ad all”

NEXT Question & Answers(ADADMIN , ADCONFIG and ADMRGPC)
>>>
Thanks & Regards,
ora-data Team

1 comment:

  1. Thanks for nice article on Oracle Apps AD Utilities.

    - Satya
    http://satya-appsdba.blogspot.com/2013/04/oracle-apps-dba-adutilities-interview.html

    ReplyDelete

Thank you for your comments and suggestions. It's good to talk you.