Oracle EBS R12.2 Cloning

1.Source Database: DEV instance

/dev/backup/01AUG21/ORACLE_HOME_01AUG21.tar.gz

/dev/backup/01AUG21/DB_BACKUP_01AUG21.tar.gz

2.Backup move to Target database:

Backup move to Target database(TEST instance)

I.ORACLE_HOME Move to Test server

scp -P ORACLE_HOME.tar.gz 172.165.12.17:/testebsdb/TEST/db/tect_st/

II. Data Backup move to Target Instance (TEST)

scp -P DB_BACKUP_01AUG21.tar.gz 172.165.12.17:/testebsdb/TEST/db/apps_st/

3.Target Database: TEST Instance

1. untar the ORACLE_HOME Backup

cd /testebsdb/TEST/db/tect_st/

[oracle@ebs-db tech_st] tar -xvzf ORACLE_HOME.tar.gz

2. untar the DB backup

cd /testebsdb/TEST/db/apps_st/

[oracle@ebs-db apps_st] tar -xvzf DB_BACKUP_01AUG21.tar.gz

4.Export the PERL5LIB and PATH:

cd /testebsdb/TEST/db/tech_st/12.1.0/

export PERL5LIB=/testebsdb/TEST/db/tech_st/12.1.0/perl/lib/5.14.1:/testebsdb/TEST/db/tech_st/12.1.0/perl/lib/site_perl/5.14.1

export PATH=/testebsdb/TEST/db/tech_st/12.1.0/perl/bin:/testebsdb/TEST/db/tech_st/12.1.0/perl/bin:$PATH

============================================================

racle@ebs-db appsutil]$ ls

admin clone DEV_devebsdb.xml etcc install jre media outbound scripts temp txkSetCfgCDB.cmd

bin conf_DEV.txt driver html java log out perl sql template txkSetCfgCDB.env

[oracle@ebs-db appsutil]$ cd clone/

[oracle@ebs-db clone]$ ls

bin context data dbts html jlib jre oui

[oracle@ebs-db clone]$ cd bin/

[oracle@ebs-db bin]$ pwd

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin

[oracle@ebs-db bin]$ ls

adcfgclone.pl adchkutl.sh adclonectx.pl adclone.pl

[oracle@ebs-db bin]$ export PERL5LIB=/testebsdb/TEST/db/tech_st/12.1.0/perl/lib/5.14.1:/testebsdb/TEST/db/tech_st/12.1.0/perl/lib/site_perl/5.14.1

[oracle@ebs-db bin]$ export PATH=/testebsdb/TEST/db/tech_st/12.1.0/perl/bin:/testebsdb/TEST/db/tech_st/12.1.0/perl/bin:$PATH

[oracle@ebs-db bin]$ ls

adcfgclone.pl adchkutl.sh adclonectx.pl adclone.pl

5.Database Cloning :

[oracle@ebs-db bin]$ perl adcfgclone.pl dbTier

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.65

Enter the APPS password :

Running: Context clone...

Log file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_0409114402.log

Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [ebs-db] :

Target System Base Directory : /testebsdb/TEST

Target Instance is RAC (y/n) [n] : n

Target System Database SID : TEST

Role separation is supported y/n [n] ? : n

Target System utl_file_dir Directory List : /testebsdb/tmp

Number of DATA_TOP's on the Target System [1] :

Target System DATA_TOP Directory 1 [/testebsdb/TEST/data] : /testebsdb/TEST/db/apps_st/data

Target System RDBMS ORACLE_HOME Directory [/testebsdb/TEST/12.1.0] : /testebsdb/TEST/db/tech_st/12.1.0

Do you want to preserve the Display [null] (y/n) : n

Target System Display [ebs-db:0.0] : ebs-db:1.0

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] : 10

Checking the port pool 10

done: Port Pool 10 is free

Report file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/temp/portpool.lst

The new database context file has been created :

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

Check Clone Context logfile /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_0409114402.log for details.

Running Rapid Clone with command:

Running:

perl /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/adclone.pl java=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre mode=apply stage=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml showProgress contextValidated=true

Beginning database tier Apply - Sun Aug 1 11:47:51 2021

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/testebsdb/TEST/db/tech_st/12.1.0/oui -classpath /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/xmlparserv2.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/java:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/ewt3.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/share.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/srvm.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTier -e /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml -stage /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone -showProgress

APPS Password : Log file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/ApplyDBTier_04091147.log

- 15% completed

Completed Apply...

Sun Aug 1 11:51:38 2021

Starting database listener for TEST:

Running:

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/scripts/TEST_ebs-db/addlnctl.sh start TEST

Logfile: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process TEST ...

Listener TEST has already been started.

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/addlnctl.txt for more information ...

Do you want to change the password for all EBS Schemas? (y/n) [n]) : n

Do you want to change the password for sysadmin user? (y/n) [n]) : n

Do you want to change the apps password? (y/n) [n]) : n

Do you want to change the sys and system passwords? (y/n) [n]) : n

Running ETCC to check status of DB technology patches...

+===============================================================+

| Oracle E-Business Suite Release 12.2 |

| Database EBS Technology Codelevel Checker |

+===============================================================+

Validating context file: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

Using context file from command line argument:

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

Starting Database EBS Technology Codelevel Checker, Version 120.83

Sun Aug 1 11:52:47 IST 2021

Log file for this session : /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/log/checkDBpatch_26599.log

Identifying database release.

Database release set to 12.1.0.2.

Connecting to database.

Database connection successful.

Database TEST is in READ WRITE mode.

Identifying APPS and APPLSYS schema names.

- APPS schema : APPS

- APPLSYS schema : APPLSYS

Checking for DB-ETCC results table.

Table to store DB-ETCC results already exists in the database.

Checking if InMemory option is enabled.

InMemory option is not enabled in the database.

Bugfix file /testebsdb/TEST/db/tech_st/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.58

This file will be used for identifying missing bugfixes.

Mapping file /testebsdb/TEST/db/tech_st/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.33

This file will be used for mapping bugfixes to patches.

Identified RDBMS DST version 18.

Checking Bugfix XML file for 12.1.0.2_PSU

Obtained list of bugfixes to be applied and the list to be rolled back.

Now checking Database ORACLE_HOME.

The opatch utility is version 12.2.0.1.24.

DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for 12.1.0.2.210119

All the required one-off bugfixes are present in Database ORACLE_HOME.

Stored Technology Codelevel Checker results in the database TEST successfully.

Finished checking fixes for Oracle Database: Sun Aug 1 11:52:55 IST 2021

Log file for this session: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/log/checkDBpatch_26599.log

===============================================================================

Source the Database Environment file

[oracle@ebs-db 12.1.0]$ . TEST_ebs-db.env

[oracle@ebs-db 12.1.0]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Aug 1 11:53:21 2021

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

TEST READ WRITE

SQL> show SGA;

Total System Global Area 2147483648 bytes

Fixed Size 2926472 bytes

Variable Size 469764216 bytes

Database Buffers 1660944384 bytes

Redo Buffers 13848576 bytes

SQL>

SQL> Exit

oracle@ebs-db 12.1.0]$ . TEST_ebs-db.env

[oracle@ebs-db 12.1.0]$ cd appsutil

[oracle@ebs-db appsutil]$ ls

admin clone etcc install jre media outbound scripts sql template txkSetCfgCDB.env

bin driver html java log out perl TEST_ebs-db.xml temp txkSetCfgCDB.cmd

[oracle@ebs-db appsutil]$ cd install/

[oracle@ebs-db install]$ ls

adlnkoh.sh TEST_ebs-db

[oracle@ebs-db install]$ cd TEST_ebs-db/

[oracle@ebs-db TEST_ebs-db]$ ls

adcctclean.sql adcrdbrdlg.sh addbperms.sh adsvdb.sh afdbprf.sql txkEBSWrapper.pl

adclobconv.sql adcrdb.sh addbprf.sh adsvdcnv.sh afmkinit.sh

adclobtmp.sql adcrobj.sh addbprf.sql adsvdlsn.sh txkConfigDbOcm.pl

adcmclean.sql adcrobj.sql addbupdgsm.sql adupdlib.sql txkcreateACL.sh

adcrdbclone.sql addbccnv.sql adlicnse.sql afdbprf.sh txkcreateACL.sql

6.[oracle@ebs-db TEST_ebs-db]$ sqlplus "/ as sysdba" @adupdlib.sql so

SQL*Plus: Release 12.1.0.2.0 Production on Sun Aug 1 13:10:33 2021

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics, and Real Application Testing options

PL/SQL procedure successfully completed.

SQL> exit

cd [RDBMS ORACLE_HOME]/appsutil/clone/bin $ perl adcfgclone.pl dbconfig [Database target context file] Where Database target context file is: [RDBMS ORACLE_HOME]/appsutil/[Target CONTEXT_NAME].xml.

7.Context file Location :

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

perl adcfgclone.pl dbconfig /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.65

Enter the APPS password : <Dev Application Apps Password >

Running Rapid Clone with command:

Running:

perl /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/adclone.pl java=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre mode=apply stage=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml showProgress contextValidated=false

Beginning dbconfig Apply - Sun Aug 1 13:16:51 2021

adcfgclone Version 120.63.12020000.65

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/testebsdb/TEST/db/tech_st/12.1.0/oui -classpath /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/xmlparserv2.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/java:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/ewt3.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/share.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/srvm.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDatabase -e /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml -stage /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone -showProgress -noRmanRecovery yes -checkDBConnection

APPS Password : Log file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/ApplyDatabase_04091316.log

| 0% completed

Log file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/ApplyDatabase_04091316.log

/ 30% completed

Completed Apply...

Sun Aug 1 13:17:51 2021

Starting database listener for TEST:

Running:

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/scripts/TEST_ebs-db/addlnctl.sh start TEST

Logfile: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process TEST ...

Listener TEST has already been started.

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/addlnctl.txt for more information ...

Running ETCC to check status of DB technology patches...

+===============================================================+

| Oracle E-Business Suite Release 12.2 |

| Database EBS Technology Codelevel Checker |

+===============================================================+

Validating context file: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

Using context file from command line argument:

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

Starting Database EBS Technology Codelevel Checker, Version 120.83

Fri Apr 9 13:17:51 IST 2021

Log file for this session : /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/log/checkDBpatch_4652.log

Identifying database release.

Database release set to 12.1.0.2.

Connecting to database.

Database connection successful.

Database TEST is in READ WRITE mode.

Identifying APPS and APPLSYS schema names.

- APPS schema : APPS

- APPLSYS schema : APPLSYS

Checking for DB-ETCC results table.

Table to store DB-ETCC results already exists in the database.

Checking if InMemory option is enabled.

InMemory option is not enabled in the database.

Bugfix file /testebsdb/TEST/db/tech_st/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.58

This file will be used for identifying missing bugfixes.

Mapping file /testebsdb/TEST/db/tech_st/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.33

This file will be used for mapping bugfixes to patches.

Identified RDBMS DST version 18.

Checking Bugfix XML file for 12.1.0.2_PSU

Obtained list of bugfixes to be applied and the list to be rolled back.

Now checking Database ORACLE_HOME.

The opatch utility is version 12.2.0.1.24.

DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for 12.1.0.2.210119

All the required one-off bugfixes are present in Database ORACLE_HOME.

Stored Technology Codelevel Checker results in the database TEST successfully.

Finished checking fixes for Oracle Database: Sun Aug 1 13:18:00 IST 2021

Log file for this session: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/log/checkDBpatch_4652.log

===============================================================================

[oracle@ebs-db bin]$

9.Application Cloning:

10.Source application: DEV Application

Backup of Location is /u01/applmgr/Backup/EBSAPPS_fs1_bkp01AUG21.tar.gz

Application Backup move to Target Server (TEST instance )

scp -P EBSAPPS_fs1_bkp01AUG21.tar.gz /testebsapp/TEST/fs1

untar the Application Backup file

tar -xvzf EBSAPPS_fs1_bkp01AUG21.tar.gz

cd /testebsapp/TEST/fs1/EBSapps/comn/clone/bin

applmgr@ebs-app bin]$ perl adcfgclone.pl appsTier dualfs

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.65

Enter the APPS password : <Dev Apps Password>

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] : no

Running: Context clone...

Log file located at /testebsapp/TEST/fs1/EBSapps/comn/clone/bin/CloneContext_0409120727.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [ebs-app] :

Target System Database SID : TEST

Target System Database Server Node [ebs-app] : ebs-db

Target System Database Domain Name [xyz.com] :

Target System Base Directory : /testebsapp/TEST/

Target System Base Directory set to /testebsapp/TEST/

Target System Current File System Base set to /testebsapp/TEST/fs1

Target System Other File System Base set to /testebsapp/TEST//fs1

Target System Fusion Middleware Home set to /testebsapp/TEST/fs1/FMW_Home

Target System Other File System Fusion Middleware Home set to /testebsapp/TEST//fs1/FMW_Home

Target System Current File System Instance Top set to /testebsapp/TEST/fs1/inst/apps/TEST_ebs-app

Do you want to preserve the Display [devebsapp:0.0] (y/n) : n

Target System Display [ebs-app:0.0] : ebs-app:1.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] : 10

Checking the port pool 10

done: Port Pool 10 is free

Report file located at /testebsapp/TEST/fs1/inst/apps/TEST_ebs-app/admin/out/portpool.lst

Target System proxy port [80] :

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp

2. /testebsdb/tmp

3. /testebsdb/TEST/db/tech_st/12.1.0/appsutil/outbound/TEST_ebs-db

4. /usr/tmp

Choose a value which will be set as APPLPTMP value on the target node [1] : 2

The new APPL_TOP context file has been created :

/testebsapp/TEST/fs1/inst/apps/TEST_ebs-app/appl/admin/TEST_ebs-app.xml

Check Clone Context logfile /testebsapp/TEST/fs1/EBSapps/comn/clone/bin/CloneContext_0409120727.log for details.

Creating Patch file system context file.....

Log file located at /testebsapp/TEST/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0409122105.log

Target System Other File System Instance Top set to /testebsapp/TEST//fs1/inst/apps/TEST_ebs-app

Target System Port Pool [0-99] : 11

Checking the port pool 11

done: Port Pool 11 is free

Report file located at /testebsapp/TEST/fs1/inst/apps/TEST_ebs-app/admin/out/portpool.lst

The new APPL_TOP context file has been created :

/testebsapp/TEST//fs1/inst/apps/TEST_ebs-app/appl/admin/TEST_ebs-app.xml

Check Clone Context logfile /testebsapp/TEST/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0409122105.log for details.

FMW Pre-requisite check log file location : /testebsapp/TEST/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: FMW pre-req check...

Configuring: Run file system....

LogFile located at /testebsapp/TEST/fs1/inst/apps/TEST_ebs-app/admin/log/clone/run/RCloneApplyAppstier_08051221.log

Configuring: Patch file system....

LogFile located at /testebsapp/TEST/fs2/inst/apps/TEST_ebs-app/admin/log/clone/run/RCloneApplyAppstier_08051221.log

Other Topics:

oracleappsdba

Friday, February 9, 2024