There are different options available to Clone Oracle Applications and Database.
Before start to apps cloning, we must know the basic steps and options which are available in Oracle EBS Applications.Cloning is the process to refresh the data from Source to Target i.e. PROD to DEV,TEST,UAT ..etc.
On source system :
We have to prepare the source system to make the refresh successful.
1. Perl adpreclone dbTier .
If new Rapid Clone or Autoconfig updates are applied to the system, adpreclone.pl must be executed again on the dbTier and on the appsTier in order to apply the new files into the clone directory structures that will be used during the cloning configuration stage.
When you run this commnad adpreclone.pl dbTier . This will run in two steps
1.1 Techstack
1.2 Database.
1.1 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.
1.2 Prepare database for cloning:
This includes creating database 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
2.perl adpreclone.pl 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
3.Adfgclone.pl dbTier
1. It Creates the context file
2. Register the ORACLE_HOME
3. Relink the ORACLE_HOME
4. Configure the ORACLE_HOME
5. Recreate the control files
6. Start SQL*Net Listener
4.Adcfgclone.pl appsTier
1. It Creates the context file.
2. Register the ORACLE_HOME
3. Relink the ORACLE_HOME
4. It creates the INST_TOP
5. Configure APPL_TOP
6. Start APPS Process
5.adcfgclone.pl dbTechStack
1. Create the context file
2. Register ORACLE_HOME
3. Configure the ORACLE_HOME
4. Start SQL*Net Listener
6. adcfgclone.pl dbconfig
This scripts configure the database
7. adcfgclone.pl database
1. Configure the ORACLE_HOME
2. Recreate the control files
3. Start SQL*Net Listener
8. adcfgclone.pl atTechStack
1. It Creates the context file
2. Register the ORACLE_HOME
3. Relink the ORACLE_HOME
4. Configure the ORACLE_HOME
5. Create INST_TOP
6. Start SQL*Net Listener
9. adcfgclone.pl appltop
1. Configure the apple top
2. Create INST_T3. OP
3. Start SQL*Net Listener
