Some of the most commonly modified AutoConfig managed files
Database Tier
Database $ORACLE_HOME
$ORACLE_HOME/PROD.env
$ORACLE_HOME/PROD_appshost.env
$ORACLE_HOME/dbs/initPROD.ora
$TNS_ADMIN/listener.ora
$TNS_ADMIN/tnsnames.ora
Applications Tier
8.0.6 Client $ORACLE_HOME
$ORACLE_HOME/PROD.env
$ORACLE_HOME/PROD_appshost.env
$TNS_ADMIN/listener.ora
$TNS_ADMIN/tnsnames.ora
Oracle iAS ${IAS_ORACLE_HOME}
$ORACLE_HOME/PROD.env
$ORACLE_HOME/PROD_appshost.env
$TNS_ADMIN/listener.ora
$TNS_ADMIN/tnsnames.ora
$ORACLE_HOME/Apache/Apache/conf/httpd.conf
$ORACLE_HOME/Apache/Apache/conf/httpd_pls.conf
$ORACLE_HOME/Apache/Jserv/etc/formservlet.ini
$ORACLE_HOME/Apache/Jserv/etc/jserv.properties
$ORACLE_HOME/Apache/Jserv/etc/jserv.conf
Oracle Applications $APPL_TOP
$APPL_TOP/admin/APPSORA.env
$APPL_TOP/admin/APPSPROD_appshost.env
$APPL_TOP/admin/PROD.env
$APPL_TOP/admin/PROD_appshost.env
++++++++++++++++++++++++++++++++++++++
Details of Adpreclone and Adcfgclone
++++++++++++++++++++++++++++++++++++++
(Interview Ques: What happens internally when you run adpreclone and adcfgclone)
I am covering the Internal Cloning Process which you will not get eaily on the net. Generally you find the steps for cloning like run adpreclone on apps and db tier then copy the file sytem to Target then run adcfgclone on apps tier and db Tier.
What happens when you run adpreclone and adcfgclone. The below steps give you better understanding and enhance your troubleshooting skills.
When you run this commnad adpreclone.pl dbTier . This will run in two steps Techstack and database.
Techstack:
It will create following directories in the ORACLE_HOME/appsutil/clone
Jlib, db, data where “Jlib” relates to libraries “db” will contain the techstack information, “data” will contain the information related to datafiles and required for cloning.
Creates driver files at ORACLE_HOME/appsutil/driver/instconf.drv
Converts inventory from binary to xml, the xml file is located at $ORACLE_HOME/appsutil/clone/context/db/Sid_context.xml
Prepare database for cloning:
This includes creating datbase control file script and datafile location information file at
$ORACLE_HOME/appsutil/template
adcrdbclone.sql, dbfinfo.lst
Generates database creation driver file at ORACLE_HOME/appsutil/clone/data/driver
data.drv
Copy JDBC Libraries at ORACLE_HOME/appsutil/clone/jlib/classes12.jar and appsoui
When Running adpreclone appsTier
This will create stage directory at $COMMON_TOP/clone. This also run in two steps.
Techstack:
Creates template files for
Oracle_iAS_Home/appsutil/template
Oracle_806_Home/appsutil/template
Creates Techstack driver files for
IAS_ORACLE_HOME/appsutil/driver/instconf.drv
806_ORACLE_HOME/appsutil/driver/instconf.drv
APPL_TOP preparation:
-It will create application top driver file$COMMON_TOP/clone/appl/driver/appl.drv
-Copy JDBC libraries$COMMON_TOP/clone/jlib/classes111.zip
Now Shutdown all the services of Application and database for Copy the file System to target location
Configuring the target system
Once it is done . Run as below adcfclone.pl for apps Tier and dbTier.
On database side:
cd $ORACLE_HOME/appsutils/clone/binperl adcfgclone.pl dbTier pwd=apps
This will use the templates and driver files those were created while running adpreclone.pl on source system and has been copied to target system.
Following scripts are run by adcfgclone.pl dbTier for configuring techstack
adchkutl.sh — This will check the system for ld, ar, cc, and make versions.
adclonectx.pl — This will clone the context file. This will ceate a new context file as per the details of this instance.
runInstallConfigDriver — located in $Oracle_Home/appsutil/driver/instconf.drv
Relinking $Oracle_Home/appsutil/install/adlnkoh.sh — This will relink ORACLE_HOME
For data on database side, following scripts are run
Driver file $Oracle_Home/appsutil/clone/context/data/driver/data.drv
Create database adcrdb.zip
Autoconfig is run
Control file creation adcrdbclone.sql
On Application Side:
COMMON_TOP/clone/bin/perl adcfgclone.pl appsTier pwd=apps
Following scripts are run by adcfgclone.pl
Creates context file for target adclonectx.pl
Run driver files
$ORACLE_HOME/appsutil/driver/instconf.drv
$IAS_ORACLE_HOME/appsutil/driver/instconf.drv
Relinking of Oracle Home$ORACLE_HOME/bin/adlnk806.sh$IAS_ORACLE_HOME/bin/adlnkiAS.sh
At the end it will run the driver file $COMMON_TOP/clone/appl/driver/appl.drv and then runs autoconfig.