Part 4: Copy Database Tier Node
For copying the database tier node from source to target database you can always follow the easiest approach of copying the database files from source to target database by first shutting down the source database system. But not all DBAs have the luxury of taking down their Production database at will to refresh a non-production database.
4.1 Stop Target Database – If Required
Login to the target Database node as the oracle software user.
$ sqlplus / as sysdba
SQL> shutdown immediate
4.2 Cleanup Target Database File
Delete all target data files.
Use a simple rm –rf command to delete these database files
4.3 Restore Your Production Database to the Target Database Server Using the Method of Your Choice
Part 5: Configure Target Database System
Log on to the Target System as the oracle user and enter the following commands to configure the adcfgclone dbTechStack
$ cd [RDBMS ORACLE_HOME]/appsutil/clone/bin
$ perl adcfgclone.pl dbTechStack
The log file is created in the <RDBMS_ORACLE_HOME>/appsutil/log/<CONTEXT_NAME> directory.
Answer the adcfgclone script questions and allow the script to run to completion.
As the APPS user, run the following command to de-register the current configuration:
Login from the target database node as the APPS user:
$ sqlplus apps/<PASSWORD>
SQL> exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
On the target database node from the $ORACLE_HOME/appsutil/bin directory, execute AutoConfig on the database tier by running the adconfig.pl script.
$ cd $ORACLE_HOME/appsutil/bin
$ perl adconfig.pl dbTier
Check the AutoConfig log for any errors.
Also check the CONTEXT_FILE that was generated under $ORACLE_HOME/appsutil
Part 6: Configure Target Application System
Configuring the target system changes instance settings from the source settings to the target settings that match the target hostname, target instance name, SID, paths and ports.
- At the prompt Do you want to add a node (yes/no), enter the value no.
- At the prompt: Target System Base Directory, enter the location of the base directory. For example: /u01/oracle/VIS.
- Provide the new port pools for the Run Edition File System and the Patch Edition File System.
- When asked the question Do you want to startup the Application Services for <TWO_TASK>? (y/n) you should answer y if you do not need to perform any further actions and n if there are other pending actions that need the Application services to be down.
Login to the Application node as the OS Apps user.
$ cd $COMMON_TOP/clone/bin
$ cd $ORACLE_HOME/<TARGET_DB_SID>/fs1/EBSapps/comn/
$ perl adcfgclone.pl appsTier
**This step requires the Apps User password AND the Weblogic Server Admin password
perl adcfgclone.pl appsTier
Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
adcfgclone Version 120.63.12020000.56
In AD-TXK Delta 7, we recommend you clone the run and patch file systems in a single operation using the ‘dualfs’ option.
Separate cloning of the run and patch file systems will be deprecated
Enter the APPS password :
Enter the Weblogic AdminServer password :
Do you want to add a node (yes/no) [no] :
Running: Context clone…
Log file located at $ORACLE_HOME/<TARGET_DB_SID>/fs1/EBSapps/comn/clone/bin/CloneContext_1230123711.log
Target System File Edition type [run] :
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [apps1] :
Target System Database SID : <TARGET_DB_SID>
Target System Database Server Node [apps1] : data1
Target System Database Domain Name [dg.local] :
Target System Base Directory : $ORACLE_HOME/<TARGET_DB_SID>
Target System Base Directory set to $ORACLE_HOME/<TARGET_DB_SID>
Target System Current File System Base set to $ORACLE_HOME/<TARGET_DB_SID>/fs1
Target System Other File System Base set to $ORACLE_HOME/<TARGET_DB_SID>/fs2
Target System Fusion Middleware Home set to $ORACLE_HOME/<TARGET_DB_SID>/fs1/FMW_Home
Target System Web Oracle Home set to $ORACLE_HOME/<TARGET_DB_SID>/fs1/FMW_Home/webtier
Target System Appl TOP set to $ORACLE_HOME/<TARGET_DB_SID>/fs1/EBSapps/appl
Target System COMMON TOP set to $ORACLE_HOME/<TARGET_DB_SID>/fs1/EBSapps/comn
Target System Instance Home Directory [$ORACLE_HOME/<TARGET_DB_SID>] :
Target System Instance Top set to $ORACLE_HOME/<TARGET_DB_SID>/fs1/inst/apps/<TARGET_DB_SID>_apps1
Do you want to preserve the Display [<Target_App_Server>:0.0] (y/n) : n
Target System Display [apps1:0.0] : :1
Target System Root Service [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [disabled] :
Do you want the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 0
Checking the port pool 0
done: Port Pool 0 is free
Report file located at $ORACLE_HOME/<TARGET_DB_SID>/fs1/inst/apps/<TARGET_DB_SID>_apps1/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
Choose a value which will be set as APPLPTMP value on the target node  : 1