Leave a Comment:
76 comments
Hi Subbu,
Its a good post .What is the significance of applying OUI22 Patch, 5035661 to every IAS Oracle Home and running perl OUIsetup.pl ?
ReplyHi vasanth,
Thanks,
OUI22 Patch is the prerequisite, if you want to clone using rapid clone. You have to upgrade the Oracle Universal Installer to Version 2. If you dont, you will get errors while running preclone on source system(while creating stage area for clone).
For more, please check the following note
perl adpreclone.pl dbTier returns “RC-00012: Error while creating cloning stage area” Note:392887.1
Regards,
SubbaRao
Hi,
Please can any body tell me , how to do a cloning without running adpreclone script in source system.
Thanks,
reddy
Hi Subba,
This is an excellent article…..thank you very much for your efforts and keep up the good work…
thanks,
Virendra Patel
Good one , I tried this and it worked perfectly. Thanks for posting this.
ReplyHi,
Please can anyone give me the syllabus for Oracle 10g OCP and procedure to do.
Thanks,
Reddy
Reddy,
Please check the following links
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=151
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_exam_id=1Z0_042
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_exam_id=1Z0_043
Those links contains engough information
Hope it helps, Good Luck
Regards,
SubbaRao
Hello SubbaRao,
Could you tell me how you copy all the files from source machine to the target machine? I’ve tried wget, but it didn’t work.
Thank you in advance.
Best regards,
Lilian
Hi Lilian,
==========================
take backup using tar in source system and copy the tar files to target machine.
for example, if /u05 is the application partition, as a root user take tar backup
#tar -cvf /backup/u05.tar /u05
copy the u05.tar to target machine using ftp or sftp and extract the files
#cd /u05
#tar -xvf /backup/u05.tar
=====================
apart from tar, you can also try the rsync command,if rsync is installed
===> NFS mount the source partion to target machine
# mount -f nfs source_system:/u05 /target_mount
#rsync -avz /target_mount /u05
================================
You can also use cpio with find
NFS mount /u05 of source system to /target_mount point
#mount -f nfs source_system:/u05 /target_mount
#cd /target_mount
#find . -print | cpio -pmdV /u05
========================
Hope it helps,
Good Luck,
Regards,
Subbarao
Hello Subbarao,
It’s very kind of you to have replied me so quickly.
Thank you very much.
Best regards,
Lilian
Hi
Can you please explain finishing task:
(2) Update Printer Settings
and another thing what all changes are required if I am not using standard ports
Thanks
ReplyHi,
Thanks much for the great write up. Helped immensly.
I’m running into one issue. When trying to launch forms from the Self Service Page i get an error.
Bad Request.
Your browser sent a request the server can not understand.
Any suggestions would be great!
Thanks
Hi,
is it possible to view the concurrent manager log/output files(in target system) from source after being cloned to target?
ReplyYes, copy log & out files to target instance from source and update table FND_CONCURRENT_REQUESTS for column values LOGFILE_NAME & OUTFILE_NAME to new location.
Check metalink note 230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
Under Section 3 in finishing tasks “Update workflow configuration settings”
Replyhi subbu,
Very nice post.
Can u please explain me where i can get information or logs related to :
In Oracle Apps 11i
1.When we submit URL request in browser to access the front-end of applications…
What exactly happens in the background…say which template or php from which location is first called…ie
i)self serviced applications
ii)web applications
iii)mobile applications..
What are all the files/process involved in getting the front-end till we get the login page..
Please help me with above…
I am really confused..
Check this for overview
for list of files/directories involved stay tunes to this post
http://onlineappsdba.com/index.php/2006/08/01/oracle-applications-request-flow
ReplyThanks Atul,
Your post is really helpful..
Could u please further give logfile location
of the actions involved in these processes..
Hi Rao,
Nice docuemnt…Actually i want to clone/restore production instance database to Test instance database.
We are taking RMAN backup daily…Can you tell me without shutting down the produciton instance how i can clone prod database to test database.
thanks
Regards
Bala
Hi Subbu,
Are you missing the step to copy RDBMS ORACLE HOME from prodserver to testserver?
Moses
ReplyHi moses,
In Stage 5,I mentioned to copy the Oracle Home to target /d02 Partition ( Target Server).
Regards,
SubbaRao
hi, thanks for such a nice article.
I have a question.
Suppose I have followed all the steps you mentioned in this article and set up the test system.
Now, one week later, I want to update my test system with the changes which took place in the production. My question is regarding the cloning of DB tier. Do I need to copy the entire system everytime(i.e. Oracle Home and the DBFs) or is it sufficient to copy the modified DBFs and new archive logs from production. Could you please explain how do i update my test system with the changes from production.
Thanks,
ReplyHi,
If you did not apply any database patches and Application patches in Production after first cloning, then you can just copy the All Database Files and Archive logs to target system and create the controlfile as specified above.
Regards,
SubbaRao
Hi Subba,
Do you have this document for windows ? I am planning to clone apps/db to test servers. Test servers already have a clonned copy but its very old. what is the best method to clone in this situation. I am doing this for the first time also the prod has millions of records. Do I need to have oracle installed on target systems
ReplyHi SP,
You no need to install oracle in target system. If you have hot backup of Production, just follow the above procedure or if you have Cold Backup of Production, please follow the given document, it is very easy to understand.
Cloning Oracle Applications Release 11i with rapid clone Note: 230672.1
If you have any doubts, post here, we will help you.
Regards,
SubbaRao
Hi subbarao/Atul,
i am doing cloning with the help of this document .
but here is nothing related with ORACLE_HOME.
should we copy RDBMS ORACLE HOME from source to copy or there is no need. adcfgclone will automatically create this?
please reply back asap.
waiting for your reply
thanx in advance
akshay
Hi Akshay,
If you are first time doing the Cloning in target system. You need to copy RDBMS ORACLE_HOME to Target System. Cfgclone will not create target oracle home.
If targe RDBMS oracle home is already there and you did not apply database patches, then no need to copy the RDBMS oracle home.
If you still don’t understand, please let me know.
Hope it helps,
Good Luck,
Regards,
SubbaRao
Hi subbarao/Atul,
Thanks for reply.
I was able to do with this document.
Now i have to write a script for autometed cloning.
But i am not able to understand from where i should start, if you gone through this type of scenerio previously then please help to write a shell script.
i have never done the shell script before.
waiting for your reply.
Thanks and regards,
akshay
ReplyHello Buddy,
Thanks a lot, it’s really a good document. I learnt a new thing. Thanks again.
Regards,
Sandeep
Dear Mr.Subbarao,
Can i get steps for automated cloning.
If possible some scheduling of cloning in R12
12.0.5
on HP-unix platform
and from multi node to single node
Hi friends,
i have a doubt on Step 6(Point 4):
perl adcfgclone.pl dbconfig
whether we need to create target context file?i believe the adcfgclone script only creates context file in normal cloning.so here the target context file referred is already created or we need to create?
ReplyHi Arun,
The command
perl adcfgclone.pl dbTechStack will create target context file based on the information you provided.
once this command is finised, you will have target contxt file created
to the below command, you have to provide the target context file created above
perl adconfig.pl dbconfig will update the database tables with the information of context file.
Hope it is clear.
Regards,
Subbarao
Dear SubbaRao,
Thanks for the information.By the way what is the Metalink doc ID for this Hotbackup Cloning.
Thanks and Regards,
Arun
Hi,
please refer the Appendix B of the below metalink document. ( Last One)
Cloning Oracle Applications Release 11i with Rapid Clone Doc ID: 230672.1
Today I have seen one document, it might be helpful.
Cloning Oracle Application 11i /R12 with Rapid Clone – Database (9i/10g/11g) Using Hot Backup on Open Database Doc ID: 760772.1
Good Luck,
Regards,
Subbarao
HI,
I need to do rman clonning from ASM to non asm instance as my PROD DB is running on ASM on r12 and the test , dev environments are on non ASM.
kindly can you tell me the steps for that
ReplyHI,
I have 2 node application r12 db is running on ASM and the backup is taken by RMAN can u tell the steps for doing clonning
Dear Subba,
Very nice artical.
Please tell me if I want to keep my Target system uptodate with source system on daily basis, what should I do further?
My data changes made in source system should be applied in target system.
Please suggest.
Regards,
Gaurav
@ Ranjani
Backups are divided into physical backups and logical backups.
1. Physical Backups are copies of physical database files (data files, control file, redologs) using operating system utility like cp, copy or oracle utility like RMAN
2. Logical backups contain logical data (tables, packages, stored procedure) that is exported using SQL commands and stored in a binary file using utility like import/export.
RMAN (Recovery Manager) is Oracle Tool/Utility for Physical Backup
ReplyDear Ranjani,
Please provide me E-mail id.
I will share RMAN docs which I have.
Hi subbarao garu,
very nice article, i learnt so mant things from this and doc id’s.
Thanks a lot sir.
ReplyPlease could have detail of cloning apps 11i on windows server environment..
thanks advance
hussain
Hi,
Please Help me….
We have PROD and UAT of 11i on windows 2003. Earlier UAT is cloned with PROD. Whenever any patch needs to be applied I am applying on both UAT and PROD. To reflect UAT with latest PROD, DBA is taking the COLD Backup and renaming the instance to UAT. Later applying adcfgClone on UAT for dbTier and appsTier. AutoConfig. This went on well 2 times. Everything worked out good.
Recently we did the same step but mistake is DB files not placed in the correct directory and unfortuantely we executed adcfgclone on dbtier and appsTier. Later we placed the DB files correctly and we executed adcfgclone on dbtier and appsTier. AutoConfig also. This time All are working fine but transaction Manager like ‘Po Document Approval Manager’ and Receiving Transaction Manager are not getting started. The error is
‘Transaction Manger could not create Pipes’.
Then I raised Oracle TAr and they suggested me to do cloning again but appsTier will do.
Now comes the main problem, as I am doing this first time cloning and luckily it is from PROD to UAT, I want to explore this oppurtunity. So started. I succesfully ran adpreclone on appsTier on two nodes(appsTier on two nodes on PROD). Now my big question is in Metalink notes they metnioned some directories. Is it Ok to copy entire APPL_TOP, COMMON_TOP from PROD to replace APPL_TOP,COMMON_TOP in UAT. And Other folder when I observed for OA_JRE_TOP..pointed to d:\oracle\prodcomn\util\java\1.4\j2sdk1.4.2_04.. but there is no folder availabe with 1.4\j2sdk1.4.2_04. So how to check this? What is the normal methodology in copying so much big files and replacing them on UAT?
Those who are reading till this point, I would like to thank you first for your patience and please help me with your hints.
As it is urgent, Kindly take some time to update on this asap and I will be really thankful to you people.
Regards
Sudha
@ Sudha,
Where yousee OA_JRE_TOP location pointing to d:\oracle\prodcomn\util\java\1.4\j2sdk1.4.2_04 (Is this in context file and if yes which context file , for UAT or Prod) ?
If you are not sure go to $APPL_TOP/$SID_hostname.xml and look for value OA_JRE_TOP
For copying on wondows simply copy+paste in windows .
ReplyHi Atul,
In the XML File it is mentioned as like this. d:\oracle\uatcomn\util\java\1.4\j2sdk1.4.2_04. The Folder is there. Thanks for pointing out.
I observed it wrongly as I didn’t query the latest record of this variable_name in fnd_env_context.
Please Answer.. Can I exactly copy all the APPL_TOP,COMMON_TOP,806_oracle_home, IAS Oracle_HOME from prod to UAT on both appsTier nodes?
Regards
Sudha
@ Sudha,
Yes can exactly copy from Prod to Test (Database should either be in hotbackup mode or down)
Hi,
As per the above note, we didn’t shut down the apps services before copying the application tier.
Please let me know if it’s not mandatory ?
Thanks,
Aman
Great tutorial SubbaRao, thanks.
I was wondering if you had steps for creating a new ORACLE DB & EBS instance from a hot backup copy of PROD?
We have a clean box that we’d like to use as a sandbox, but were unsure of how to create a new instance from hot backup copy.
PRD has 2 servers, 1 apps, 1 db, new instance would be DB & APPS on same box. Thank you! Bob
ReplyHi Subba,
It is a great tutorial.
Is it work on version 11.5.9 ???
Regards,
Wisnu
ReplyHi,
Thanks for the article.
I am facing an issue at step where your are running following command –
perl adcfgclone.pl dbconfig
Any idea what could be the reason? I checked the file adcrdb.sh is present and has 700 permission. It is solaris machine.
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
[INSTANTIATE PHASE]
AutoConfig could not successfully instantiate the following files:
Directory: /ora/product/10.2.0/db_1/appsutil/install/OIC4SI_au10qap2k0tels2
adcrdb.sh INSTE8
AutoConfig is exiting with status 1
RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyDatabase
XXXXX:OIC4SI>ls -lrt /ora/product/10.2.0/db_1/appsutil/install/OIC4SI_XXXXX | grep adcrdb
-rwx—— 1 oracle dba 4198 Aug 6 00:27 adcrdb.sh
-rwx—— 1 oracle dba 2721 Aug 9 19:51 adcrdbrdlg.sh
@ Anjul,
open adcrdb.sh file under
/ora/product/10.2.0/db_1/appsutil/install/OIC4SI_au10qap2k0tels2
Search for log and check log file in that location to see why adcrdb.sh failed ?
This command creates DB so check alert log of database in target instance.
Reply@Atul,
Thanks. The error was
– could not instantiate because of missing adcrdb.sh in template dir. Even if copy the file from some other instance, it was failing. Some process was removing template/adcrdb.sh file, not sure which one.
After lots of tries, I created the database manually.
Reply@ Muthu,
For prereq steps, please follow metalink (Oracle My Support) note 406982.1 Cloning Oracle Applications Release 12 with Rapid Clone
Is there any way to automate cloning procedure as in like writing shell scripts
ReplyNew to apps dba one small doubt on hot backup cloning, Don’t we need to copy the RDBMS home to the target server
Thanks,
Ravi Kumar
Hi Ravi,
If the patch levels are same at source and target, then no need of copying oracle home.
For Suppose, If you did not apply any patches in Source Oracle Home since last Clone (Where you have copied Oracle Home and did the clone), then, this time Copying Oracle Home is not required.
Please let me know, if you still have the doubts..
Thanks,
Subbu
@ Ravi Kumar,
As Subbu said, no if you already have Oracle Home in target location with same patchset as source database.
Yes, if you don’t have Oracle Home on target instance or patchset are different on source and target.
Reply@ Baqar,
To install R12 use installation guide from
http://docs.oracle.com/cd/B53825_08/current/html/docset.html “Oracle E-Business Suite Installation Guide: Using Rapid Install”
To install 11i use installation Guide from http://docs.oracle.com/cd/B25516_18/current/html/docset.html
“Technology Maintenance Oracle Applications Installation Guide: Using Rapid Install “
Replyhow to perform the post cloning activities, please help me
(1)Update Profile options
(2)Update Printer Settings
(3)Update the workflow configuration settings
(4)Verify the APPLCSF variable setting
(5)Update the session_cookie_domain value in icx_parameters
Replyhow to perform post cloning operations
(1)Update Profile options
(2)Update Printer Settings
(3)Update the workflow configuration settings
(4)Verify the APPLCSF variable setting
(5)Update the session_cookie_domain value in icx_parameters
ReplyPlease provide the info for below steps this would be very helpful for us
how to perform post cloning operations
(1)Update Profile options
(2)Update Printer Settings
(3)Update the workflow configuration settings
(4)Verify the APPLCSF variable setting
(5)Update the session_cookie_domain value in icx_parameters
Reply