EBS R12.2 Cloning Step by step

I explained Cloning step by step procedure for database and R12.2 application.

My Database version 11.2.0.3.0
   
    1. Preclone db tier and application Tier

    2. Copy the apps Tier  and db home only to target server

    3. Take Rman full backup and copy the backup to target server

           cd [RDBMS ORACLE_HOME]/appsutil/clone/bin
        

    $ perl adcfgclone.pl dbTechStack

                        Run adcfgclone dbTechStack

This files are to be restored to a different location:

db_file_name_convert=('/oracle/PROD/db/data' , '/oracle/CLONE/db/data')

log_file_name_convert=('/oracle/PROD/db/data' , '/oracle/CLONE/db/data')

$ sqlplus '/as sysdba'

SQL> startup nomount pfile='/<path>/initCLONE.ora';

This will nomount  the instance using the initCLONE.ora created.

Prepare for duplicate by starting the auxiliary instance

Create New Folder

#mkdir /d01/rman

Create a rman script

run

{

allocate auxiliary channel t1 type disk;

allocate auxiliary channel t2 type disk;

allocate auxiliary channel t3 type disk;

allocate auxiliary channel t4 type disk;

duplicate database to "CLONE" BACKUP LOCATION '/oracle/CLONE/RMAN/5AUG18';

release channel t1;

release channel t2;

release channel t3;

release channel t4;

}

Connect and run the duplicate

# cd /oracle/CLONE/RMAN

# rman auxiliary / cmdfile=RMAN.sql log=rmanlog7AUG18.log

Restoration is completed after check the database status  

19c Database Cloning 

High Level 19c CLONE STEPS

Drop database

Start the database in NOMOUNT mode.

Add parameter according to the source environment

Prepare the RMAN duplicate script and restore the database as per your environment.

Once restoration is completed follow the below steps

Convert the pdb to cdb database

 

Drop the database:

SQL>select name from v$database;

NAME

---------

CDBTEST

SQL>shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

 

SQL>startup mount restrict

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 1.6106E+11 bytes

Fixed Size                 30402640 bytes

Variable Size            8.4826E+10 bytes

Database Buffers         7.4357E+10 bytes

Redo Buffers              238030848 bytes

In-Memory Area           1610612736 bytes

Database mounted.

 

SQL>drop database;

Database dropped.

 

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.10.0.0.0

 

Start the database in NOMOUNT mode.

cat initCEBS1T.ora

 spfile='+DATAC1/CEBS1T/spfileCEBS1T.ora'

 

Below steps are already should be there just validate

 

remove parameter file:

*.control_files

*.db_create_file_dest

*.db_create_online_log_dest_1

*.db_create_online_log_dest_2

*.local_listener

*.remote_listener'

*.resource_manager_cpu_allocation

Add parameter according to the source environment

db_file_name_convert='+DATAc1','+DATA'

log_file_name_convert='+DATAc1','+DATA','+recoc1','+reco'

control_files='+DATA/','+reco/'

 

shutdown immediate

 

[oracle@geaebsdbsd07 dbs]$ sqlplus / as sysdba

 

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Sep 25 18:50:32 2021

Version 19.10.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='$ORACLE_HOME/dbs/initCDBTEST.ora'; --(  database  should startup  with spfile)

ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated

ORACLE instance started. 

Total System Global Area 1.6106E+11 bytes

Fixed Size                 30402640 bytes

Variable Size            8.4826E+10 bytes

Database Buffers         7.4357E+10 bytes

Redo Buffers              238030848 bytes

In-Memory Area           1610612736 bytes

SQL>

 

Prepare the RMAN duplicate script and restore the database as per your environment.

Once restoration is completed follow the below steps

 

[oracle@geaebsdbsd07 ~]$ ps -ef | grep pmon

oracle   19565     1  0 17:42 ?        00:00:00 ora_pmon_CDBTEST

oracle   20148     1  0 Aug24 ?        00:02:26 asm_pmon_+ASM

oracle   23232 19889  0 18:04 pts/1    00:00:00 grep --color=auto pmon

 

[oracle@geaebsdbsd07 ~]$ . oraenv

ORACLE_SID = [ORCL] ? CDBTEST

The Oracle base remains unchanged with value /u01/app/oracle

 

[oracle@geaebsdbsd07 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Sep 26 18:05:15 2021

Version 19.10.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.10.0.0.0

SQL> select name from v$database;

NAME

---------

CDBTEST

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                 READ ONLY  NO

         3 ercebs1p                       READ WRITE NO

 

converting the pdbname to small case.  (cautation   while doing the PDBNAME  conversion)

SQL> alter pluggable database "ercebs1p" close;

Pluggable database altered.

 

SQL> alter session set container=cdb$root;

Session altered.

 

SQL> alter pluggable database "ercebs1p"  unplug into '/u01/app/oracle/product/19c/dbhome_1/dbs/ercebs1p_PDBDesc.xml';

Pluggable database altered.

 

SQL> drop pluggable database "ercebs1p";

Pluggable database dropped.

 

SQL> create pluggable database "cdbtest" using '/u01/app/oracle/product/19c/dbhome_1/dbs/ercebs1p_PDBDesc.xml' NOCOPY SERVICE_NAME_CONVERT=('ebs_ercebs1p','ebs_cdbtest','ercebs1p_ebs_patch','cdbtest_ebs_patch');

Pluggable database created.

 

SQL> alter pluggable database "cdbtest" open read write;

Warning: PDB altered with errors.

 

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED              READ ONLY  NO

         4 cdbtest                      READ WRITE YES

SQL> alter session set container="cdbtest";

Session altered.

SQL> alter session set container=cdb$root;

Session altered.

 

SQL> alter pluggable database all save state instances=all;

 Pluggable database altered.

 

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

 

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

 

Total System Global Area 1.6106E+11 bytes

Fixed Size                 30402640 bytes

Variable Size            8.4826E+10 bytes

Database Buffers         7.4357E+10 bytes

Redo Buffers              238030848 bytes

In-Memory Area           1610612736 bytes

Database mounted.

Database opened.

SQL>

set pages 200

col name for a30;

col PDB for a30;

select SERVICE_ID, NAME, PDB from cdb SERVICES;

SERVICE_ID_NAME        PDB

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

1 SYS$BACKGROUND         CDB$ROOT

2 SYS$USERS              CDB$ROOT

3 ebs patch              CDB$ROOT

4 CDBTEST                CDB$ROOT

5 CDBTESTXDB             CDB$ROOT

6 CDBTEST.prd.valueaddco.com CDB$ROOT

7 ercebs1p                CDB$ROOT

8 cdbd100XDB             CDB$ROOT

9 CDBD100                CDB$ROOT

9 rows selected.

SQL> exec dbms service.delete service('ercebs1p');

PL/SQL procedure successfully completed.

SQL> alter pluggable database "cdbtest" close;

Pluggable database altered.

SQL> alter pluggable database "cdbtest" open;

Pluggable database altered.

set pages 200

col name for a30;

col PDB for a30;

select SERVICE_ID, NAME, PDB from cdb SERVICES;

SERVICE_ID_NAME        PDB

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

1 SYS$BACKGROUND         CDB$ROOT

2 SYS$USERS              CDB$ROOT

3 ebs patch              CDB$ROOT

4 CDBTEST                CDB$ROOT

5 CDBTESTXDB             CDB$ROOT

6 CDBTEST.prd.valueaddco.com CDB$ROOT

7 ercebs1p                CDB$ROOT

8 cdbd100XDB             CDB$ROOT

9 CDBD100                CDB$ROOT

9 rows selected.

SQL> exec dbms service.delete service('ercebs1p');

PL/SQL procedure successfully completed.

alter pluggable database "erecebs1t" open read write;

select name,open_mode from v$pdbs;

alter session set container="erecebs1p";

exec dbms_service.CREATE_SERVICE ('erecebs1t_ebs__patch','erecebs1t_ebs_patch');

exec dbms_service.start_service('d100_ebs_patch');

select name from v$active_services;

alter session set container="CDB$ROOT";

alter pluggable database "erecebs1t" save state;

SQL> alter pluggable database all save state instances=all;

Pluggable database altered.

Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone

Cloning is the process of creating a copy of an existing Oracle E-Business Suite system. The cloning methodology described in this document covers the process used to clone an Oracle E-Business Suite Release 12.2 system.

The cloning process consists of the following three phases, each of which is made up of several logical sections and their steps.

1. Prepare the Source System for application tier. 
2. Copy both application tier nodes from the Source System to Target System. 
3. Configure the Target System for and application tier.

Once completed the adpreclone can you please confirm below files are created

ls -ltr $COMMON_TOP/clone/FMW/FMW_Home.jar

ls -ltr $COMMON_TOP/clone/FMW/WLS/EBSdomain.jar

ls -ltr $COMMON_TOP/clone/FMW/WLS/plan/moveplan.xml

ls -ltr $COMMON_TOP/clone/FMW/OHS/ohsarchive.jar

ls -ltr $COMMON_TOP/clone/FMW/OHS/moveplan.xml

Configure the Target System application tier server nodes 

Log on to the Run Edition File System in the Target System as the applmgr user and enter the following commands:

$ cd <COMMON_TOP>/clone/bin

$ perl adcfgclone.pl appsTier 

Application Cloning is completed. Check opmn status and open the front end.

FS2 patch Edition File System is cloning enter the following commands:

$ cd <COMMON_TOP>/clone/bin

$ perl adcfgclone.pl appsTier 

RUN ADCFGCLONE appsTier dualfs Steps ON APPS NODE

 

 

$ cd /apps/applmgr/r12/fs1/EBSapps/comn/clone/bin

 

$ perl adcfgclone.pl appsTier dualfs

 

apps password: apps

weblogic password: weblogic123

Do you want to add a node (yes/no) [no] : <press enter>

Target System Hostname (virtual or normal) [appsebsvis] : appsebsvis

Target System Database SID : test

Target System Database Server Node [dbebsvis] : dbebsvis

Target System Base Directory : /apps/applmgr/r12

Target System Instance Home Directory [/apps/applmgr/r12] :

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

Target System Display [appsebsvis01: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] : enabled

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

Target System proxy hostname [http-proxy.amer.consind.ge.com] :

Target System proxy port [8080] :

1. /usr/tmp/TEST

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

Target System Other File System Instance Top set to /apps/applmgr/r12/fs2/inst/apps/test_appsebsvis

Target System Port Pool [0-99] : 1

 

The new APPL_TOP context file has been created :

  /apps/applmgr/r12/fs1/inst/apps/ERCEBS1T_appsebsvis/appl/admin/ERCEBS1T_appsebsvis.xml

Check Clone Context logfile /apps/applmgr/r12/fs1/EBSapps/comn/clone/bin/CloneContext_1111074006.log for details.

 

Creating Patch file system context file.....

 

Log file located at /apps/applmgr/r12/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1111075056.log

 

Post Cloning Steps:

1. Change system password

2. Change apps password

3. Change alloracle password

4. Change sysadmin password

5. Change Site name profile

6. Change Form Color profile

7. Run cmclean.sql scripts

8. Clear the schedule concurrent program

Workflow related steps:

Connect with APPS user

 

update fnd_svc_comp_param_vals

set    parameter_value = 'dummy@dummy.com'

where  parameter_id =

( select parameter_id

 from   fnd_svc_comp_params_tl

 where  display_name = 'Test Address'

);

 

COMMIT;

 

 

select count(*)  from WF_NOTIFICATIONS where status = 'OPEN' and mail_status = 'MAIL';

 

update WF_NOTIFICATIONS set status = 'CLOSED', mail_status = 'SENT', end_date = sysdate where mail_status in ('MAIL', 'ERROR','FAILED','INVALID')  ;

 

commit;

 

select count(*)  from WF_NOTIFICATIONS where status = 'OPEN' and mail_status = 'MAIL';

 

Run the script wfntfqup.sql to purge the WF_NOTIFICATION_OUT queue and rebuild it with data currently in the WF_NOTIFICATIONS table. This is what purges all notifications waiting in the queue to be sent.  It will then populate the queue with the current data in the wf_notifications table. Since you have changed the mail_status = 'SENT" it will not enqueue these messages again.. Only the ones where mail_status = 'MAIL' and status = 'OPEN' will be placed in the WF_NOTIFICATION_OUT queue and sent by the mailer.

 

Example Syntax:

 

sqlplus apps/apps@db @$FND_TOP/patch/115/sql/wfntfqup.sql apps <apps> applsys

 

Update fnd_user set email_address = 'TestOraUser@dummy.com' WHERE email_address IS NOT NULL;

Update per_people_f set email_address = 'TestOraUser@dummy.com' WHERE email_address IS NOT NULL;

update wf_local_roles set email_address = 'TestOraUser@dummy.com' WHERE email_address IS NOT NULL;

Update po_vendor_sites_all set email_address = 'TestOraUser@dummy.com', remittance_email = 'TestOraUser@dummy.com' WHERE email_address IS NOT NULL or remittance_email is not null;

 Update hz_parties set email_address = 'TestOraUser@dummy.com' WHERE email_address IS NOT NULL;

 

Update FND_USER_PREFERENCES set preference_value= 'QUERY' where preference_name='MAILTYPE' and preference_value!='QUERY';

 

set lines 132

col PREFERENCE_VALUE format a45

SQL> select preference_value,count(*) from fnd_user_preferences where preference_name='MAILTYPE'  group by preference_value;

   Cloning Frequently Asked Questions

What is the location of adpreclone.pl in oracle database?

$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adpreclone.pl

What is the location of adpreclone.pl in oracle application?

$ADMIN_SCRIPTS_HOME/adpreclone.pl

What is the location of adcfgclone.pl in oracle database?

$ORACLE_HOME/appsutil/clone/bin

What is the location of adcfgclone.pl for applmgr user?

$COMMON_TOP/clone/bin

When we run Perl adpreclone.pl dbTier why it requires apps password?

It is requires a database connection to validate apps schema

What is Perl adpreclone.pl do on appsTier?

It’s create the Clone directory in application side

cd $COMMON_TOP/clone

It will collect all the information about the source system, creates a cloning stage area, and generates templates and drivers. All of these are to reconfigure the instance on a Target machine.

What is Perl adpreclone.pl do on databaseTier?

It’s create the clone directory

$ORACLE_HOME/appsutil/clone/directory

Obtains Database Information

Creates adcrdbclone.sql

What is adcfgclone.pl do on applicationTier?

Its create a context file and register the oracle_home,relink the oracle_home the create the INST_TOP and cofigure the appl_top

What is adcfgclone.pl do on DatabasseTier?

Its create the context file and register oracle_home,relink the oracle_home then recreate the controlfile and start the listener

What do adcfgclone.pl dbTechStack?

Its create the context file,register and configure oracle_home then start the listener

Refer:

RMAN 11GR2 : DUPLICATE Without Target And Recovery Catalog Connection (Doc ID 874352.1)

Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)

Cloning Oracle Applications Release 12 with Rapid Clone (Doc ID 406982.1)