Cloning Oracle Applications Release 11 and 12

Mayıs 31, 2010

Cloning Oracle Applications Release 11 and 12

In this article i will explain how we can take clone in Oracle EBS

Lots of EBS forum users ask same question in forum, “How i can take clone”.

If you take first time of your source system,than you have to check your source system has Rapid Clone patches. For all steps and patches name please refer:

Cloning Oracle Applications Release 12 with Rapid Clone [ID 406982.1]
Cloning Oracle Applications Release 11i with Rapid Clone [ID 230672.1]

Before start to process let us define something about clone.

Source system means, our existing instance. It could be test or prod(even clon) instance.

Target system means, our new instance which is same as like source system.Its mean clone is 1 of 1 copy of our source system. Same data, same user etc.

We assume our operating system is Linux and we assuem we are try to taking clone of our PROD system.

Our source system users are:

applprod user for Application Tier

oraprod user for Db tier

Our target system users are:

applclon user for Application Tier

oraclon user for Db tier

1. Run preclone on source system:

When you are running preclone you dont need to close your system.

DB Tier

$ cd $ORACLE_HOME/appsutil/scripts/ SID_HOSTNAME
perl adpreclone.pl dbTier

Apps Tier

$ cd $COMMON_TOP/admin/scripts/SID_HOSTNAME

perl adpreclone.pl appsTier

2. Copy the source system to the target system

For this steps you need to close your apps+db+listener.

A. Close your apps&db services

Apps tier:

Shutdown the App

$ cd $COMMON_TOP/admin/scripts/SID_HOSTNAME

$./adstpall.sh apps/<apps_pass>

be sure there is no any process for applprod user,you can use below command:

ps -u applprod

Db Tier:

$lsnrctl stop SID

$sqlplus “/as sysdba”

SQL> shutdown immediate;

be sure there is no any process for oraprod user,you can use below command:

ps -u oraprod

B. Start to copy process from source to target

When you are sure all services down and no any process for apps&db user you have to copy your all folder from source to target.

Please dont forget; If you have any session for apps+db it will cause error in clone process on target server

Let us say all folder under /u01/PROD in your source server and you want to copy this folder to /data/CLON in target server. So please follow below

1.Login as root user to your source system

2.scp -r /u01/PROD root@10.x.x(target machine IP):/data/CLON

it will ask you clon server’s root user password,enter password and you will see it will start to copy

When copy process compliate than you can open your source system

C. Rename folders name in target server

After copy process you can rename folder names in target

R11:

mv prodcomn clonecomn
mv prodora clonora
mv prodappl cloneppl
mv proddata clonedata
mv proddb clonedb

R12:

cd /data/PROD <<< its our target server path

mv inst inst_old

mkdir inst

3. Start Clone process on target node:

Before start to clonning process we must set perl and per5lib for apps and db tiers.

For more details please check:

Setting the Perl Environment PERL5LIB [ID 395294.1]
Common Perl Setup Issues and Solutions for E-Business Suite 11i [ID 404055.1]

A. If you dont have clone user on source system than create user

useradd -g dba -d /home/applprod applprod

useradd -g dba -d /home/oraprod oraprod

B. Start post clone on dbtier first

For r12 clonning:

Set perl and perl5lib for db tier.

R12-dbTier:

Login as oraclon user

export PATH=/xx/db/tech_st/11.1.0/perl/bin/perl:$PATH
export PERL5LIB=/xx/db/tech_st/11.1.0/perl/lib/5.8.3/:/xx/db/tech_st/11.1.0/perl/lib/site_perl/5.8.3/

$ cd [RDBMS ORACLE_HOME]/appsutil/clone/bin $ perl adcfgclone.pl dbTier

R12-appsTier:

Login as applclon user

export PATH=/xx/apps/tech_st/10.1.3/perl:$PATH
export PERL5LIB=/xx/apps/tech_st/10.1.3/perl/lib/5.8.3:/xx/apps/tech_st/10.1.3/perl/lib/site_perl/5.8.3

$ cd [COMMON_TOP]/clone/bin $ perl adcfgclone.pl appsTier

Set perl and perl5lib for apps tier:

For r11 clonning:

R11-dbTier:

Login as oraclon user

export PATH=/xx/clondb/10.2.0/perl:$PATH
export PERL5LIB=/xx/clondb/10.2.0/perl/lib/5.8.3:/xx/clondb/10.2.0/perl/lib/site_perl/5.8.3

$ cd [RDBMS ORACLE_HOME]/appsutil/clone/bin $ perl adcfgclone.pl dbTier

R11-apps Tier:

export PATH=$xx/clonora/iAS/Apache/perl/bin:$PATH
export PERL5LIB=/xx/clonora/iAS/Apache/perl/lib/5.00503/:/xx/clonora/iAS/Apache/perl/lib/site_perl/5.00503

$ cd [COMMON_TOP]/clone/bin $ perl adcfgclone.pl appsTier

References:

Cloning Oracle Applications Release 12 with Rapid Clone [ID 406982.1]
Cloning Oracle Applications Release 11i with Rapid Clone [ID 230672.1]

Setting the Perl Environment PERL5LIB [ID 395294.1]
Common Perl Setup Issues and Solutions for E-Business Suite 11i [ID 404055.1]

Oracle Database&EBS General

Posted by:

Gunes Erol

http://apex.oracle.com/pls/otn/f?p=19297:4:1668120596920607::NO:4:P4_ID:4160

“Cloning Oracle Applications Release 11 and 12” için 19 cevap

facebook clone

Haziran 12, 2010 at 10:40 pm

What I get from your blog is, you are an excellent writer and you know what the readers want. I wish you all the good luck in your future posts.

Cevapla
1. guneserol
  
  Haziran 15, 2010 at 3:20 pm
  
  Thanks for your kind words
  
  Cevapla
vasanth

Temmuz 15, 2011 at 1:52 pm

great post… its like spoon feed….. nice.. keep going….

Cevapla
1. Gunes Erol
  
  Temmuz 15, 2011 at 10:10 pm
  
  Thank you Vasanth
  
  Cevapla
charan

Ağustos 5, 2011 at 1:40 pm

Obviously helpful to all apps DBA beginners like me.

Cevapla
Wilson

Haziran 7, 2012 at 9:24 am

This is one of the best and clean documentation and learning blogs on EBS. Keep on the good work. It really help freshers like myself.

Cevapla
1. Gunes Erol
  
  Haziran 7, 2012 at 3:03 pm
  
  Thanks you for your kind words Wilson 😉
  
  Cevapla
mazhar

Ağustos 2, 2012 at 12:06 am

Hi.
I found your blog really Admirable to say the least
You ‘ve explained the cloning process in such a simple & understandable format that i m able to replicate the cloning without any hassle even though am just new into oracle apps DBA.

Wonder if u could explain the cloning of r12 instances on same Linux server like if we r doing cloning on the same server we just ‘ve to mv existing directory instead of copying file from one directory to another ? Or the source And the new clone instances services can be up if both are on the same Linux server. ??

Hope you understand my confusion.

Really appreciate if you could brief on that

Thanks & regards
mazhar

Cevapla
1. Gunes Erol
  
  Ağustos 3, 2012 at 8:17 am
  
  Hi Mazhar;
  Thanks for your kinds words… Actually your question answer is simple.. Let us say your EBS instance under /u01/TEST/xxxx and you want to take clone on same server and you dont have path such as /u02 or /u03… So here is the steps
  1. Create folder under /u01/CLONE than run preclone on for your existing system (You may create new apps and db user for your clone system)
  2. Close your TEST system and copy all related folder under /u01/TEST/xx to /u01/CLONE/xx..
  3. Start post clone process and use new path for questions..
  Do not forget to give different port number for your new clone instance..Thats all
  
  Regards
  Gunes
  
  Cevapla
  1. mazhar
    
    Ağustos 6, 2012 at 11:35 pm
    
    Hi Gunes,
    
    Thanks a ton !! You really made it easier for me to understand.
    
    You are a Wonderful Person.
    
    Hoping to get enlightened from you in future as well.
    
    Regards
    Mazhar
  2. mazhar
    
    Ağustos 7, 2012 at 1:01 am
    
    Hi,
    Sorry to bother you again ! This might sound Childish or rather seems stupid to you but still
    if you Could kindly confirm the below steps
    
    Its a Vision Instance While cloning on same server
    How do we copy/rename Apps & db tier filesystem like
    
    mkdir -p /dbtieR12/CLONE
    mkdir -p /appstieR12/CLONE
    
    mv $APPL_TOP /appstieR12/CLONE
    mv $COMMON_TOP /appstieR12/CLONE
    mv $IAS_ORACLE_HOME /appstieR12/CLONE
    mv $INST_TOP /appstieR12/CLONE
    
    on dbtier if we do
    mv $ORACLE_HOME /dbtieR12/CLONE
    so the settings for target clone datafile location (DATA_TOP)
    would be /dbtieR12/CLONE.
    
    Is this the right way to copy/rename the filesystem directory structure on appstier & dbtier or is there any other way ?
    
    do we need to COPY $INST_TOP since this got created automatically while running adcfgclone.pl script.
    
    Also How we could dump the clone output to a logfile as part of a script to verify things.
    
    Thanks & regards
    Mazhar
  3. Gunes Erol
    
    Ağustos 8, 2012 at 9:58 am
    
    Hi Mazhar;
    
    Your steps seems correct and you are right you dont need to copy INST_TOP
    
    By the way thanks for your kind words.
    
    Regards
    Gunes
mazhar

Ağustos 8, 2012 at 10:36 am

Hi Gunes,

Could u please specify as How we could dump the clone output to a logfile as part of a script to verify things.

Thanks & regards
Mazhar

Cevapla
1. Gunes Erol
  
  Ağustos 8, 2012 at 10:57 am
  
  Hi Mahzar;
  
  For me its hard to update blog. Could you open thread at OTN forum site please. I will keep updating you there.
  
  Regards
  Gunes
  
  Cevapla
  1. mazhar
    
    Ağustos 12, 2012 at 1:12 am
    
    Hi,
    I couldn’t open the thread as u suggested .. Extremely sorry to bother u again as i just got stuck up .
    
    I ‘ve the following Doubt ! really Appreciate if could reply
    
    DO we ‘ve to update environment file
    even if we r cloning on the same server.
    
    suppose my Original $APPL_TOP location is
    
    /oracle/VIS/apps/apps_st/appl
    
    And i mv it to
    
    /appstier/CLONE directory
    
    Do i ‘ve update the change of location in the main environment file ???
    
    Hope you understand my confusion as m just a beginner in EBS.
    
    Kindly suggest .
    
    Thanks & regards
    Mazhar
  2. Gunes Erol
    
    Ağustos 12, 2012 at 11:32 pm
    
    Hi;
    
    You dont need to upgrade any file, Clone process handle all for you, It will create new context file under your new CLONE directory.
wonder

Mart 20, 2013 at 10:17 pm

hi, really helpful post… i wonder if it is posible to clone EBS R12 from a hp ux machine to a windows machine?

Thanks.

Cevapla
1. Gunes Erol
  
  Mart 21, 2013 at 4:45 pm
  
  Hi;
  You need to migration for your issue please review:
  Application Tier Platform Migration with Oracle E-Business Suite Release 12 [ID 438086.1]
  Export/Import Process for Oracle E-Business Suite Release 12 using 10gR2 [ID 454616.1]
  General Notes For E-Business Suite Release 12 [ID 986673.1]
  
  Cevapla
  1. wonder
    
    Mart 21, 2013 at 6:28 pm
    
    Thanks for the pointer… i will look for more information about it.. if you know of any site i will apreciate it (we are out of support from the oracle site right now).
    
    Thanks again 🙂