Autoconfig will not be enabled on the database tier when
Database tier not created by Rapid Install
Cross platform migration of the database tier
Upgrading to 11g Database
Upgrading the database tier from Applications 11i to E-Business Suite Release 12
Confirm if latest autoconfig patch is applied on apps Tier
If your instance is on 12.0.X and is not upgraded to 10.1.3.3 AS patchset, Patch 4585869 needs to be applied in order to use the adbldxml utility.
Copy AutoConfig to the RDBMS ORACLE_HOME
Log in to the APPL_TOP environment (source the environment file)
Create appsutil.zip file
This will create appsutil.zip in INST_TOP/admin/out
On the database tier (as the ORACLE user)
Copy or FTP the appsutil.zip file to the RDBMS ORACLE_HOME
cd RDBMS ORACLE_HOME
unzip -o appsutil.zip
Run AutoConfig on the database tier and then on the applications tier
Download Jre from
Install JRE on the Database tier
under ORACLE_HOME/appsutil directory created in above step.
Jre is required by adbldxml.pl to build the context_name.xml for database
Install the downloaded latest update of JRE 5.0
As the apps tier jdk is on jdk 5 version ,
I decided to install the same version on db Tier
and later as part of the JDk upgrade I willl upgrade both the tiers to JDK 6 as required for the APPS upgrade.
I have tried copying the jre directory from 10g Oracle_home which worked fine.
Generate the Database Context File
This builds the context_name.env file required by Apps Database under RDBMS_ORACLE_HOME.
$ tnsping SID
from apps tier to confirm the connectivity of database.