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  





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.
One 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

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)

Comments

  1. Sanjeev , This is very Nice detailed steps very useful and handy steps for 12.2 cloning

    ReplyDelete
  2. One of the good document for cloning.. thanks Sanjeev

    ReplyDelete
  3. Is there a process / script which can update (only for information) that clone was performed on date/ time comments ?
    This should update at certain db and apps tier places and perl scripts. This is only for information.
    Let me know.
    Thanks
    Sandip Kumar

    ReplyDelete
  4. Gracefully written information on this blog are going to support me for my coming assignments. Every point was very clear and taught me few new parameters. I would like to use this information in coming future.
    Tinder Clone

    ReplyDelete
  5. Please find some more oracle DBA interview question:
    www.top15search.blogspot.com

    ReplyDelete
  6. Ebs R12.2 Cloning Step By Step >>>>> Download Now

    >>>>> Download Full

    Ebs R12.2 Cloning Step By Step >>>>> Download LINK

    >>>>> Download Now

    Ebs R12.2 Cloning Step By Step >>>>> Download Full

    >>>>> Download LINK Id

    ReplyDelete
  7. Very good article . Thanks for sharing.
    Snowflake Training
    Snowflake Training in Hyderabad
    Snowflake Online Training
    Snowflake Online Training Hyderabad
    Snowflake Training Online
    Snowflake Training in Ameerpet
    Snowflake Training Institute in Hyderabad

    ReplyDelete

Post a Comment

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

How to run Gather Schema Statistics in R12.2

How to compile forms in R12.2