Oracle Apps 11i Cloning part II

By reading my previous post about cloning you might have understood by now that Cloning Oracle Applications 11i E-Business Suite is method of creating replica of your source Instance.

Why I need a Clone ?
Your development team want to develop some custom functionality to Testing team want to test (load test/functional test) before taking some code to live system but they want exact replica of production apps 11i system including data. Answer to them is clone, Wish Oracle could release cloning of 10G Application Server Infrastructure Tier (Those who are supporting 10AS Portal/Discoverer can understand my pain )

Now lets explore what options/ methods are available for cloning
Till now (Aug 2006) there are two ways of cloning
Cloning 11i
Cloning 11i with Rapid Clone

Some DBA’s asked me about cloning using Autoconfig (Yes earlier we used to do that but that is now automated & called as Cloning using rapid clone so rapid clone internally uses Autoconfig) Hope this answer their query.

so now question is why two ways of cloning
Well those who are not lucky enough to upgrade their system and are still on apps version 11.5.5 or lower & not autoconfig enabled have to use , Cloning rest other enjoy luxury of Rapid Clone.

Those who tried both cloning & rapid clone can explain how easy rapid clone is 🙂 (I am Lucky that all my Apps Instances are now on 11.5.8 and higher )

If you want to see how people used to clone earlier or if your system is 11.5.5 or lower & not yet Autoconfig enabled then you need this link
https://metalink.oracle.com/metalink/plsql/docs/CLONING.PDF

If your system is 11.5.6 or higher you need Metalink Note # 230672.1 , Cloning Oracle Applications Release 11i with Rapid Clone

Now you enjoy reading above cloning document & tomorrow I’ll discuss difference between Autoconfig & Rapid Clone & other Rapid clone feature .

Those who have requested for Backup, Workflow in 11i & other topics I am going to post after cloning & patching. If you need information on any other post , leave comment on any blog (I read all comments & definitely reply , so do leave comments )

Those of you who want to read more on JVM ( Java Virtual Machine ) part of Oracle Applications Web Server 11i check it on my site http://teachmeoracle.com/jvm.html

Atul Kumar
Oracle Apps DBA

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

55 comments
Anonymous says September 20, 2006

hi atul,

thanks for sharing with us. May I ask you a couple of questions. for those of us with 11.5.5 and not autoconfig enabled, how do we go about doing cloning?

Can we apply patch 2942559 & 5107107?

for first timer, is it sufficient to follow notes 282930?

Please share your experience with us.

thanks
Kenny

Reply
Atul Kumar says September 20, 2006

Kenny,
Yes for first time its sufficient to follow note 282930.
Later you can apply all prereq. rapid clone patch mentioned in Rapid Clone Note # 230672.1 and use rapid clone .

Atul

Reply
Anonymous says September 20, 2006

hi Atul,

thanks for your replied. Just need further input from you.

Based on your advice, we can simply follow note 282930 to clone 11.5.5.

thereafter, we can use the patches mentioned in 230672.1 and apply to the 11.5.5? or, we need to apply these patches before the cloning 11.5.5?

thanks for your advice
Kenny

Reply
Atul Kumar says September 22, 2006

Kenny,
since these patches are rapid clone patches so if you wish to clone instance via rapid clone you have to apply these patches before clone. If you wish to clone without rapid clone via note 282930 then you can apply rapid clone patches any time ( before or after )

Atul

Reply
Anonymous says September 27, 2006

hi atul,

there is another system that I need to clone. It is a 11.5.9 oracle payroll system.

I had created a checklist for myself. Please give me your comments.

1) OUI22: latest patch 5035661
2) JRE: 1.1.8 in DB tier
3) JRE: 1.3.1_1.5 in DB tier for autoconfig
4) JDK: 1.3.1
5) AD minipack: all nodes: version I
6) Rapid clone patches: 3453499 (11i.ADX.F) & 5225940 (Post ADX.F. Fixes)

thanks
Kenny

Reply
Atul Kumar says September 27, 2006

Kenny,
Thats perfect.

Atul

Reply
Anonymous says October 2, 2006

hi atul,

As I was reading the patch info, I
realized that for AD minipack I and
OUI22, they were only meant for
Solaris Sunsparc 32bit. Does that
mean if the 11i is running on the
Solaris8, which is 64bit, it will
not be applicable?

thanks
Kenny

Reply
Atul Kumar says October 2, 2006

Kenny,
Could you guide me documentation which you are refering above . I’ll check & get back to you.

Atul

Reply
Anonymous says October 2, 2006

hi atul,

the documentation note id is 230672.1
when I try to download both OUI22 and
AD minipack I for Solaris, I realized
that it was only available for 32 bits
sparc. 64 bits sparc is not available.

The current system that I’m going to
clone is running on Sun Solaris 8,
which is 64bits.

Hope you can enlighten me.

Thanks
Kenny

Reply
Atul Kumar says October 3, 2006

Kenny,
Give me some time, I need to check on this.

Though Applications are always 32 bit where as database can be 32 or 64 bit. I suppose you have to apply 32 bit patch . I know its confusing when it comes to bit. I’ll recommend that you raise Tar as well just to be on safe side.

Atul

Reply
Anonymous says October 8, 2006

hi atul,

Oracle had replied. we can apply a
32bit patch onto a 64bit OS.

Regards,
Kenny

Reply
Atul Kumar says October 8, 2006

Thats good kenny & tahnks for sharing this with everybody

Atul

Reply
Anonymous says October 9, 2006

hi atul,

need to seek your advice.

i have this new situation. i have
2 servers. one is running 11.5.9 and
the other is an empty server.

furthermore, i do not have software
to install 11.5.9 in the new server.

can I restore the existing 11.5.9
to the new server and then do a
cloning.

please advice

thanks
Kenny

Reply
Atul Kumar says October 9, 2006

Kenny,
I suppose when you say empty server , you mean there is no Oracle software Installed on this .

Yes you can very well clone from you first server where you have 11.5.9 . Run adpreclone on db tier & apps tier on first server ( 11.5.9) , copy content from first server to empty server & run adcfgclone on both database tier & application tier as per metalink note mentioned above .

Atul

Reply
Anonymous says October 9, 2006

hi atul,

do i need to restore the binaries from
the first server and before I can do
the cloning?

Kenny

Reply
Atul Kumar says October 10, 2006

Kenny ,
Apologies for saying this but I suppose you have not read my cloning clearly I request you to go through it once again & metalink note for rapid clone & then get back to me for any doubts .

Atul

Reply
Anonymous says October 11, 2006

hi atul,

i had read it many times. just wonder
does it really work. for example, if
we clone databases, we need to
have the database binaries in the new
machine before we can copy the
database files from the original
machine to the new machine.

so, i was having this thought.

please bear with me as I’m
inexperience in 11i cloning.

Kenny

Reply
Atul Kumar says October 11, 2006

Kenny,
No issues I know oracle’s documentation is very tough to understand specially when you just started learning . I have gone through your phase.

If you check metalink note # 230672.1 for rapid clone

Under Section 2 Clone Oracle Applications 11i

at point 2 Copy the Source System to the Target System
under that point b Copy the database tier file system

in that you have third point
that

“Copy the source database ORACLE_HOME to the target system ” this is the binaries which you are taling about .

Do let me know if this is clear now.

Feel free to raise as many doubts as possible as thats motto of this site and apologies for my previous update 😉

Atul

Reply
Anonymous says November 2, 2006

hi atul,

i had successfully cloned the 11.5.9
system. thanks for your help.

everything was smooth.

cheers
Kenny

Reply
Atul Kumar says November 2, 2006

Kenny,
Thats really great news . I can remember the Day when I did clone first time . I knwo its great feeling . Good job .

Now you can raise all your issues (Hope you never encounter) but you can now help other apps dba’s with their issues at forum http://teachmeoracle.com/forum dedicated to Apps DBA’s

Atul

Reply
Anonymous says December 21, 2006

Hi Atul,

Can you please provide us with Oracle Portal topics too..

Reply
Atul Kumar says December 21, 2006

Thanks a lot for your suggestion , You will see some in near future . Few are already there under 10g Application Server..

Reply
Mohammad Asif says December 26, 2006

Hi Atul,

i am installing Oracle Apps 11.5.8 on platform Linux AS 3.0,

after passing 3-4 stag ,it stuck with error “error code received when running external process…”

Please help me with install doc and workaround,as i am unable to find the install doc for 11.5.8

Regards
Asif

Reply
Atul Kumar says December 26, 2006

Asif could you look at error message in log file about which external process its trying to run , please raise it in forum at http://TeachMeOracle.com/forum

Atul

Reply
Anonymous says January 24, 2007

Hey Atul,

I saw your note on JVM. have a question on that.
is there a way to find how many jvm’s are running?. I know i can check in the xml file. but i dont want to trust entry in xml file. how can i check how many jvms are running at Os level?

Reply
Atul Kumar says January 25, 2007

Hi Anonymous

In your Jserv.conf you will see entry like this here first 1 is entry & second one is weightage of that JVM

ApJServGroup OACoreGroup 1 1 /PATH_TO_IAS_TOP/Apache/Jserv/etc/jserv.
properties

ApJServGroup DiscoGroup 1 1 /PATH_TO_IAS_TOP/Apache/Jserv/etc/viewer
4i.properties

#ApJServGroup FormsGroup 1 1 /PATH_TO_IAS_TOP/Apache/Jserv/etc/forms
.properties

ApJServGroup XmlSvcsGrp 1 1 /PATH_TO_IAS_TOP/Apache/Jserv/etc/xmlsvc
s.properties

In below example there are in turnm three JVM & forth one commented

Reply
Anonymous says January 25, 2007

you mean to say
ApJServGroup OACoreGroup 1 1 /PATH_TO_IAS_TOP/Apache/Jserv/etc/jserv.
properties

means only one jvm is running?. if so then how should i change it to reflect 2 jvms?

Reply
Atul Kumar says January 26, 2007

There are three JVM’s running one for discoverer services , other for XML & third one OACoreGroup for other process (This si used by self services)

How to increase Number of JVM’s and more on JVM check at

http://www.teachmeoracle.com/jvm02.html

Reply
Anonymous says February 14, 2007

Hi Atul,
I am system adminstrator , bcoz of our dba guy is on leave , they want me to clone the prod instance .

Its the first time i am doing cloning & that to of production server. I have gone through the your specified doc ids.

I have summarized the things .. please go through this , add any thing is missing in it.. I want to make sure that cloning process goes off smoothly. Doing it on linux OS.

Also is this patch required for 11.5.9 PROD instance. Apply OHS patch 2674529.?? As per document 165195.1 . I am in PROD environment to make sure nothing happens to my prod instance.

============================
Prerequesties :

JRE 1.3.1
JDK 1.3.1
Zip 2.3
Unzip 5.x
Perl 5.004

Apply patch : 5478710

Apply rapid clone patches

Reply
Atul Kumar says February 14, 2007

Naidu doc 165195.1 is for autoconfig & not for rapid clone .

For rapid clone follow metalink note # 230672.1 Cloning Oracle Applications Release 11i with Rapid Clone

For any issues/doubts/questions kindly raise them in forum http://teachMeOracle.com/forum

Reply
Anonymous says March 6, 2007

Hi Atul,

I have read your article they are really nice.My quesition is how would i clone 2 Node RAC DB / 2 Node APP Nodes to 2 Node RAC DB / 2 APP Nodes with the Hot backup(RMAN) on a Red HAT Linux Platform RHEL 3.
I know the metalink link but can you explain it bit more

Thanks & Regards,
ASD

Reply
Atul Kumar says March 6, 2007

Hi ASD,
I think cloning note is self explanatory Do let me know what doubt you have in that doc.

Atul

Reply
Anonymous says April 3, 2007

Hello

I understand your comment about “pain” cloning a 10gAS infrastructure tier when apps is integrated with single-sign on. Do you have a method to achieve this – how exactly do you go about cloning an infrastructure tier?

Thanks
Simon

Reply
Atul Kumar says April 3, 2007

Simon,
There is not direct and supported way to clone infra tier. I’ll cover workaround to clone in coming posts

Reply
Anonymous says April 10, 2007

hi atul
thanks for sharing with us,i am working on 11.5.10.2 and doing manual cloning and after cloning my forms are not opening ,so how to resolove this type of errors

Reply
Atul Kumar says April 10, 2007

Check if appsweb_SID_HOSTNAME.cfg is correct and ICX form launcher profile option is pointing to right server. Also check if form server is up nd running

Reply
Anonymous says May 21, 2007

Atul, I got this error.. while ececuting this ..please have a look and let me have your suggestion..

oracle@dash:/home/oracle/9.2.0/appsutil/clone/bin:>> perl adcfgclone.pl database
Enter the APPS password [APPS]:
apps
ERROR : Unable to set CLASSPATH
/home/oracle/9.2.0/appsutil/clone/bin/../jlib/classes111.zip: is missing

Reply
Anonymous says May 21, 2007

Atul, I got this error.. while ececuting this ..please have a look and let me have your suggestion..

oracle@dash:/home/oracle/9.2.0/appsutil/clone/bin:>> perl adcfgclone.pl database
Enter the APPS password [APPS]:
apps
ERROR : Unable to set CLASSPATH
/home/oracle/9.2.0/appsutil/clone/bin/../jlib/classes111.zip: is missing

Reply
Atul Kumar says May 21, 2007

For any issues kindly raise them at http://teachMeOracle.com/forum

Reply
Sunita says May 27, 2007

Hi Atul,
I refer to your site regularly especially if i am facing some problem.we have 11.5.8 on windows, I did cloning for the first time using note:230672.1 using Rapid clone.
What I wanted to know is there any checklist for the Post clone settings.To verify that everything is working fine, which are the configuration that we need to check.

thanks
Sunita

Reply
Atul Kumar says May 27, 2007

I use 10 point checkist mentioned at http://www.teachmeoracle.com/healthcheck.html

You can add yor custom steps as well

Reply
Anonymous says June 9, 2007

Hi Atul,

Can u plz list the diffence b/w

perl adpreclone.pl appsTier merge

perl adpreclone.pl appltop merge

and what exactly happenns internally.

Reply
Atul Kumar says June 9, 2007

appstier will be used on node which is choosen as Primary Node like

perl adpreclone.pl appsTier merge

and appltop will be used on secondary nodes which you wish to merge with primary node

perl adpreclone.pl appltop merge

For more information open perl script adpreclone.pl and look for function appltop and appstier

Reply
AJJI says June 27, 2007

Hai Atul this is RamaKrishna, I am New to this group i want some details or any PDf about Cloning and also i want some Real Time Qusetions also. Plz Mail me

Reply
Paven says June 29, 2007

Hi Atul,

When using adcfgclone.pl (rapid clone), we will prompt for the values required to create the new context file manually. It means that we can’t put it in a script. Does it have options?

Thks,
Paven

Reply
Anonymous says July 9, 2007

What is the difference b/w adcfgclone dbTier vs database vs dbTechstack.

Reply
Atul Kumar says July 9, 2007

dbTechstack doesn’t create control file where as dbTier creates control file.

so if you are cloning from standby database or hot backup and created control file manually use dbTechstack but dbTier will recreate control file .

Reply
Anonymous says July 10, 2007

Hi Atul,

Copied all the files from source system to target system.Created database on the target system using a template from the source system.Now my doubt is as database got created which option do i need to run on the target system i.e, should i run adcfgclone.pl database or dbTier or dbTechctack. Please clarify my doubt.

Thanks

Reply
Atul Kumar says July 10, 2007

How you created database ? Why don’t you let adcfgclone.pl dbTier do everything for you .

For any issues / doubts raise them in forum at http://teachMeOracle.com/forum

Reply
lakshmikanthan says May 14, 2008

HI all,
when am running autoconfig this error will occured.

AutoConfig is configuring the Database environment…

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /ften/r02/oracle/ftendb/9.2.0
ERROR: OA_JRE_TOP isn’t available at either of the following locations
JDK – /ften/r02/oracle/ftendb/9.2.0/jdk
JRE – /ften/r02/oracle/ftendb/9.2.0/jdk
Pass option ‘java’ on command line
ERROR: OA_JRE_TOP isn’t available at either of the following locations
JDK – /ften/r02/oracle/ftendb/9.2.0/jdk
JRE – /ften/r02/oracle/ftendb/9.2.0/jdk
Pass option ‘java’ on command line
ERROR in setting Environment variable ADJREOPTS

HOW TO CHANGE THE LINK FILE USER AND GROUP OF OWNERSHIP

lrwxrwxrwx 1 venkatesan applften 17 Dec 29 12:38 jdk -> /usr/opt/jdk1.3.1

lrwxrwxrwx 1 venkatesan applften 10 Dec 29 12:30 JRE -> appsjre118

lrwxrwxrwx 1 venkatesan applften 5 Dec 29 12:35 oui21 -> oui22

Reply
Atul says May 14, 2008

To repoint softlink first delete it like

rm jdk

Then recreate it like

ln -s jdk

Reply
solo dude says March 24, 2009

Hi Atul,

Need help urgently. We want to clone 2 tier 11.5.9 on solaris to one node test instance. How do we do this? do we use merge where applicaiton server is node a and then the stuff with the database server is second node?

Reply
Atul Kumar says March 25, 2009

Check Metalink Note 230672.1 Cloning Oracle Applications Release 11i with Rapid Clone

Under Section 4: Advanced Cloning Options, check point 5 Reducing the number of nodes of a multi-node system (merge APPL_TOP)

You can use Rapid Clone to clone a multi-node system to a single-node system (or a multi-node system with fewer nodes) by merging the APPL_TOPs filesystem together. Follow the procedure for Merging existing APPL_TOPs in document 233428.1 on Oracle MetaLink.

Reply
sindhu says December 5, 2012

Hi,
Could you please assist me in one of my environment forms are not getting launched after cloning?(Multi node to single node clone we have done)

Reply
G Jaganndham says December 8, 2014

setClassPath: Unable to get PATH from environment or registry!:
The system could not find the environment option that was entered.

usdsop cannot create a new process

Cause: usdsop encountered an error creating a new process. [Reason].

Action: Check that your system had enough resources to start a new process. Contact your system administrator to obtain more resou (RE
Concurrent Manager encountered an error while running SQL*Loader for your concurrent request 5858748.

Review your concurrent request log file for more detailed information.

Reply
Add Your Reply

Not found