This post discusses the process of step-by-step cloning with on-premise Oracle\u00ae; E-Business Suite® (EBS) R12.2 on a version 19c Database by using Recovery Manager (RMAN) Hot backup on Red Hat\u00ae; Enterprise Linux\u00ae; servers. These steps also apply to different operating systems.<\/p>\n
EBS Cloning<\/strong><\/p>\n To perform EBS cloning, you need to complete the following high-level steps:<\/p>\n 1. Run a pre-clone utility on the source database and application nodes. Here are the steps in detail:<\/em><\/p>\n 1. Run pre-clone utility <\/strong><\/p>\n a. Run the following commands to source the pluggable database (PDB) environment file on cd $ORACLE_HOME b. Run the following commands on the application node:<\/p>\n EBSApps run (Source RUN FS) 2. Back up the CDB<\/strong><\/p>\n Back up the full CDB database with archives by using RMAN Hot backup and copy it to the a. Run the following commands to source the CDB environment file at $ORACLE_HOME:<\/p>\n cd $ORACLE_HOME b. Run the following commands to complete this step:<\/strong><\/p>\n run { BACKUP as compressed backupset FULL FILESPERSET 10 FORMAT ‘<Backup location>\/<SID>_bk_%s_%p_%t.bak’ DATABASE; After completing the backup, either move to the target location or Network File System (NFS) share the backup mount point to the target node to save time.<\/em><\/p>\n 3. Clean up<\/strong><\/p>\n Clean up the target database and application node.<\/p>\n Run the following steps on the database node<\/p>\n a. Take a backup of the following important configuration files and directories before – $CONTEXT\\_FILE b. Remove target OH and drop the database.<\/em><\/p>\n \nc. Remove contents of oraInventory<\/strong><\/p>\n Note that the UTL<\/strong> directories should not have symbolic links. If symbolic links exist, remove them and create a physical directory structure.<\/p>\n Run the following steps on the application node:<\/p>\n 4. Copy the binaries<\/strong><\/p>\n Perform the following steps to copy the source application binaries and database binaries a. On the database node, copy and transfer version 19.0.0(19c) binaries to the target database server.<\/p>\n b. On the application node, transfer only the EBSapps<\/strong> directory of RUN FS<\/strong> from the source to the target node under the target RUN FS<\/strong><\/p>\n 5. Configure $Oracle_Home<\/strong><\/p>\n Configure $Oracle_Home on the target database node.<\/p>\n Before running adcfgclone.pl<\/em> to configure $Oracle_Home, clean up the oraInventory <\/strong>directory. If you are doing cloning for the first time on a new server, then run only the following steps and provide values for all inputs. Perform the following steps:<\/p>\n a. Create the context file:<\/p>\n cd $ORACLE_HOME\/appsutil\/clone\/bin perl adcfgclone.pl dbTechStack <Full Path of CONTEXT_FILE><\/em><\/p>\n b. Create <\/em>listener.ora<\/strong> and <\/em>tnsnames.ora<\/strong><\/p>\n cd $ORACLE_HOME\/appsutil cd $ORACLE_HOME\/appsutil\/bin c. <\/em>If this is a repeated cloned instance, use the **CONTEXT_FILE** backup to configure the cd <RDBMS ORACLE_HOME>\/appsutil\/clone\/bin d. If this is a repeated cloned instance, revert the <\/em>dbs<\/strong> and TNS<\/strong> files so that all e. Start the listener.<\/p>\n After you configure $Oracle_Home, start the target database restore by using that backup that you took earlier:<\/p>\n a. Before restoring, check that the following parameters are correct in the target node.<\/p>\n – db\\_file\\_name\\_convert b. Start the target database in a `nomount` state and run the following RMAN command to restore the database:<\/p>\n Rman auxiliary \/ 7. <\/em>Target post-restore steps<\/p>\n sqlplus \/ as sysdba CON_ID CON_NAME OPEN MODE RESTRICTED b. Source the PDB env file and perform the following command to set the target perl $ORACLE_HOME\/appsutil\/bin\/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME\/appsutil\/log -mode=getUtlFileDir<\/em><\/p>\n c. <\/em>Run the following command to edit the \\<\/em><PDB Name\\>\\_utlfiledir.txt<\/strong> file under perl $ORACLE_HOME\/appsutil\/bin\/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME\/appsutil\/log -mode=setUtlFileDir<\/em><\/p>\n d. Run the following script for each path in <\/em>\\<PDB Name\\>\\_utlfiledir.txt<\/strong><\/p>\n perl $ORACLE_HOME\/appsutil\/bin\/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME\/appsutil\/log -mode=createDirObject<\/em><\/p>\n perl $ORACLE_HOME\/appsutil\/bin\/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME\/appsutil\/log -mode=syncUtlFileDir -skipautoconfig=yes<\/em><\/p>\n cd $ORACLE_HOME\/appsutil\/install\/$CONTEXT_NAME clean FND_NODE table<\/em><\/p>\n sqlplus apps\/<Source Apps password><\/em><\/p>\n EXEC FND_CONC_CLONE.SETUP_CLEAN;<\/em><\/p>\n Commit;<\/em><\/p>\n e. Use the following command to run adautocfg.sh<\/strong>:<\/em><\/p>\n cd <$ORACLE_HOME\/appsutil\/scripts\/$CONTEXT_NAME> 8. Configure the target application<\/strong><\/p>\n Configure the application on the target application node:<\/p>\n a. Before starting adcfgclone.pl<\/strong>, clean up the PATCH FS<\/strong>, FS_NE<\/strong>, and oraInventory<\/strong> directories.<\/p>\n b. Run the following commands to configure the application:<\/p>\n cd <COMMON_TOP>\/clone\/bin c. <\/em>Provide all the inputs here.<\/p>\n d. <\/em>If this is a repeated cloning instance, you can also use the backup of a CONTEXT_FILE. Run the following command:<\/p>\n perl .\/adcfgclone.pl appsTier <location of CONTEXT_FILE backup> dualfs<\/em><\/p>\n 9. Application post-clone steps<\/strong><\/p>\n Perform the post-clone steps on the Application node:<\/p>\n a. After you configure the application, change the apps, sysadmin, and custom schema password, if any, by using the FNDCPASS <\/em>command.<\/p>\n b. After changing the apps password, run Autoconfig<\/em> on the database node and the application node.<\/p>\n c. Perform other custom steps, if any, for cloned instances.<\/p>\n 10. Start the target application services<\/strong><\/p>\n You can now start all application services of the target clone instance and perform all sanity checks for the cloned instances.<\/p>\n Conclusion<\/strong><\/p>\n Using the preceding steps, you can clone or refresh the PROD instance to non-prod servers with version 19c databases with a multitenant architecture.<\/p>\n","protected":false},"excerpt":{"rendered":" Oracle EBS cloning with version 19c Database<\/p>\n","protected":false},"author":2,"featured_media":7124,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26266","content_type":"blog","created_by":"10130","authored_on":"2023-11-20T20:49:11+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Rackspace Technology Staff","seo_description":"Discover step-by-step cloning of Oracle E-Business Suite\u00ae (EBS) R12.2 on a 19c Database using RMAN Hot backup on Red Hat\u00ae Enterprise Linux servers.","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26266-insights_image-oracle-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Oracle","product":"","publisheddate":"2022-02-05T20:49:11","rxt_solutions":"Databases","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"Oracle EBS Cloning with 19c Database | Rackspace Technology","field_topics":"","field_slug":"oracle-ebs-cloning-with-version-19c-database","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7122","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/comments?post=7122"}],"version-history":[{"count":1,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7122\/revisions"}],"predecessor-version":[{"id":7123,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7122\/revisions\/7123"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media\/7124"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media?parent=7122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/categories?post=7122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/tags?post=7122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n2. Back up the full Container Database (CDB) database with archives by using RMAN Hot backup and copy it to the target node.
\n3. Clean up the target database and application node.
\n4. Copy the source application binaries and database binaries to the target node.
\n5. Configure $Oracle_Home on the target database node.
\n6. Restore and recover the databases.
\n7. Perform post-restore steps on the Target database node.
\n8. Configure the application on the target application node.
\n9. Perform post-clone steps on the application node.
\n10. Start the target application services.<\/p>\n
\n the database node at $ORACLE_HOME:<\/p>\n
\n . <PDB_NAME>_hostname.env
\n cd $ORACLE_HOME\/appsutil\/scripts\/$CONTEXT_NAME
\n perl adpreclone.pl dbTier<\/em><\/p>\n
\n cd $ADMIN_SCRIPTS_HOME
\n perl adpreclone.pl appsTier<\/em><\/p>\n
\ntarget node:<\/p>\n
\n . <CDB_NAME>_hostname.env
\n connect target \/<\/em><\/p>\n
\n allocate channel d1 type disk;
\n allocate channel d2 type disk;
\n allocate channel d3 type disk;
\n allocate channel d4 type disk;<\/em><\/p>\n
\n BACKUP as compressed backupset filesperset 10 FORMAT ‘<Backup location>\/<SID>_arch_%s_%p_%t.bak’ ARCHIVELOG ALL skip inaccessible;
\n BACKUP FORMAT ‘<Backup location>\/<SID>_cntrl_%s_%p_%t.bak’ CURRENT CONTROLFILE;
\n
\n RELEASE CHANNEL d1;
\n RELEASE CHANNEL d2;
\n RELEASE CHANNEL d3;
\n RELEASE CHANNEL d4;
\n }<\/em><\/p>\n
\n you clean them up:<\/p>\n
\n– environment files
\n– dbs
\n– $TNS\\_ADMIN directories.<\/em><\/p>\n
\nto the target node.<\/p>\n
\n perl adclonectx.pl contextfile=<Source database context file> template=$ORACLE_HOME\/appsutil\/template\/adxdbctx.tmp [pairsfile=<Pairs file Path>]<\/em><\/p>\n
\n .\/txkSetCfgCDB.env -dboraclehome=<ORACLE_HOME><\/em><\/p>\n
\n perl txkGenCDBTnsAdmin.pl -dboraclehome=$ORACLE_HOME -cdbname=<target CDB NAME> \\
\n -cdbsid=<SID> -dbport=<Target DB port> -outdir=$ORACLE_HOME\/appsutil\/log \\
\n -israc=<yes\/no> [-virtualhostname=<virtual hostname>]<\/em><\/p>\n
\n target database binaries:<\/p>\n
\n perl adcfgclone.pl dbTechStack <Full Path of CONTEXT_FILE backup location><\/em><\/p>\n
\n configuration files and init parameters are intact after configuration.<\/em><\/p>\n
\n – log\\_file\\_name\\_convert<\/p>\n
\n run
\n {
\n allocate auxiliary channel d1 device type disk;
\n allocate auxiliary channel d2 device type disk;
\n allocate auxiliary channel d3 device type disk;
\n duplicate database to ‘<CDB NAME>’ backup location ‘<RMAN backup location>’ nofilenamecheck;
\n release channel d1;
\n release channel d2;
\n release channel d3;
\n }<\/em><\/p>\n
\n SQL> alter pluggable database “<Source PDB Name>” close;
\n SQL> alter pluggable database “<Source PDB Name>” unplug into ‘<ORACLE_HOME>\/dbs\/<Source PDB Name>_PDBDesc.xml’;
\n SQL> drop pluggable database “<Source PDB Name>”;
\n SQL> create pluggable database “<Target PDB Name>” using <ORACLE_HOME>\/dbs\/<PDB Name>_PDBDesc.xml<\/em> NOCOPY SERVICE_NAME_CONVERT=(ebs_<Source PDB Name><\/em>,ebs_<Target PDB Name>,<Source PDB Name>_ebs_patch<\/em>,<Target PDB Name>_ebs_patch);<\/em>
\n SQL> alter pluggable database “<Target PDB Name>” open read write;
\n SQL> alter pluggable database all save state instances=all;
\n SQL> sho pdbs<\/p>\n
\n —— —————————— ———- ———-
\n 2 PDB$SEED READ ONLY NO
\n 4 <PDB Name> READ WRITE NO<\/p>\n
\n UTL\\_FILE\\_DIR<\/strong> values in Oracle Database:<\/p>\n
\n <\/em>Oracle_Home\/dbs<\/strong> and change the UTL Path accordingly<\/p>\n
\n sqlplus \/ as sysdba @adupdlib.sql <libext><\/em><\/p>\n
\n sh adautocfg.sh<\/em><\/p>\n
\n export TIMEDPROCESS_TIMEOUT=-1
\n export T2P_JAVA_OPTIONS=”-Djava.io.tmpdir=<Temp directory location>”
\n perl .\/adcfgclone.pl appsTier dualfs<\/em><\/p>\n