Home / APPS DBA / A Brief Introduction to ADPatch

A Brief Introduction to ADPatch

A Brief Introduction to ADPatch

AutoPatch (adpatch)

“AutoPatch (adpatch) is the utility you use to apply patches to the Oracle E-Business Suite file system or database.”


Modes Of adpatch

There Are Four Modes given Below In which ADpatch Can Be User

  1. Interactive mode
  2. Non-Interactive mode
  3. Test mode
  4. Pre-Install mode


Interactive Mode

It is the default mode of ADpatch. We can apply patch in this mode by going into patch directory and simply type adpatch in command prompt and hit enter.



You can apply Patch in this mode as:

$adpatch Interactive=no

It uses default files to store prompt values and can be applied from patch directory.


Test Mode

This mode is purposely used to check what exactly patch will do without actually changing anything.

We can apply patch in this mode as:

$adpatch apply=no

By default apply=yes


PreInstall Mode

This mode is used for any upgrade or consolidated update of utilities itself. It is suggested to apply pre-install patch first.

When we apply patch in preinstall mode, it updates all AD utilities before upgrade or update.

We can apply adpatch in this mode as:

$adpatch preinstall=y


Options used in adpatch

We have multiple adpatch options and based on the requirement we can use specific options.


This options is used to skip the autoconfig execution, whereas by default it executes the autoconfig and updates the configuration file if any template file is added. This option is helpful when we apply multiple adpatch and they are not merged.

$adpatch options=noautoconfig


Nocompiledb(without compiling database)

While we apply adpatch, It may create invalid objects and by default adpatch compiles the invalid objects after patch application. But in case you do not want to compile invalid objects to ensure the minimal autopatch time, you can apply adpatch as below:

$adpatch options=nocompiledb



This option is used to apply adpatch without copying the files present in copy driver. This can be applies as:

$adpatch options=nocopyportion



Adpatch also compiles the java server pages(JSP) after completion of patch application and can be skipped using the option nocompilejsp as below:

$adpatch options=nocompilejsp



Nodatabaseportion option is used to skip the adpatch the activity of database driver. It can be used as:

$adpatch options=nodatabaseportion



Nogenerateportion option is used to skip the adpatch activity of generate driver portion of the patch  and you can use the option nogenerateportion as below:

$adpatch options=nogenerateportion


Maintenance Mode disabled

This option is used to apply patch without enabling maintenance mode. It can be used as:

$adpatch options=hotpatch



This option is used to skip the relinking and can be used as:

$adpatch options=nolink



This option is used to skip the generate form file. It can be used as:

$adpatch options=nogenform



This Option is used to execute the maintain MRC schema as part of patch. By default maintain MRC is done for standard patch and is disabled for documentation and translation patches.

$adpatch options=nomaintainmrc



This option is used to skip the pre-requisite Checks of Patches. This option can be used as below:

$adpatch options=noprereq




About Syed

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