Home / APPS DBA / Oracle AD Controller

Oracle AD Controller

Oracle AD Controller

  • ADCTRL is used to manage worker processes that perform a pivotal role in the function of batch processing for patching and many other Applications activities.
  • ADCTRL is located under $AD_TOP/bin directory with Oracle E-Business Suite.


Procedure to Run AD controller


Step 1 : Login as Applications Tier user & run the environment file.

$cd /prod/ebs/apps/prodappl

$ . ./APPSORA.env


Step 2 : Run the following AD controller command.

$ adctrl

You will be prompted for the location of $APPL_TOP,  Password of APPLSYS and APPS. After providing the above information the AD controller menu will appear as shown below.


AD Controller Menu

  1. Show worker status
  2. Tell worker to restart a failed job
  3. Tell worker to quit
  4. Tell manager that a worker failed its job
  5. Tell manager that a worker acknowledges quit
  6. Restart a worker on the current machine
  7. Exit


Checking Status of the Worker


choose the first option “Show worker status“.



Note: If there is no session used by the workers, then the following message will appear:

Error: The FND_INSTALL_PROCESSES table does not exist.

This above given table is used for communication with the worker processes, and if it does not exist, it means that the workers are not running, and the ad utility has not started them yet.


Meaning of Worker Status




WaitingThe worker is idle.
AssignedA job was assigned by the manager to a worker but the worker didn’t start the job.
RunningThe worker is running a job.
FailedThe job failed due to an error.
Fixed, RestartWhen  a  jobs  restart  after  the  error  has  been  fixed (during this time the worker run the failed job).
RestartedAfter the error has been fixed, the worker will have the status “Fixed, Restart” and after that “Restarted”. (The status will not change to “Running”)
CompletedThe job was completed and the manager did not yet assigned another job to that worker.


Database Processing Phases Concept

  • Whenever a Database Patch operation will runs, the tasks are divided into functions. This is done by Oracle when the patch is created.
  • Suppose a patch will create 2 tables and 2 sequences. In this case the patch driver contains 2 phases, one for tables creation and one for sequences creation.
  • Because the sequences could be created in the same time, this will be done in parallel by using more workers.


Examples of Database Processing Phases:

seq = create sequence

tab = create tables, synonyms, grants privileges on tables pls = create package specification

plb = create package body

vw = create views



About Syed Saad Ali

As a certified and experienced Oracle Database Administrator with Almost 10 Years of Experience I am able to perform all levels of database maintenance and am fully qualified to do Oracle updates as well. Capitalizing on my interest in Business & IT both, I chose to navigate my career towards Enterprise Solutions, which has enabled me to excel in the combination of both. I have developed exceptional analytical skills that allow me to diagnose and take care of issues immediately. Extremely skilled in planning and execution of special projects in time- critical environments. Extensive knowledge in directing, coordinating and exercising concern authority for planning, organization, control and successful completions. Very skilled at solving customer relations issues by seeking first to understand and then to be understood. Effectively able to communicate with customers, vendors and management.

Check Also

JSP error Request URI:/OA_HTML/RF.jsp java.lang.NoClassDefFoundError

ERROR JSP Error: Request URI:/OA_HTML/RF.jsp Exception: java.lang.NoClassDefFoundError JSP Error: Request URI:/OA_HTML/AppsLocalLogin.jsp Exception: java.lang.NoClassDefFoundError More from …

Leave a Reply