Re-Creating Appsutil directory for DB Tier in EBS R12

Lets assume, while performing DB activities If plan to change the database port, host, SID, or database name parameter on the database server, you must also update AutoConfig on the database tier and also de-register the current database server node. So such cases we need to Re-Create Appsutil directory for DB Tier.

Follow below steps to Re-Create Appsutil and sub directories for DB Tier:

On the Application Tier:

Step 1: Source the environment variables for Oracle Applications

     $ source $APPL_TOP/APPS.env

Step 2: Run AutoConfig on the APPL_TOP

     $ sh $ADMIN_SCRIPT_HOME/adautocfg.sh

Step 3: Execute admkappsutil.pl utility to create the file appsutil.zip

     $ perl $AD_TOP/bin/admkappsutil.pl

   admkappsutil.pl utility will create appsutil.zip in $INST_TOP/admin/out directory

On the Database Tier:

Step 1: Source the environment variables for RDBMS ORACLE_HOME

     $ source $ORACLE_HOME/.env

Step 2: Copy the created appsutil.zip file from $INST_TOP/admin/out to the <RDBMS ORACLE_HOME>

Step 3: Uncompress appsutil.zip under the <RDBMS ORACLE_HOME>  

     $ cd $ORACLE_HOME
     $ unzip -o appsutil.zip

Step 4: Create Contextfile

     $ cd $ORACLE_HOME/appsutil/bin
     $ perl adbldxml.pl appsuser=apps

Step 5: Create Scripts directory

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

Step 6:  Run AutoConfig on the <RDBMS ORACLE_HOME>

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

Thats it. Hope this article will help you :)