𝐎𝐫𝐚𝐜𝐥𝐞 𝐄𝐁𝐒 𝐑𝟏𝟐.𝟐 ( 𝐄-𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐒𝐮𝐢𝐭𝐞 ) 𝐒𝐭𝐞𝐩 𝐛𝐲 𝐒𝐭𝐞𝐩 𝐂𝐥𝐨𝐧𝐢𝐧𝐠

 

Step 1:  Run Pre-Clone on the Source Apps Tier and DB Tier Application Preclone $ /apdata/erp/fs2/inst/apps/UAT_vm3uat/admin/scripts/adpreclone.pl appsTier pwd=apps Make tar file : $  tar -zcPf /apdata/Binary_BKP/apps.tar.gz /apdata/erp/fs2/EBSapps Database Preclone $ /dbuat/erp/12.1.0/appsutil/scripts/UAT_vm4db/adpreclone.pl dbTier pwd=apps Make tar file: $ tar --exclude='/dbuat/erp/12.1.0/admin' -cvf /dbuat/archbackup/Binary/UAT_db.tar.gz /dbuat/erp/12.1.0/

Step 2:  Take Full RMAN Backup (Include current control file & Archive log) at Source Server   Step 3:  Copy the Application Tier binary tar file from Source to Target. Step 4:  Copy the Database binary tar file & RMAN backup from Source to Target.

Step 5: Now, Prepare file system at target server Create the following directories in Target DB server             mkdir –p /dbdev/erp/12.1.0             mkdir –p /dbdev/erp/data             chown -Rf  oradev:dba  /dbdev/erp/             chmod -Rf 775 /dbdev/erp/              ***Here ,              RDBMS_ORACLE_HOME=/dbdev/erp/12.1.0              ORACLE BASE=/dbdev/erp/              DATA_TOP Directory=/dbdev/erp/data   ·         Create the following directories in Target EBS Application server              mkdir –p /apdata/erp/fs2/EBSapps  (Run File system)             mkdir –p /apdata/erp/fs1/   (Patch File system)             chown -Rf  appldev:dba  /apdata/erp/             chmod  -Rf 775 /apdata/erp/   ·         Untar DB binary and copy to target file system Ø  tar –xvf  UAT_db.tar.gz Ø  cp –rf  /dbuat/erp/12.1.0/* /dbdev/erp/12.1.0   ·         Untar Application binary and copy to target file system Ø   tar –xvf  apps.tar.gz Ø  cp –rf   /apdata/erp/fs2/EBSapps/* /apdata/erp/fs2/EBSapps/

Step 6: Configure the Oracle home on Target Database Server   [oradev@vm4db bin]$ perl adcfgclone.pl dbTechStack                        Copyright (c) 2002, 2015 Oracle Corporation                         Redwood Shores, California, USA                         Oracle E-Business Suite Rapid Clone                                  Version 12.2                       adcfgclone Version 120.63.12020000.60   Enter the APPS password :   Running: Context clone...   Log file located at /dbdev/erp/12.1.0/appsutil/clone/bin/CloneContext_0405185655.log   Provide the values required for creation of the new Database Context file.   Target System Hostname (virtual or normal) [vm4db] : vm4db.alam.com   Target Instance is RAC (y/n) [n] : n   Target System Database SID : DEV   Target System Base Directory : /dbdev/erp/   Role separation is supported y/n [n] ? : n   Target System utl_file_dir Directory List : /tmp   Number of DATA_TOP's on the Target System [1] :   Target System DATA_TOP Directory 1 [/dbdev/erp/data] :   Target System RDBMS ORACLE_HOME Directory [/dbdev/erp/12.1.0] :   Do you want to preserve the Display [vm4db:0.0] (y/n)  : n   Target System Display [vm4db:0.0] :   Target System Port Pool [0-99] : 20

Step 7: Start the database in nomount mode. Before starting check the pfile and make sure all the paths are pointing as per target server directory structure.   Add below entry in InitDEV.ora (files are to be restored to a different location):   *.db_file_name_convert=’<source_path>’,’<target_path>’ *.db_file_name_convert='/dbuat/erp/data/','/dbdev/erp/data/'    *.log_file_name_convert=’<source_path>’,’<target_path>’ *.log_file_name_convert='/dbuat/erp/data/','/dbdev/erp/data/' SQL> startup nomount pfile='initDEV.ora'; SQL> create spfile from pfile='initDEV.ora'; SQL> shu immediate; SQL> startup nomount;   Step 8. Rman backup Restoration at target DB server   $ rman auxiliary / log=rman_output_060421.txt Recovery Manager: Release 12.1.0.2.0- Production on Tue Apr 05 18:10:49 2021 Copyright (c) 1991, 2014, Oracle and/or its affiliates.  All rights reserved. connected to target database: uattest (not mounted)   RMAN> run{ allocate auxiliary channel C1 DEVICE TYPE DISK; allocate auxiliary channel C2 DEVICE TYPE DISK; allocate auxiliary channel C3 DEVICE TYPE DISK; allocate auxiliary channel C4 DEVICE TYPE DISK; allocate auxiliary channel C5 DEVICE TYPE DISK; allocate auxiliary channel C6 DEVICE TYPE DISK; allocate auxiliary channel C7 DEVICE TYPE DISK; allocate auxiliary channel C8 DEVICE TYPE DISK; duplicate database to 'DEV' backup location '/dbuat/BACKUP/rman05042021_BKP/databkp' nofilenamecheck; }

v   Change database to Noarchivelog mode             SQL> shut immediate;             SQL> startup mount;             SQL> alter database noarchivelog;             SQL> alter database open;   v  Now, login to application user.          $ sqlplus apps/apps  [Use Source apps user password] Run the below command to remove the Source Instance entries.           SQL>  EXEC FND_CONC_CLONE.SETUP_CLEAN;           SQL> commit;   v  Run Autoconfig on DBTier:-          $ cd /dbdev/erp/12.1.0/appsutil/scripts/DEV_vm4db           [oradev@vm4db DEV_vm4db]$  adautocfg.sh           Enter the APPS user password:

Step 9. Now login to application server, run adcfgclone on appstier. #[RUN FILE SYSTEM] $ cd /apdata/erp/fs2/EBSapps/comn/clone/bin [appldev@vm2dev bin]$  perl adcfgclone.pl appsTier                        Copyright (c) 2002, 2015 Oracle Corporation                         Redwood Shores, California, USA                         Oracle E-Business Suite Rapid Clone                                  Version 12.2                       adcfgclone Version 120.63.12020000.60                 ***********************************************************                 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 /apdata/erp/fs2/EBSapps/comn/clone/bin/CloneContext_0406034543.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) [vm2dev] : vm2dev.alam.com   Target System Database SID : DEV   Target System Database Server Node [vm2dev] : vm4db.alam.com   Target System Base Directory : /apdata/erp/   Target System Base Directory set to /apdata/erp   Target System Current File System Base set to /apdata/erp/fs2   Target System Other File System Base set to /apdata/erp/fs1   Target System Fusion Middleware Home set to /apdata/erp/fs2/FMW_Home   Target System Web Oracle Home set to /apdata/erp/fs2/FMW_Home/webtier   Target System Appl TOP set to /apdata/erp/fs2/EBSapps/appl   Target System COMMON TOP set to /apdata/erp/fs2/EBSapps/comn   Target System Instance Home Directory [/apdata/erp] :   Target System Instance Top set to /apdata/erp/fs2/inst/apps/DEV_vm2dev   Do you want to preserve the Display [vm3uat:0.0] (y/n)  : n   Target System Display [vm2dev:0.0] :   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] : 20   Checking the port pool 20 done: Port Pool 20 is free Report file located at /apdata/erp/fs2/inst/apps/DEV_vm2dev/admin/out/portpool.lst   UTL_FILE_DIR on database tier consists of the following directories.   1. /usr/tmp 2. /tmp 3. /dbdev/erp/12.1.0/appsutil/outbound/DEV_vm4db 4. /usr/tmp Choose a value which will be set as APPLPTMP value on the target node [1] :   Step 10:  (i) Start the Application tier.                  $ cd $ADMIN_SCRIPTS_HOME                  $ sh adstrtal.sh apps/<apps-password>                  (ii)Run adpreclone on TARGET RUN File System                  $ /apdata/erp/fs2/inst/apps/UAT_vm3uat/admin/scripts/adpreclone.pl appsTier pwd=apps                (iii) Shutdown application on TARGET RUN File System                  $ cd $ADMIN_SCRIPTS_HOME                  $ sh adstpall.sh apps/<apps-password>                 (iv) Copy Target RUN File System to Target Patch File System                   $ cp -rf  /apdata/erp/fs2/* /apdata/erp/fs1/

v Patch Edition File System cloning

Step 11:   (i) UNSET the application Enviroment. Previously we have executed env.                  (ii) Before we run adcfgclone.pl dont run any env’s                     Now, Directly go to /apdata/erp/fs1/EBSapps/comn/clone/bin/ and execute adcfgclone.pl [appldev@vm2dev bin]$ perl adcfgclone.pl appsTier                        Copyright (c) 2002, 2015 Oracle Corporation                         Redwood Shores, California, USA                           Oracle E-Business Suite Rapid Clone                                    Version 12.2                         adcfgclone Version 120.63.12020000.60                   ***********************************************************                 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 /apdata/erp/fs1/EBSapps/comn/clone/bin/CloneContext_0406115635.log   Target System File Edition type [run] : patch   Enter the full path of Run File System Context file : /apdata/erp/fs2/inst/apps/DEV_vm2dev/appl/admin/DEV_vm2dev.xml   Provide the values required for creation of the new APPL_TOP Context file.   Target System Fusion Middleware Home set to /apdata/erp/fs1/FMW_Home   Target System Web Oracle Home set to /apdata/erp/fs1/FMW_Home/webtier   Target System Appl TOP set to /apdata/erp/fs1/EBSapps/appl   Target System COMMON TOP set to /apdata/erp/fs1/EBSapps/comn   Target System Instance Top set to /apdata/erp/fs1/inst/apps/DEV_vm2dev   Target System Port Pool [0-99] : 21

v POST CLONING STEPS

Update the Sitename & Date: SQL>DECLARE stat boolean; BEGIN dbms_output.disable; dbms_output.enable(100000); stat := FND_PROFILE.SAVE('SITENAME', 'DEV(Data Till 05-APR-21)', 'SITE'); IF stat THEN dbms_output.put_line( 'Stat = TRUE - profile updated' ); ELSE dbms_output.put_line( 'Stat = FALSE - profile NOT updated' ); END IF; commit; END; /   Change the profile name: SQL> DECLARE stat boolean; BEGIN dbms_output.disable; dbms_output.enable(100000); stat := FND_PROFILE.SAVE('FS_SVC_PREFIX', 'FNDFS_DEV_', 'SITE'); IF stat THEN dbms_output.put_line( 'Stat = TRUE - profile updated' ); ELSE dbms_output.put_line( 'Stat = FALSE - profile NOT updated' ); END IF; commit; END; /    To change color of the site: SQL>DECLARE stat boolean; BEGIN dbms_output.disable; dbms_output.enable(100000); stat := FND_PROFILE.SAVE('FND_COLOR_SCHEME', 'BLUE', 'SITE'); IF stat THEN dbms_output.put_line( 'Stat = TRUE - profile updated' ); ELSE dbms_output.put_line( 'Stat = FALSE - profile NOT updated' ); END IF; commit; END; /   Clear the schedule concurrent program: SQL> UPDATE  fnd_concurrent_requests    SET phase_code = 'C', status_code = 'X'  WHERE phase_code = 'P'        AND request_id NOT IN               (SELECT request_id                  FROM fnd_conc_req_summary_v                 WHERE program IN                          ('WIP Move Transaction Manager',                           'Process transaction interface',                           'Manager: Lot Move Transactions',                         'Workflow Background Process',                           'Cost Manager')                       AND (phase_code = 'P' OR phase_code = 'R'));       SQL> UPDATE  fnd_concurrent_requests    SET phase_code = 'C', status_code = 'X'  WHERE phase_code = 'R' AND status_code = 'R'        AND request_id NOT IN               (SELECT request_id                  FROM fnd_conc_req_summary_v                 WHERE program IN                          ('WIP Move Transaction Manager',                           'Process transaction interface',                           'Manager: Lot Move Transactions',                         'Workflow Background Process',                           'Cost Manager')                       AND (phase_code = 'P' OR phase_code = 'R'));   SQL>  COMMIT;     v Run autoconfig on dbtier and then on appstier.   DB tier:            $ cd $ORACLE_HOME/appsutil/scripts/DEV_vm4db           $  adautocfg.sh           Apps tier:           $  cd $ADMIN_SCRIPTS_HOME           $  adautocfg.sh     v Start the Application tier. Check OPMN status and from front end.            $  cd $ADMIN_SCRIPTS_HOME            $ ./adstrtal.sh  apps/apps              Enter the weblogic user password: ~~~~~~~~~~~~~~~~~~EBS R12.2 Cloning is completed!!~~~~~~~~~~~~~~~~~~