Creating Appsutil directory for DB Tier in EBS R12

Creating Appsutil directory for DB Tier in EBS R12

When  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.

 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

Step 3: Uncompress appsutil.zip under the  

     $ cd $ORACLE_HOME
     $ unzip -o appsutil.zip

Step 4: Create Contextfile

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

Step 5: Create Scripts directory

     $ cd $ORACLE_HOME/appsutil/bin
     $ sh adconfig.sh contextfile=

Step 6:  Run AutoConfig on the

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

This way you can create a context file .