Leave a Comment:
91 comments
thank you so much for writing this appsdba blog.when are you posting clonning interview question?
appreciate your response
Replyhey atul,
This template rocks…so does its content.can I nick it?
cheers
anil passi
Hi
Please explain what profiles, Printer settings; Workflow has to be updated after cloning
Thanks&Regards
Karthi
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
ReplyHi 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.
ReplyHey Atul,
Great material and easy t understand
Regards,
Raghav
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
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
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
ReplyThis 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
ReplyHi,
I’ll check on this RO tablespace & get back to you .
Atul
ReplyHello 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.
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.
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.
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
ReplyPosting 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.
ReplyHi 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)
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
ReplyHi 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
ReplyWhevever 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.
ReplyHello 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?
ReplyHello 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.
ReplyOgutu,
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
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~
Ivan , can you elaborate what is EBSSE ?
Specially SE bit in last
ReplyHi 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~
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
ReplyHi 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
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
Hey Atul,
Do you have a presentation on Cloning..?
If you have one could you forward on sanjay203@yahoo.co.in
Sanjay
Replyhi 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
Replyhi 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
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
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
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
ReplyFor 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
Replyhi 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
ReplyYaseen,
Update this in forum http://teachMeOracle.com/forum with log from post clone.
Atul
ReplyHi 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.
Replythanks My sir, can you send me details steps about cloning
Really, thank you
ReplyWe 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
ReplyUse same doc as mentioned to clone 11i
Share what issues are facing while cloning R12 with RAC
ReplyYou 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
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
Replyhai.. 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..
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..
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..
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
Replyhai..
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..
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…..
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
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
Replyhi
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
Replyhi
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.
Hi Srilatha,
I go with the Sarfaraz Commnets above. Pleae apply the above mentioned patch.
Amit
ReplyHi 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
Replyhai.. 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
Hi Gayatri,
Did you relink after copying the command ?
Also did you restart the application middle tier once you run copy command ?
Amit
ReplyPLease 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
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
ReplyHi 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
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
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
hi atul,
how to change ownership of the link file.
thanks
lakshmi
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
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
ReplyAtul,
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[…] tier to accommodate more application users or for resilience. This document uses Rapid Cloneto add new Node to existing middle tier for […]
ReplyDear 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
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
@ 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 .
ReplyHi 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
@ 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;
ReplyHi 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
@ Karthik,
Is this custom report or standard report ?
What is navigation path and which responsibility you are using ?
ReplyHi 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
Dear Atul
How to do automate cloning in R12 and 11i
Thanks
Ather Hussain
atherhussain9@yahoo.com
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@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
ReplyDear 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
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
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
@ Ravi,
Which version of Apps – R12 or 11i ?
Do you have access to My Oracle Support (earlier Metalink)
Replycan 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
ReplyHello 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