ORACLE_EBS_CLONING_ISSUES.MD

Issue 1 - ADCFGCLONE completes for Application Server but Autoconfig fails

Problem

Sample errors that can be found at the bottom of $INST_TOP/admin/log/ApplyAppsTier_xxxx.log

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
      <filename>  <phase>  <return code where appropriate>

  [SETUP PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/oracle/inst/apps/DBgood_goodapp1/admin/install
      adgendbc.sh             INSTE8_SETUP       1


AutoConfig is exiting with status 1

RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyApplTop
ERROR: AutoConfig completed with errors. Check logfile at /u01/oracle/inst/apps/DBgood_goodapp1/admin/log/ApplyAppsTier_09270001.log for details.
ApplyApplTop Completed Successfully.

• Problem References: http://manishnashikkar.blogspot.com/2013/08/autoconfig-was-failing-on-adgendbcsh.html

• Why does it fail? Check $FND_SECURE/<DB_NAME>.dbc file

# Example FND_SECURE directory  
FND_SECURE=/u01/oracle/inst/apps/<DBNAME>_<APPHOST>/appl/fnd/12.0.0/secure

• How it should not be.

# $Header: template.dbc 120.0 2005/05/07 16:45:30 appldev ship $
# TEMPLATE.dbc
#   Template database configuration file.
#
#   Create one copy of this file for each database instance this
#   Applications Server will connect to.  Each file should have the name
#       <database_instance_name>.dbc
#   and be located in this directory ($FND_TOP/secure).
#   Change each of the parameters below to values appropriate for
#   the database instance.  Do not change the syntax.
#
#   This file can be gererated using the AdminAppServer tool.
#   This is a java utility that can be run from the command line.
#   Instructions to use this tool are documented in the Applications
#   Sysadmin Manual.

#
# TWO_TASK
#   SQL*Net name of database.
#
TWO_TASK=database

#
# FNDNAM
#   Oracle User to be used for Oracle Applications connection.
#   The FNDNAM Oracle User must have Oracle Applications privilege level
#   'Universal'.
#
FNDNAM=APPS

#
# GWYUID
#   Oracle User/Password of the public account to be used for initial
#   Oracle Applications connection.
#   The GWYUID Oracle User must have Oracle Applications privilege level
#   'Public'.
#
GWYUID=APPLSYSPUB/PUB

#
# GUEST_USER_PWD
#   Applications User/Password of the Guest user.
#   The Guest Applications User is a public Applications user
#   with no responsibilities assigned.  If no such user exists,
#   create one in the 'Define User' form.  Do not use a user with
#   any active responsibilities. Note: This parameter is for
#   an applications user NOT an Oracle user. The Guest user
#   is seeded with 11i.

GUEST_USER_PWD=GUEST/GUEST

# THE FOLLOWING PARAMETERS ARE RELEVANT ONLY
# IF JDBC IS BEING USED. IF THEY ARE NOT SUPPLIED, DEFAULTS
# WILL BE USED.

# APPS_JDBC_DRIVER_TYPE
#   The type of JDBC driver being used. If no value is supplied,
#   the thick (OCI) driver will be used. Give a value of THIN
#   or THICK depending on the type of JDBC driver to be used.
#   For a detailed discussion on the THIN vs the THICK driver,
#   refer to the JDBC documentation. For Release 11i , this
#   should be set to a value of THIN.


APPS_JDBC_DRIVER_TYPE=THIN

# DB_HOST
#   The host machine on which the database resides. This parameter
#   is required only if the THIN DRIVER is being used.

DB_HOST=host_name

# DB_PORT
#   The port of the host machine on which the database resides.
#   This is required only if the THIN driver is being used.

DB_PORT=port_number

# DB_NAME
# Database instance name.
# This is required only if the THIN driver is being used.
# If no value is provided, the TWO_TASK is used.

# DB_NAME=db_name

• How it should be.

[applmgr@ip-10-10-1-101 log]$ cat $FND_SECURE/<DB_NAME>.dbc
#DB Settings
#Tue Sep 27 00:37:29 EDT 2016
DB_PORT=1521
JDBC\:processEscapes=true
TWO_TASK=DBgood
FND_JDBC_BUFFER_MAX=5
APPL_SERVER_ID=3D76C3A5102CEBE5E05000000000595D11711723004218240902785269447308
FND_MAX_JDBC_CONNECTIONS=500
APPS_JDBC_URL=jdbc\:oracle\:thin\:@(DESCRIPTION\=(ADDRESS_LIST\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS\=(PROTOCOL\=tcp)(HOST\=gooddb.adop.com)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=DBgood)))
FNDNAM=APPS
DB_HOST=gooddb.adop.com
GUEST_USER_PWD=GUEST/ORACLE
JDBC\:oracle.jdbc.maxCachedBufferSize=358400
FND_JDBC_STMT_CACHE_SIZE=100
APPS_JDBC_DRIVER_TYPE=THIN
FND_JDBC_BUFFER_MIN=1
FND_JDBC_BUFFER_DECAY_INTERVAL=300
GWYUID=APPLSYSPUB/PUB

Resolution or Known Fix

• Ensure that all ports that are being use by Oracle EBS application/database are open with each other servers.
• After the changes above. Reboot the hosts. Run adcfgclone.pl again.