Clone Apps 11i Instance

Another important & useful utility under AD_TOP which you and me as apps dba perform quite often i.e. Cloning Oracle Application 11i Instance.

Cloning is process of creating replica of your source apps 11i Instance ( lets say you have one apps Instance with name VISIONTST and you want to create similar instance ( including same patches & user data) like VISIONPRD then you will use adclone utility (Also called as Rapid Clone these days). In this case source Instance will be VISIONTST and target Instance will be VISIONPRD. There are lot for scenario in which you wish to clone your E-Business Suite 11i Instance , like you want to Test if everything is OK in Test & then after testing want to create Production instance or you want to move your Instance from one machine to other machine or if you are highly experienced Apps DAB you can use clone as staged environment during Upgrade to reduce downtime ( this concept is called as staged appl_top or staged patching/upgrade , p.s. this is different from shared APPL_TOP)

So here I am putting broad level steps you will use to clone apps instance .

Step1 . Prerequisites Steps you do before start cloning using rapid clone
1.1 Verify source and target nodes software versions
1.2 Apply the latest AutoConfig Template patch
1.3 Apply the latest Rapid Clone patches

Step2 . Clone Source to Target
2.1 Run preclone on DB tier
2.2 Run preclone on Apps or middle tier
2.3 Copy source file system to target file system
2.4 Configure db tier
2.5 Configure apps/middle tier

Step 3 Finishing Task
3.1 Update profile options
3.2 Update printer settings (If printers are not configured or you don’t want to use printer you can skip this step)
3.3 Update workflow configuration settings (Important)

If you need to know about cloning steps in detail , please leave a comment on this post or drop a mail to me at atul_iiit@yahoo.com . For detailed steps check Metalink Note # 230672.1
In next post I will talk about Frequently Asked Questions in Apps 11i Interviews about cloning .

Don’t forget to leave comment about what you want to hear & any confusion if you have in apps 11i.

Happy Learning
Atul Kumar
Oracle Apps DBA

About the Author Atul Kumar

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

follow me on:

Leave a Comment:

91 comments
Anonymous says August 17, 2006

thank you so much for writing this appsdba blog.when are you posting clonning interview question?

appreciate your response

Reply
Atul Kumar says August 18, 2006

I’ll do it by tomorrow.

Atul

Reply
Anonymous says August 26, 2006

hey atul,

This template rocks…so does its content.can I nick it?

http://oracle.anilpassi.com

cheers
anil passi

Reply
Anonymous says August 30, 2006

Hi
Please explain what profiles, Printer settings; Workflow has to be updated after cloning
Thanks&Regards
Karthi

Reply
Atul Kumar says August 30, 2006

Karthi,

You can check post Install manual updates from Metalink Note # 230672.1 Cloning Oracle Applications Release 11i with Rapid Clone.

Profiles: You need to change profile values which are not site specific like Server Level,Instance Level, Responsibility Level ….other profiles which are pointing to source Instance.

Printer: You need to define new printer if target instance is using some other printer . If it has to use same printer as source no need to change any thing.

Workflow : you can check in above note

Reply
Anonymous says September 6, 2006

Hi Atul,

Appreciate your blog. Its been a good learning. I wanted to know about configuring a load balancer environment. For Example, I have a server on which my DB, conc processing, Reports reside and another server for my Web and Forms. Now I need to add another server on which I would like to loadbalance web and Forms. How to do that? I think I need to rapidclone the first Web & Forms server to the second one. Can you please elaborate the steps on how to do this. Thank you very much.

Reply
Anonymous says September 20, 2006

grande kabul!!!w juventus!:)

Reply
Anonymous says September 22, 2006

Hey Atul,

Great material and easy t understand

Regards,
Raghav

Reply
tushar says September 24, 2006

Hello atul,
I gone through your website and i found that it is very very useful for me. This site covers all the information regarding apps dba. which i am looking for. I am very thankful to you

Reply
Anonymous says October 5, 2006

Dear Atul,

Need your opinion on an issue with Database cloning using Read Only tablespaces

I have an 11.5.9 database production called as PRODN on node A.

To improve my backup timings I have made a few archive tablespaces as Read only

I can successfully recover this database on another Node with same SID as PRODN

No issues up to here and I have the tablespaces as Read only on DEVP node also.

I go to the prodn and run adpreclone and bring it over to the devp machine,I still see refernces to the read only tablespace datafiles in dbinfo.lst

Now when i make these tablespaces as Read write and runm my adcfgclone.pl there are no issue

1)However when i run adcfgclone.pl with RO tablespaces,it breaks

2)Does adcfgclone support RO tablespaces?Also shall it work if I make the tablespaces offline before running the adcfgclone and then i make them online after the adcfgclone

My database is big and dev env sql-backtrack has some license issue that i could not try the option 2 above

Regards
Praveen

Reply
Atul Kumar says October 5, 2006

Praveen,
Your issue is really different but good one. I don’t see any refernces regarding certification for RO tablespace in rapid clone but if you could share error message which you are getting & at what point your rapid clone is breaking so that I can find out in which phase of rapid clone RO tablespace is creating issue (In my views its during recreate control file phase)

Other readers any views on this ?

Atul

Reply
Anonymous says October 10, 2006

This is the error i get here

From log of the adcfgclone cloning a database with RO Tbalespaces on a new machine —>

PL/SQL procedure successfully completed.

ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.

Total System Global Area 628322632 bytes
Fixed Size 737608 bytes
Variable Size 452984832 bytes
Database Buffers 163840000 bytes
Redo Buffers 10760192 bytes

Control file created.

alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 505 was not restored from a sufficiently old backup
ORA-01110: data file 505: ‘/ORACLE/PROD/data/arch_invd01.dbf’

alter tablespace temp add tempfile ‘/ORACLE/PROD/system/temp01.dbf’ REUSE
*

##########
##################################
##################################
###################

Now if also make the RO tablespaces datafiles offline ,hoping that it shall let the resetlogs go thru manually this is what I get here

#########################
######################################
##################################

@PROD-> 10 >
@PROD-> 10 > alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01245: offline file 505 will be lost if RESETLOGS is done
ORA-01110: data file 505: ‘/ORACLE/PROD/data/arch_invd01.dbf’

@PROD-> 10 > alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

@PROD-> 10 > alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01245: offline file 505 will be lost if RESETLOGS is done
ORA-01110: data file 505: ‘/ORACLE/PROD/data/arch_invd01.dbf’

@PROD-> 10 > exit

Reply
Atul Kumar says October 10, 2006

Hi,
I’ll check on this RO tablespace & get back to you .

Atul

Reply
Prasad says October 27, 2006

Hello Atul,

I have a question on preclone. After running the preclone first time when should I run preclone next time. I mean to ask when / what situation I have to run preclone again?

Thanks
Prasad.

Reply
Prasad says October 27, 2006

Hello Atul,

I have a question on preclone. After running the preclone first time when should I run preclone next time. I mean to ask when / what situation I have to run preclone again?

Thanks
Prasad.

Reply
Prasad says October 27, 2006

Hello Atul,

I have a question on preclone. After running the preclone first time when should I run preclone next time. I mean to ask when / what situation I have to run preclone again?

Thanks
Prasad.

Reply
Atul Kumar says October 27, 2006

Prasad,
You should run adpreclone after applying any AD patches.

Though its not required to run adpreclone each time before cloning but you should do it after Big Patches (Minipacks) & definately after ATG , Tech Stack & AD Patches

Now you can raise these questions at forum dedicated to Apps DBAs at http://teachmeoracle.com/forum

Reply
Anonymous says October 31, 2006

Posting what Oracle said for RO tablespaces

—->

When cloning you cannot have read only tablespaces. These tablespaces needs to be tagged with the target dbid but this implies f

or you to follow appendix B of cloning document: Note 230672.1

Usually for this you need to run rman to copy datafiles from source to target.

Ususally during the clone adcfgclone sets the dbid to be unique using an rman api (dbms_backup_re

store.zeroDbid(0)) the datafiles need to be written to, and all the tablespaces

would need to be writable

If you choose to run Appendix B of above mentioned Note basically you need to run dbms_backup_restore.zeroDbid(0) after you manually

recreate the control file with the reference to the RO tablespaces.

So to specifically answer your question either you make writable all tablespaces before clo

ning or have in mind above considerations.

Reply
Atul Kumar says October 31, 2006

Hi Anonymous ,
Thanks a lot for sharing this information with Us. It would be nice if you could write your name as well so that readers can recognize you & can take help on other questions (Though u can always put comments as anonymous if you don’t wish to post ur name)

Reply
Anonymous says November 2, 2006

Yes that answer from Oracle was posted by me (Praveen) who originally raised all this hue and cry over the RO tablespace issues with adcfgclone.pl

I do not know where to post this
but posting here just if someone can answer this

I wanted to know if the Beta Exams 1Z1-232 and 1Z1-233 are still available as of 2-Nov-2006

They seem to have been valid from 31-AUG-2006 to 31-OCT-2006

I cannot see the exams being offered by Prometric anymore

Does anyone know when the 1Z0-232 and 1Z0-233 (production exams) shall be available for test takers?

As I am in India and no one picks up the helpdesk phone

Reply
Atul Kumar says November 2, 2006

Hi Praveen,
Thanks a lot for sharing this with us. You can write your name at bottom so that its easy for others to recognize .

About this questions you about Beta Test , you can post it in Forum under certification section at http://teachmeoracle.com/forum

I am in UK & will try to find information for you

Atul

Reply
Anonymous says November 30, 2006

Whevever ther eis change in database structure, u need to run adpreclone again. Else your database won’t be in sync with source database.

I forgot once and it cloned but it ommited the missing datafiles. later on i had issues with instance and figureed out that i missed adpreclone after adding datafile.

Reply
Anonymous says December 1, 2006

Hello Atul. Thanks for this great service. I am very new to Apps and wanted to clone 11.5.10. If i install Apps on the test server and i use rman or manual means to replicate database from production to test, will it work?

Reply
Atul Kumar says December 1, 2006

Yes , it will work

Atul

Reply
Anonymous says December 1, 2006

Hello Atul. I am from Kenya and i do not have a metalink account. You have stated that i can clone by simply installing apps on test server and cloning database using rman. Could you please post detailed steps of Apps 11.5.10 cloning or mail to (info@kenyadba.com). Once again thanks for this great service.

Reply
Atul Kumar says December 1, 2006

Ogutu,
Metalink Note ID is best source but unfortunately I can’t give you content of that note as this is against copy right . Take help from any of your friend who got metalink ID .

Regards
Atul Kumar

Reply
Anonymous says January 21, 2007

Hi Atul…
Is Oracle EBSSE 11.5.9 can be clone? as we know EBSSE is having activation code every new installation, and the code is unique on each node. Does this activation code is copied to the clone server?

Thanks
~Ivan~

Reply
Atul Kumar says January 22, 2007

Ivan , can you elaborate what is EBSSE ?

Specially SE bit in last

Reply
Anonymous says January 23, 2007

Hi Atul,

EBSSE means e-Business Suite Special Edition.
Oracle EBSSE 11.5.9 that called Oracle Discrete Manufacturing. That i know EBSSE is part of Oracle APPS 11i. We must input unique Activation Code every doing installed. As you know is this can be clone..?

Thanks,
~Ivan~

Reply
Atul Kumar says January 24, 2007

Ivan,
To be frank, I never heard of EBSSE but I am sure there might be option to clone same or to edit activation code after cloning (If code is dependent on SID or server name)

Check with Oracle Support on this .

Atul

Reply
Anonymous says February 27, 2007

Hi Atul,
We want upgrade 11.0.3/8.0.5 to 11.5.10.2/10.1.0.2 on Aix Machiens.

At present 11.0.3 on aix 4.3.3.
We have to upgrade 11.0.3 to 11.5.9 on AIX 4.3.3 & Upgrade OS Aix 4.3.3 to Aix 5L(5.3) then Upgrade 11.5.9 to 11.5.10.2 becoz of OS limitation.

Before that we have to upgrade our 8.0.5 database to 8.0.6.3, which basic version for 11.5.9/8.1.7.4 .

Could you give me clear picture & any related scripts.

Thanks & Regards
Seshu

Reply
Atul Kumar says February 27, 2007

Seshu,
I don’t have any upgrade doc from 11.0.3 at this minute but I’ll try to find if I can get upgarde doc from 11.0.3 from my old implementaion references

Reply
Anonymous says April 10, 2007

Hey Atul,

Do you have a presentation on Cloning..?

If you have one could you forward on sanjay203@yahoo.co.in

Sanjay

Reply
Anonymous says April 27, 2007

hi atul its really gr8 work n service u r providing can u give me some documents regarding the manual cloning n wht is the basic diff btvn manual n rapid cloning

Reply
pradeep says April 27, 2007

hi atul im a child in apps i mean fresher n i want to play it, n really gr8 u toprovide this services can u help me by posting some documents on cloning well pls make the diffrnz betvn rapid clone n manual cloning n interview questions
thanking u mr.atul

Reply
Atul Kumar says April 27, 2007

Pradeep,
Check following metalink notes for cloning

230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
406982.1 Cloning Oracle Applications Release 12 with Rapid Clone
364565.1 Troubleshooting RapidClone issues with Oracle Applications 11i
216664.1 FAQ: Cloning Oracle Applications Release 11i

Reply
sahil441 says June 18, 2007

hey atul,

i recently completed my course in oracle apps 11i but i am not feeling confident enough to face the interview,

please send me a list of questions,related to architecture,cloning,patching and upgradation.

eagerly waiting for your reply,

mohammed alimuddin
9985150241

Reply
Anonymous says July 27, 2007

Thank you very much for the amount of information you are giving us for appsdba. Actually I have a question regarding portal service to start first one has for starting instance, lsnr and db than, have to start portal with emctl and opmnctl for sso and portal both right? but for me it is not working can you pl guide me? Am i doing anything wrong This is new field for me

Reply
Atul Kumar says July 27, 2007

For start/stop on portal check

http://becomeappsdba.blogspot.com/2006/11/startup-shutdown-application-server.html

Order is start database and listener

Start insfrastructure tier using opmnctl

start portal middle tier using opmnctl

If you hit any issues raise them in forum at

http://teachMeOracle.com/forum

Reply
yas says September 25, 2007

hi atul

i have 11.5.10.2 apps in linux
to do preclone i want to apply any
patch. or jsut
run perl adpreclone.pl dbTier command ha .. i run this command i get stage completed. if run post clone i am getting RC-00110 fatal error.

can u give soln for this

thanks

yaseen.a.r

Reply
Atul Kumar says September 25, 2007

Yaseen,
Update this in forum http://teachMeOracle.com/forum with log from post clone.

Atul

Reply
Ahmed Khan says December 23, 2007

Hi Atul

I downloaded the VMware 6 for installing linux and apps on my pc but i found that the VMware is not free we need to buy that.Can u tell me how can i find VMware for free.

Bye.

Reply
hany says February 3, 2008

thanks My sir, can you send me details steps about cloning

Really, thank you

Reply
Katy says February 6, 2008

We are trying to clone a RAC 12i Apps to a Rac environment and have been unsuccessful. We have also tried to clone Rac to non Rac then convert the non Rac to Rac and this has been unsuccessful (we also are using ASM) Oracle does not have a procedure for this and has an ETA of 06/08 of this year. Has anyone done this successfully? Are you willing to share your docs?

Thanks

Katy

Reply
Atul Kumar says February 7, 2008

Use same doc as mentioned to clone 11i

Share what issues are facing while cloning R12 with RAC

Reply
Sridhar says February 12, 2008

You got a wonderful site and it is very educational, thankyou. I got a question on cloning. We are on 11.5.10.2/9.2.06 on Solaris. Did you ever try to automate the whole cloning process? I am trying to automate it and except for the APPS password I pretty much got everything automated. Can you throw some light on this.

Thanks
Sridhar

Reply
Sidobre says February 13, 2008

Hi Atul,

I’ve a question about preclone OA.
Before cloning, OA services must be started or only DB or both ?

Many thanks.

Best regards,

Abdel

Reply
Gayatri says March 10, 2008

hai.. atul..
help me out.
i am beginer of APPS DBA
i upgraded my apps 11.5.9 to 11.5.10.. on linux AS 4.
it is successful …
but .. i skipped the database upgrade to 10g ..
now (after 11.5.10) i tried to upgrade my database to 10g..its .fine.
but now i started my services found that my concurrent request status..COMPLETED ERROR….
plz.. help me out..

Reply
Vinay says March 10, 2008

hai.. atul..
help me out.
i am beginer of APPS DBA
i upgraded my apps 11.5.9 to 11.5.10.. on linux AS 4.
it is successful …
i tried to upgrade my database to 10g..its .fine.
but now i started my services found that my concurrent request status..COMPLETED ERROR….
plz.. help me out..

Reply
Gayatri says March 10, 2008

hai.. atul..
help me out.
i am beginer of APPS DBA
i upgraded my apps 11.5.9 to 11.5.10.. on linux AS 4.
it is successful …
but .. i skipped the database upgrade to 10g ..
now (after 11.5.10) i tried to upgrade my database to 10g..its .fine.
but now i started my services found that my concurrent request status..COMPLETED ERROR….
plz.. help me out..

Reply
amit says March 11, 2008

Hi,

Please check whether concurrent manager are up
ps -ef |grep FNDLIBR

Also check the log file of concurrent managers and get the exact error message.

Is it happening with all the concurent request or any particular one ?

Check the target and actual process from the from end.

Amit

Reply
s.srilatha says March 12, 2008

hai..
this is srilatha…learning Apps dba..
I am in process of upgrading my apps 11.5.9 to 11.5.10.2..(patch 3480000) on linux as 4.
while running adpatch i received an error..

ATTENTION: All workers either have failed or are waiting:

FAILED: file XDOLoader.class on worker 1.
FAILED: file XDOLoader.class on worker 2.
FAILED: file XDOLoader.class on worker 3.
FAILED: file XDOLoader.class on worker 4.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

i tried many a times to restart the worker using adctrl.. and
quit the workers & start adpatch again …
but no use ..
i tried by all means…
any one ..plz.. suggest me a solution
thank u..
awaiting ur reply..

Reply
Gayatri says March 12, 2008

hai..amit..
thanq.. for ur reply..

ya.. my concurrent managers are up on running ..

The exact error message is
***********************************************
+—————————–
| Starting concurrent program execution…
+—————————–

The executable file /gcss01/app/oracle/gcssappl/fnd/11.5.0/bin/ar60run for this concurrent program cannot be executed.

Contact your system administrator or support representative.

Verify that the execution path to the executable file is
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 2175559.

Review your concurrent request log and/or report output file for more detailed information.

+—————————————————————————+
Executing request completion options…
Finished executing request completion options.

+—————————————————————————+Concurrent request completed
Current system time is 12-MAR-2008 17:12:38

+—————————————————————————+~
*********************************************************

The above error occurs with all the requests..
all the target and actual processes are all equal…..

Reply
amit says March 13, 2008

Gayatri,

Please try the following actions

1.Relink the ar60run executable
$cd $FND_TOP
$adrelink force=y ranlib=y “fnd ar60run”
2.Bounce the Oracle Applications Servers and test

Reply
amit says March 13, 2008

Hi Srilatha,

Can you just check the worker log file to get the exact error message. This is very common issue and you need to apply the XDO related patch but depending on the error message patch number is decided. So let me know the error message.

Amit

Reply
s.srilatha says March 14, 2008

hi
thanks for your reply.
*******************************************************************
Start uploading…
Target file: PON_CONTRACT_AWARD_NOTICE_XSL.xsl
java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
at oracle.jdbc.ttc7.TTC7Protocol.parse
ExecuteDescribe(TTC7Protocol.java)
at oracle.jdbc.driver.OracleSt
atement.doExecuteQuery(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.do
ExecuteWithTimeout(OracleStatement.java)
at oracle.jdbc.driver.OraclePreparedStatement.
executeUpdate(OraclePreparedStatement.java)
at oracle.jdbc.driver.OraclePreparedStatement.
executeQuery(OraclePreparedStatement.java)
at oracle.apps.xdo.oa.util.XDOLoad\
er.processUpload(XDOLoader.java:1019)
at oracle.apps.xdo.oa.util.XDOLoader.process(XDOLoader.java:916)
at oracle.apps.xdo.oa.util.XDOLoader.main(XDOLoader.java:428)

AD Run Java Command is complete.

Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA

AD Java

Version 11.5.0

NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.

AD Worker error:
The above program failed. See the error messages listed
above, if any, or see the log and output files for the program.
*****************************

*************************************

This is the exact error I got in worker log file.
please send me related XDO patch number.

awaiting for reply

Reply
Gayatri says March 14, 2008

hi
I executed the command {adrelink.sh force=y ranlib=y “fnd ar60run”}
but I got adrelink error.
———————————————————————————————
/gcss01/app/oracle/gcssora/8.0.6/network/
jre11/lib/i686/native_threads/libjava
.so: undefined reference to `sem_init@GLIBC_2.1′
/gcss01/app/oracle/gcssora/8.0.6/network
/jre11/lib/i686/native_threads/libjava
.so: undefined reference to `sem_post@GLIBC_2.1′
/gcss01/app/oracle/gcssora/8.0.6/network/jre11
/lib/i686/native_threads/libjava
.so: undefined reference to `sem_destroy@GLIBC_2.1′
/gcss01/app/oracle/gcssora/8.0.6/network/jre11
/lib/i686/native_threads/libjava
.so: undefined reference to `sem_wait@GLIBC_2.1′
collect2: ld returned 1 exit status
make: *** [/gcss01/app/oracle/gcssappl/
fnd/11.5.0/bin/ar60run] Error 1
Done with link of fnd executable ‘ar60run’ on Fri Mar 14 10:47:49 IST 2008
Relink of module “ar60run” failed.
See error messages above (also recorded in log file) for possible
reasons for the failure. Also, please check that the Unix userid
running adrelink has read, write, and execute permissions
on the directory /gcss01/app/oracle/gcssappl/fnd/11.5.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation.

Done with link of product ‘fnd’ on Fri Mar 14 10:47:49 IST 2008
adrelink is exiting with status 1
——————————————————————————————
This is the relink error I got.
please give me any suggestion.

Reply
Sarfaraz says March 14, 2008

Hi,
For XDOLoader.class you have to Apply XDO ROLLUP Patch 4206181

Plz check Metalink Note : 362163.1

Thanks & Regards
Sarfaraz Karim

Reply
amit says March 14, 2008

Hi Srilatha,

I go with the Sarfaraz Commnets above. Pleae apply the above mentioned patch.

Amit

Reply
amit says March 14, 2008

Hi Gayatri,

Please follow the action plan :

cp $ORACLE_HOME/lib/stubs $ORACLE_HOME/lib/stubs.POST_P17
cp $ORACLE_HOME/lib/stubs.PRE_P17 $ORACLE_HOME/lib/stubs

Also can you let me know the forms/report Patchset level you are on ? You can get this by :

-Go to Oracle_8.0.6_HOME/bin
-Type f60gen and press enter. Let me know the version you are getting.

Let me know if this helps

Amit

Reply
Gayatri says March 15, 2008

hai.. amit..

I have executed the copy cmds ..

but the status of concurrent request didn’t change..
here’s the version of form server…

*********************************************************
Forms 6.0 (Form Compiler) Version 6.0.8.26.0 (Production)

Forms 6.0 (Form Compiler): Release – Production

(c) Copyright 1999 Oracle Corporation. All rights reserved.

PL/SQL Version 8.0.6.3.0 (Production)
Oracle Procedure Builder V6.0.8.21.0 Build #0 – Production
Oracle Virtual Graphics System Version 6.0.5.39.0 (Production)
Oracle Multimedia Version 6.0.8.25.0 (Production)
Oracle Tools Integration Version 6.0.8.17.0 (Production)
Oracle Tools Common Area Version 6.0.5.32.0
Oracle CORE Version 4.0.6.0.0 – Production
**********************************************************

awaiting ur reply..
gayatri

Reply
amit says March 16, 2008

Hi Gayatri,

Did you relink after copying the command ?
Also did you restart the application middle tier once you run copy command ?

Amit

Reply
Syed says June 10, 2008

PLease Let me Know The valid inputs while running adcfgclone.pl script
Specially
Target System database name
Target system base directory for source homes
Target system utl_file accessible directories list
Number of DATA_TOP’s on the target system
arget system RDBMS ORACLE_HOME directory
Do you want to preserve the Display set to null

Reply
Amit says June 10, 2008

Hi Syed,

Target System database name
Target SID you want

Target system base directory for source homes
Give TArget Oracle home directory

Target system utl_file accessible directories list
It will give List of directory and you need to select on. Usually it is /usr/tmp

Number of DATA_TOP’s on the target system
arget system RDBMS ORACLE_HOME directory
It is about number of location the dbf files are on the target. You have to count the number and then it will ask for the location too

Do you want to preserve the Display set to null
It will be the DISPLAY used globally by Oracle application. Default is Hostname:0.0

It will also ask vor Virtual Hostname and RAC also if it is there.
It will ask for the Port pool which you can give between 0-99

Let me know if this helps

Amit

Reply
lakshmikanthan says July 15, 2008

Hi all,
when am doing perl adcfgclone.pl dbTier
that time error was occured

please help me very urgent…………

ERROR:
RC-40201: Unable to connect to Database YTEN.

StackTrace:
java.lang.Exception: Cannot connect to database using DBUtil
at oracle.apps.ad.clone.ApplyDatabase
.checkDBConnection(ApplyDatabase.java:3382)
at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:524)
at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:328)
at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:304)
at oracle.apps.ad.clone.ApplyDBTier.(ApplyDBTier.java:154)
at java.lang.reflect.Constructor.newInstance(Native Method)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
at java.lang.Thread.run(Thread.java:479)

DEBUG: checkDBConnection out()
Executing runInstallDriver…
Started unzipping files…
UNZIP used: UnZip 5.51 of 22 May 2004, by Info-ZIP. Maintained by C. Spieler. Send
Verifying correctness of adcrdbclone.sql
Instantiating /test/yten/r02/oracle/ytendb/9.2.0/appsutil/template/adcrdbclone.sql to /test/yten/r02/oracle/ytendb/9.2.0/appsutil/install/YTEN_ebs/adcrdbclone.sql
Clustered Database: false
instantiate file:
source : /test/yten/r02/oracle/ytendb/9.
2.0/appsutil/template/adcrdbclone.sql
dest : /test/yten/r02/oracle/ytendb/9
.2.0/appsutil/install/YTEN_ebs/adcrdbclone.sql.bak
AC-00439: Creation of file /test/yten/r02/oracle/
ytendb/9.2.0/appsutil/install/YTEN_ebs/adcrdbclone.sql.bak failed
Raised by oracle.apps.ad.autoconfig.InstantiateFile
instantiate file:
source : /test/yten/r02/oracle/ytendb/9.2.0/a
ppsutil/install/YTEN_ebs/adcrdbclone.sql.bak
dest : /test/yten/r02/oracle/ytendb/9.2.0/ap
psutil/install/YTEN_ebs/adcrdbclone.sql
DEBUG : The destination file does not have write permission /tmp/adcrdbclone.sql
DEBUG : Changing the permission of the file failed
AC-00444: Unable to write to file: java.io.FileNotFoundException:
/test/yten/r02/oracle/ytendb/9.2.0/appsutil/instal
l/YTEN_ebs/adcrdbclone.sql.bak (No such file or directory)
Raised by oracle.apps.ad.autoconfig.InstantiateFile

setting permissions: /tmp/adcrdbclone.sql a+r
AC-00425: Setting permissions failed for file: /tmp/adcrdbclone.sql
Raised by oracle.apps.ad.autoconfig.InstantiateFile
AC-50401: Command: su root -c “cp
/tmp/adcrdbclone.sql /test/yten/r02/oracle/ytendb
/9.2.0/appsutil/install/YTEN_ebs/adcrdbclone.sql” failed
Raised by oracle.apps.ad.autoconfig.InstantiateFile
AC-00439: Creation of file /test/yten/r02/oracle/ytendb/9.2.
0/appsutil/install/YTEN_ebs/adcrdbclone.sql failed
Raised by oracle.apps.ad.autoconfig.InstantiateFile

StackTrace:
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(String.java:1591)
at oracle.apps.ad.util.SystemC
heck.setPermissions(SystemCheck.java:1250)
at oracle.apps.ad.clone.ApplyDatabas
e.runInstallDriver(ApplyDatabase.java:1001)
at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:580)
at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:328)
at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:304)
at oracle.apps.ad.clone.ApplyDBTier.(ApplyDBTier.java:154)
at java.lang.reflect.Constructor.newInstance(Native Method)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
at java.lang.Thread.run(Thread.java:479)

Thank you
lakshmi

Reply
lakshmikanthan says July 25, 2008

Hi everyone,
when i am running adcfgclone.pl that time error was occurred.
Please tell how to resolve this problem,am now very critical situation now.
i konw its java path error how to resolve this error

Creating the new Database Context file from :
/test/dten/w02/oracle/dtendb/9.2.0/appsutil/template/adxdbctx.tmp

The new database context file has been created :
/test/dten/w02/oracle/dtendb/9.2.0/appsutil/DTEN_ebs.xml

Log file located at /test/dten/w02/oracle/dtendb
/9.2.0/appsutil/clone/bin/CloneContext_07251058.log
Incorrect JAVA path:
No java executable at /test/dten/w02/oracle/dtendb/9.2.
0/bin/java or /test/dten/w02/oracle/dtendb/9.2.0/bin/jre

Running Rapid Clone with command:

perl /test/dten/w02/oracle/dtendb/9.2.0/appsutil/clon
e/bin/adclone.pl java=/test/dten/w02/oracle/dtendb/9.2.0/appsutil/clone
/bin/../jre mode=apply stage=/test/dten/w02/oracle/dtendb/9.2.0/appsutil/
clone/bin/.. component=dbTier method=CUSTOM

dbctxtg=/test/dten/w02/oracle/dtendb/9.2.0/a
ppsutil/DTEN_ebs.xml showProgress contextValidated=true

Beginning database tier Apply – Fri Jul 25 11:06:01 2008
Log file located at /test/dten/w02/oracle/dtendb
/9.2.0/appsutil/log/DTEN_ebs/ApplyDBTier_07251106.log
RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

ERROR while running Apply…

ERROR: Failed to execute /test/dten/w02/oracle/
dtendb/9.2.0/appsutil/clone/bin/adclone.pl

Please check logfile.

Thank you
lakshmi

Reply
Atul says July 25, 2008

Laksmi,

Check if java is in location specified in above directory. If not check if it is in source.

Did you run preclone steps and copy files properly.

Reply
lakshmikanthan says July 30, 2008

Thanks atul,
I have preclone had done properly

/test/dten/w02/oracle/dtendb/9.2.0/jave and /test/dten/w02/oracle/dtendb/9.2.0/jre
It has linking in this path.

but i could not change ownership of the link file.
also it is not inside of bin its available in before path of /test/dten/w02/oracle/dtendb/9.2.0/jave .

atul i have one doubt
should have link file available in this path.

/test/dten/w02/oracle/dtendb/9.2.
0/bin/java or /test/dten/w02/oracle/dtendb/9.2.0/bin/jre

could you understand wt i am telling ..

thanks
lakshmi

Reply
lakshmikanthan says July 30, 2008

hi atul,
how to change ownership of the link file.

thanks
lakshmi

Reply
lakshmikanthan says August 5, 2008

hi atul,

Really Thanks for remembering,
i have successfully finished cloning process.
i did preclone wrongly,both backup i had used in application tier user.

thanks
lakshmi

Reply
lakshmikanthan says August 5, 2008

Really i pleasure now.

Reply
Kiran says August 6, 2008

Atul,
We have downloaded the users/ responsibilities using the below syntax

=============================================
FNDLOAD apps/password 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct responsibilites.ldt FND_USER
=======================================
And we try to uplaod the resp.ldt file using FNDLOAD apps/pass 0 Y upload $FND_TOP/patch/115/import/afscursp.lct responsibilites.ldt FND_USER

It just stays there & getting the dead lock error in the alert log file

ORA-000060: Deadlock detected. More info in file

Could you pls let me know your thoughts in this

Reply
azodpe says November 13, 2008

Atul,
Very nice work !!!
I am new to APPS DBA field.
I have to perform my first clone in near future and getting ready for it.
What I am trying to decide is, whether to do full clone or just database refresh.
For that I need to compare software versions on both the source and target. HOW?
Is there any utility for this?

TIA,

Reply
» Add new Application Tier Node to Oracle Apps/E-Business Suite (11i/R12/12i) Online Apps DBA: One Stop Shop for Apps DBA’s says May 3, 2009

[…] tier to accommodate more application users or for resilience.     This document uses Rapid Cloneto add new Node to existing middle tier for […]

Reply
Uma says August 3, 2009

Dear Atul,

Thank you for sharing lot of information,its really helpful for beginners like us ..

I need your help for cloning R12 instance

Actually my Core is Apps Technical .. but in my new company iam the only person resposible for Oracle System..

DBA is new to me …

Rignt now i learn how to Shutdown the instance , take Back up and start instance.

I need to Know the Cloning steps and whats the procedure need to follow while cloning in detail.

Our PROD instance is Multi Node.. Can we clone the instance in single node ..if So whats the prcodure..

Or we have one Test instance clonned on 31-Aug-08 . Can we refresh this instacne with Current PROD instance data .. For this do we need to follow any separate procedure

Kindly help in this regards.

Thanks in Advance

Regards
Uma

Reply
Karthik says March 5, 2010

Hi Atul,

My oracle Apps version is 11.5.9 and Database is 9.2.0.6, in the front end when i click on the web reports it is throwing a error message.

this works fine in Production, but in clonned instance only it is not working.

error message –> Error: The requested URL was not found, or cannot be served at this time.
Incorrect usage.

Regards,
Karthik

Reply
Atul Kumar says March 5, 2010

@ Karthik

Check metalink note “230672.1 Cloning Oracle Applications Release 11i with Rapid Clone” under section Section 3: Finishing Tasks point 3 Update workflow configuration settings

and ensure that logfile_name and outfile_name column in FND_CONCURRENT_REQUESTS table is pointing to right location .

Reply
Karthik says March 8, 2010

Hi Atul,

i am able to see the proper nodes & location in FND_CONCURRENT_REQUESTS , even i submitted Active users and got the proper output.
Please help me on this issue, this occurs only in clonned instance.

Regards,
Karthik

Reply
Atul Kumar says March 8, 2010

@ Karthik,
Are you trying to view old concurrent request output and log file (submitted in source instance) from target cloned instance ?

If this is the case

Copy out and log file from source $APPLCSF location to target $APPLCSF Location

Run this sql from apps user and pass on request ID when prompted

SQL>select request_id, LOGFILE_NAME, LOGFILE_NODE_NAME , OUTFILE_NAME, OUTFILE_NODE_NAME from FND_CONCURRENT_REQUESTS where request_id=&request_id;

Reply
Karthik says March 8, 2010

Hi Atul,

the case is different, everything in Apps works fine except web reports which is causing problem.
Error: The requested URL was not found, or cannot be served at this time.
Incorrect usage.

when we click the web report link in HR module this error occurs.

Regards,
Karthik

Reply
Atul Kumar says March 8, 2010

@ Karthik,
Is this custom report or standard report ?

What is navigation path and which responsibility you are using ?

Reply
Karthik says March 8, 2010

Hi Atul,

this is custom report, where the report link is not pointing correctly or environment is not set properly, i have checked all the possible things, i need your help on this.

Regards,
Karthik

Reply
Ather Hussain says March 9, 2010

Dear Atul

How to do automate cloning in R12 and 11i

Thanks
Ather Hussain
atherhussain9@yahoo.com

Reply
shaik says February 14, 2011

Dear Atul,

I need to implement DMZ in Oracle R12.06 instance (Using a Reverse Proxy and an External Web Tier).

So please share the required doc’s if you have any?
please suggest me any doc’s/notes/sites.

Thanks and Regards

Reply
Atul Kumar says February 14, 2011

@shaik

Checxk these two metalink (now Oracle My Support) notes

380490.1 Document TitleOracle E-Business Suite R12 Configuration in a DMZ

726953.1 Case History: Implementing a Reverse Proxy Alone in a DMZ Configuration – R12

Reply
shaik says February 17, 2011

Dear OnlineappsDBA’s..!!!

Please share the screentshots wiht step by step for DMZ Configuration with R12.

Please share all the required inforamtion/doc’s

Thanks and Best Regards
Shaik

Reply
Ankur says July 21, 2011

Hi Atul

Can you please provide me Only DB refresh steps in 11i Application.

I dont want to copy MT.just DB refresh.

It will be great help.

Thanks
Ankur

Reply
ravi says January 31, 2014

Hi, Atul…

I have been following your website for a long time. I have a question…
could you list me the complete pre clone and post clone steps ?
I have joined the organisation recently and may need to clone this month..I need the common steps which every organisation usually do as pre-clone aND post-clone….
Thanks in advance…..ravi

Reply
    Atul Kumar says January 31, 2014

    @ Ravi,
    Which version of Apps – R12 or 11i ?

    Do you have access to My Oracle Support (earlier Metalink)

    Reply
sumanmora9 says September 29, 2015

can you please provide cloning of EBS where source server db tier at u01, appl at u02 and target server db – u03 and appl – u04. where target oracle home is at u02. please

Reply
Santhosh says December 15, 2016

Hello Autl,

I am planning to move 4 EBS database to another server. DB size of each database is 2.5 TB. OS of new server is same old server. Copying datafiles from one server another is time consuming. I would like use RMAN dupliacte and it is much faster. After RMAN duplicate DBID of database changes. Is EBS applications is dependent on EBS? If yes how it is dependent? We don’t want to clone the environments. Once database is migrated new server name is changed to old server so that we need to run auto config.

Reply
Add Your Reply