Recreating the /appsutil/scripts/ directory in EBS

When I have executed $AD_TOP/bin/admkappsutil.pl to generate appsutil.zip file, I didn't find the scripts directory under $ORACLE_HOME/appsutil.
To fix this issue, need to run 'perl $ORACLE_HOME/appsutil/bin/adbldxml.pl' utility, this will create a new context file on the database tier.
The new context file acts as a central repository for database configuration information. The adbldxml Utility is only supported on the Database Tier, not on the Applications Tier.

With using newly generated DB context file need to run $ORACLE_HOME/appsutil/bin/adconfig.sh on DB tier.  Now the scripts directory will be created under  $ORACLE_HOME/appsutil directory.

Follow below detailed steps:

1. On the Application Tier (as the APPLMGR user)

2. Log in to the APPL_TOP environment (source the environment file)

3. Create appsutil.zip file

4. perl /bin/admkappsutil.pl

5. This will create appsutil.zip in $APPL_TOP/admin/out .

6. Copy or FTP the appsutil.zip file to the DB Tier RDBMS ORACLE_HOME

7. Go to database ORACLE_HOME and unzip the appsutil directory .

       
unzip -o appsutil.zip
       
 

8. Generate Database Context File and follow the steps below:

source DB env 
cd /appsutil/bin perl adbldxml.pl

-bash-3.2$ perl adbldxml.pl

Starting context file generation for db tier..
Using JVM from /u01/R12EBS/12.1.0.2/appsutil/jre/bin/java to execute java programs..
APPS Password:

The log file for this adbldxml session is located at:
/u01/R12EBS/12.1.0.2/appsutil/log/adbldxml_09300206.log

Could not Connect to the Database with the above parameters, Please answer the Questions below


Enter Hostname of Database server: HYDLAB02

Enter Port of Database server: 1524

Enter SID of Database server: UPG1220

Enter Database Service Name: UPG1220

The context file has been created at:
/u01/R12EBS/12.1.0.2/appsutil/UPG1220_HYDLAB02.xml
-bash-3.2$       
 

9. Run  adconfig.sh on DB tier. After running adconfig.sh, the scripts directory will be created under appsutil directory.

-bash-3.2$ pwd
/u01/R12EBS/12.1.0.2/appsutil/bin
-bash-3.2$
-bash-3.2$
-bash-3.2$ ./adconfig.sh
Enter the full path to the Context file: /u01/R12EBS/12.1.0.2/appsutil/UPG1220_HYDLAB02.xml
Enter the APPS user password:
The log file for this session is located at: /u01/R12EBS/12.1.0.2/appsutil/log/UPG1220_HYDLAB02/09300209/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /u01/R12EBS/12.1.0.2
        Classpath                   : :/u01/R12EBS/12.1.0.2/jdbc/lib/ojdbc6.jar:/u01/R12EBS/12.1.0.2/appsutil/java/xmlparserv2.jar:/u01/R12EBS/12.1.0.2/appsutil/java:/u01/R12EBS/12.1.0.2/jlib/netcfg.jar:/u01/R12EBS/12.1.0.2/jlib/ldapjclnt12.jar

        Using Context file          : /u01/R12EBS/12.1.0.2/appsutil/UPG1220_HYDLAB02.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.
-bash-3.2$
-bash-3.2$
-bash-3.2$ cd ../scripts/
-bash-3.2$ ls -lrt
total 4
drwxr-xr-x 2 oracle dba 4096 Sep 30 02:09 UPG1220_HYDLAB02
-bash-3.2$ cd UPG1220_HYDLAB02
-bash-3.2$ ls -rlt
total 72
-rw------- 1 oracle dba  1257 Sep 30 02:09 adstrtdb.sql
-rw------- 1 oracle dba   811 Sep 30 02:09 adstopdb.sql
-rwx------ 1 oracle dba 27246 Sep 30 02:09 adpreclone.pl
-rwx------ 1 oracle dba  3670 Sep 30 02:09 adlsnodes.sh
-rwx------ 1 oracle dba  7347 Sep 30 02:09 adexecsql.pl
-rwx------ 1 oracle dba  6724 Sep 30 02:09 addlnctl.sh
-rwx------ 1 oracle dba  2775 Sep 30 02:09 addbctl.sh
-rwx------ 1 oracle dba  5541 Sep 30 02:09 adchknls.pl
-rwx------ 1 oracle dba  1483 Sep 30 02:09 adautocfg.sh
-bash-3.2$
       
 

That's it, hope this article will help you. :)