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
Login as oraprod user,
$ cd $ORACLE_HOME/appsutil/scripts/ SID_HOSTNAME
perl adpreclone.pl dbTier
Apps Tier
Login as applprod user,
$ 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
Login as applprod user,
$ 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:
Login as oraprod user,
$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
ls
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]
19 yorum
Comments feed for this article
Haziran 12, 2010 10:40 pm
facebook clone
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.
Haziran 15, 2010 3:20 pm
guneserol
Thanks for your kind words
Temmuz 15, 2011 1:52 pm
vasanth
great post… its like spoon feed….. nice.. keep going….
Temmuz 15, 2011 10:10 pm
Gunes Erol
Thank you Vasanth
Ağustos 5, 2011 1:40 pm
charan
Obviously helpful to all apps DBA beginners like me.
Haziran 7, 2012 9:24 am
Wilson
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.
Haziran 7, 2012 3:03 pm
Gunes Erol
Thanks you for your kind words Wilson 😉
Ağustos 2, 2012 12:06 am
mazhar
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
Ağustos 3, 2012 8:17 am
Gunes Erol
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
Ağustos 6, 2012 11:35 pm
mazhar
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
Ağustos 7, 2012 1:01 am
mazhar
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
Ağustos 8, 2012 9:58 am
Gunes Erol
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
Ağustos 8, 2012 10:36 am
mazhar
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
Ağustos 8, 2012 10:57 am
Gunes Erol
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
Ağustos 12, 2012 1:12 am
mazhar
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
Ağustos 12, 2012 11:32 pm
Gunes Erol
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.
Mart 20, 2013 10:17 pm
wonder
hi, really helpful post… i wonder if it is posible to clone EBS R12 from a hp ux machine to a windows machine?
Thanks.
Mart 21, 2013 4:45 pm
Gunes Erol
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]
Mart 21, 2013 6:28 pm
wonder
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 🙂