Re-Creating Appsutil Directory for DB Tier in Oracle EBS R12 (Step-by-Step Guide)

Oracle E-Business Suite (EBS) R12 relies heavily on AutoConfig to maintain configuration consistency between the Application Tier and Database Tier. During database administration tasks—such as changing the database port, host, SID, or database name—you must update the Database Tier configuration properly.

In such scenarios, the appsutil directory on the Database Tier may need to be re-created to ensure AutoConfig runs successfully and the environment remains stable.

This guide explains the complete procedure to re-create Appsutil for DB Tier in EBS R12 in a simple and clear way.

Prerequisites

Before starting, ensure:

  • You have access to both Application Tier and Database Tier
  • You know the APPS password (for context file generation)
  • You have valid environment sourced on both tiers

Step-by-Step: Re-Create Appsutil Directory for DB Tier in EBS R12

On the Application Tier

Step 1: Source the Oracle Applications Environment

source $APPL_TOP/APPSSID_hostname.env

This sets the environment variables needed to run EBS utilities.

Step 2: Run AutoConfig on Application Tier

sh $ADMIN_SCRIPT_HOME/adautocfg.sh

This ensures the Application Tier configuration is up to date before generating appsutil.

Step 3: Generate appsutil.zip using admkappsutil.pl

perl $AD_TOP/bin/admkappsutil.pl

After successful execution, the utility generates:

appsutil.zip

Location:

$INST_TOP/admin/out/appsutil.zip

On the Database Tier


Step 1: Source Database ORACLE_HOME Environment

source $ORACLE_HOME/SID_hostname.env --> If not present then source
Oracle SID, Path, Oracle Home

This prepares the database environment to extract and configure Appsutil.

Step 2: Copy appsutil.zip to Database ORACLE_HOME

Copy the file from the Application Tier:

scp $INST_TOP/admin/out/appsutil.zip <db_host>:$ORACLE_HOME

(Use your actual DB hostname and path)

Step 3: Unzip appsutil.zip under ORACLE_HOME

cd $ORACLE_HOME
unzip -o appsutil.zip

This creates the directory:

$ORACLE_HOME/appsutil

Step 4: Create the Database Context File

Go to the appsutil bin directory:

cd $ORACLE_HOME/appsutil/bin

Now generate the context file:

perl adbldxml.pl appsuser=apps

You will be prompted for the APPS password.

This generates the context file usually under:

$ORACLE_HOME/appsutil/<SID>_<hostname>.xml

Step 5: Create Scripts Directory

Run adconfig to generate scripts:

cd $ORACLE_HOME/appsutil/bin
sh adconfig.sh contextfile=<contextfile path>

Example:

sh adconfig.sh contextfile=$ORACLE_HOME/appsutil/PROD_dbhost.xml

This creates the scripts folder:

$ORACLE_HOME/appsutil/scripts/<context_name>/

Step 6: Run AutoConfig on the Database Tier

Finally run AutoConfig using the newly created scripts:

sh $ORACLE_HOME/appsutil/scripts/<context_name>/adautocfg.sh

Example:

sh $ORACLE_HOME/appsutil/scripts/PROD_dbhost/adautocfg.sh

Verification Steps (Recommended)

After AutoConfig completes, validate the following:

Confirm appsutil directory exists

ls -ld $ORACLE_HOME/appsutil

Confirm scripts directory exists

ls -l $ORACLE_HOME/appsutil/scripts/

Check AutoConfig logs

DB Tier logs are stored in:

$ORACLE_HOME/appsutil/log/<context_name>/






Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment