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

Oracle E-Business Suite (EBS) R12 relies heavily on AutoConfig to maintain configuration consistency between the Application Tier and Database Tier.

Prerequisites

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

Recreating the appsutil directory on the Database Tier is commonly required when:

• Database ORACLE_HOME is replaced or corrupted.
• AutoConfig files are missing.
• Database host, port, SID, or DB name changes.
• Database upgrade or migration (e.g., 11g → 19c).
• Cloning activities.
• AutoConfig fails because the appsutil directory is incomplete.

Step 1: On Application Tier

Source the Application Environment

$ . $APPL_TOP/APPSSID_hostname.env

Step 2: Run AutoConfig on Application Tier

$ sh $ADMIN_SCRIPTS_HOME/adautocfg.sh

Verify AutoConfig completes successfully before proceeding.

Step 3: Generate appsutil.zip using admkappsutil.pl

$ perl $AD_TOP/bin/admkappsutil.pl

Starting the generation of appsutil.zip

Log file:

$INST_TOP/admin/log/MakeAppsUtil_xxxxx.log

Output:

$INST_TOP/admin/out/appsutil.zip

MakeAppsUtil completed successfully.

The generated file will be located at:

$INST_TOP/admin/out/appsutil.zip

Step 4: Source Database ORACLE_HOME Environment

source $ORACLE_HOME/SID_hostname.env

Step 5: Copy appsutil.zip to Database Tier

$ scp $INST_TOP/admin/out/appsutil.zip  oracle@<DB_SERVER_IP>:$ORACLE_HOME/

or use FTP/WinSCP if preferred.

Step 6: Backup Existing appsutil

Always take a backup.

$ cd $ORACLE_HOME

$ mv appsutil appsutil_backup_$(date +%F)

If only refreshing:

$ cp -rp appsutil appsutil_bkp

Step 7: Unzip appsutil.zip under $ORACLE_HOME

$ cd $ORACLE_HOME

$ unzip -o appsutil.zip

You should now have:

$ORACLE_HOME/appsutil

Step 8: Generate Database Context File

$ cd $ORACLE_HOME/appsutil/bin

$ perl adbldxml.pl

or

$ perl adbldxml.pl appsuser/pwd

It will ask for:

APPS password
Database hostname
Listener port
SID

A new context file is created:

$ORACLE_HOME/appsutil/<CONTEXT_NAME>.xml

This step is required because the unzipped Appsutil directory does not initially contain the scripts directory.

Step 9: Create scripts Directory

$ cd $ORACLE_HOME/appsutil/bin

$ sh adconfig.sh contextfile=$ORACLE_HOME/appsutil/<CONTEXT_NAME>.xml

This creates:

$ORACLE_HOME/appsutil/scripts/<CONTEXT_NAME>/

Step 10: Run AutoConfig on the Database Tier

$ cd $ORACLE_HOME/appsutil/scripts/<CONTEXT_NAME>

$ sh adautocfg.sh

Enter the APPS password
Successful completion should display:
AutoConfig completed successfully.

Step 11: Verify

Verify the scripts directory exists:

ls -lrt $ORACLE_HOME/appsutil/scripts

Verify the context file:

ls $ORACLE_HOME/appsutil/*.xml

Check the AutoConfig log:

$ORACLE_HOME/appsutil/log

or

$ORACLE_HOME/appsutil/scripts/<CONTEXT_NAME>/<timestamp>/adconfig.log

Directory Structure After Recreation

$ORACLE_HOME
│
├── appsutil
│   ├── admin
│   ├── bin
│   ├── driver
│   ├── install
│   ├── log
│   ├── scripts
│   │      └── <CONTEXT_NAME>
│   │              ├── adautocfg.sh
│   │              ├── addbctl.sh
│   │              ├── addlnctl.sh
│   │              └── ...
│   ├── template
│   └── <CONTEXT_NAME>.xml