Cloning is the process of creating an identical copy of an already existing Oracle Applications system. Cloning is a regular part of an Apps DBA's responsibilities, so you're probably already familiar with the latest Rapid Clone utility and its predecessor, adclone.pl, the original AD Clone Utility. If you've used those tools in the past, you likely also know that overall cloning process requires some user intervention for things like the APPS password and so on.
A customer recently asked whether the following cloning process can be fully automated, so that no user intervention is required at all:
- Shut down the PROD environment for both the application server and database tier
- Do an offline preclone of both tiers
- Copy both tiers to another server (the sandbox environment)
- Restart the PROD environment
- Do an offline postclone of both tiers for the sandbox environment
- Start the sandbox environment
The management pack automates the cloning of both Release 11i (11.5.10 with ATG RUP4) as well as Release 12 environments. You go through a step-by-step interview process to configure the clone routine once, and then you can reuse the cloning routine as many times as you wish. In addition, the cloning routing can send out a notification if it failed.
Very slick. If you've had a chance to try this, I'd be interested in hearing about your experiences with this new feature.
References
- Application Management Pack for Oracle E-Business Suite Now Available
- Cloning Oracle Applications Release 11i with Rapid Clone (Metalink Note 230672.1)
- Cloning Oracle Applications Release 12 with Rapid Clone (Metalink Note 406982.1)
Comments (14)
Hi, John,The out-of-the-box cloning capabilities of the Apps Management Pack use the standard Rapid Clone utility. Rapid Clone itself requires the E-Business Suite environment be brought down before the extraction process (the process that grabs data from the Source system) begins. The Application Management Pack affords enough flexibility and
customization options that you can hook your own steps into the cloning
process. If customers have their own cloning tools or scripts that support hot cloning, those can be hooked into a customized process and automated by the Application Management pack. Regards,Steven
Posted by Steven Chan | April 5, 2007 12:02 PM
Posted on April 5, 2007 12:02
Hi Steven,
While this feature certainly is cool in principle, if it really requires a shutdown of the production instance, I question its practical value. I can't see incurring the downtime just so I can avoid a couple of manual intervention steps.
Or are steps 1) and 4) part of the customers' requirements, not a limitation the Apps Management Pack feature? If the management pack can handle fully automated "hot" cloning, then I might be pestering my manager to find room in the budget for Apps Management Pack licenses. :)
Posted by John Piwowar | April 5, 2007 1:33 PM
Posted on April 5, 2007 13:33
Hi Steven
I dont see a formal document talking about cloning when ASM is involved for DB Tier. Can you point me to any metalink doc available.
Thanks
Suresh
Posted by suresh | May 21, 2007 2:10 PM
Posted on May 21, 2007 14:10
Hi, Suresh,I know that the cloning-related documentation for RAC/ASM for Release 12 environments is still being worked on right now. I'm trying to get confirmation of our plans for 11i documentation, too. I'll post pointers to that information when I get my hands on it.Regards,Steven
Posted by Steven Chan | May 25, 2007 2:34 PM
Posted on May 25, 2007 14:34
Hi Steven,
.
I tried out cloning possibilities through OAM on R12 as well as on 11i and have to admit that at this moment solution is unsteady.
I was not able to clone R12 since custom s_tools_oh , s_at and s_weboh_oh is not supported. Only manual way with parse file works for R12. As far as I know RUP4 will address this issue.
Besides that there are problems with file permissions in stage area and problems with automatic responses (for example see Note:412044.1 for tracking bugs 5741411 and 6044708)
I am really looking forward to try out Apps Management Pack with roll-up patch 2.0.1 since idea of cloning automation out of box is quite good.
.
Would appreciate if You share more info about others experience with cloning 11i and R12 through OEM.
.
Br
Uldis
Posted by Uldis Augulis | November 29, 2007 3:48 AM
Posted on November 29, 2007 03:48
Hi, Uldis,I don't have a lot of visibility into customers' experiences with OEM, but I'd be happy to pass your feedback on to that team. If you have specific Service Request numbers that have more details about the issues you've noted, I can pass those along, too.Regards,Steven
Posted by Steven Chan | November 29, 2007 12:28 PM
Posted on November 29, 2007 12:28
Hi,
Do we need to rename directories in target node which contains host system's SID and HOSTnames ?
Is there any utility for doing that task ..
Ragards
Ram
Posted by Ram | July 22, 2008 12:42 AM
Posted on July 22, 2008 00:42
Hello Ram,
For 11i, you do not need to explicitly rename these directories as new ones are created for the target node SID and HOST. Although the clone does some tidying up, the original source node directories will still exist but can be manually removed if required (or just ignored otherwise).
With R12, there is no need to copy $INST_TOP so will not have the source system directories on the target node and the clone will create the target system directories as needed
regards
Mike
Posted by Mike Shaw | July 22, 2008 4:47 AM
Posted on July 22, 2008 04:47
Hi!
On this year HROUG (Croatian Oracle Users group) I will have workshop with name "One click clone" (http://www.hroug.hr/hr/hroug_konferencija/u_pripremi/hroug2008_rovinj/predavanja_radionice_demogroundi/radionice/one_click_clone).
I will show how fully automated clonning of Oracle EBS 11.5.10.2 On Linux RH4 is performed without shutting down nor database nor application part.
Scripts will be public on that site after the conference. I invite all of interested to visit it or to contact me on funky_disco_freak@yahoo.com.
Regards,
Damir Vadas
Posted by Damir Vadas | September 9, 2008 8:36 AM
Posted on September 9, 2008 08:36
How to share these scripts here with other Oracle APPS DBA?
Posted by Damir Vadas | October 10, 2008 4:02 AM
Posted on October 10, 2008 04:02
Hi, Damir,
I can't post your scripts on my blog, but you're welcome to upload them to the public file-sharing site of your choice and then announce their availability here:
OTN "Managing Oracle Applications" forum
http://forums.oracle.com/forums/forum.jspa?forumID=504
Regards,
Steven
Posted by Steven Chan | October 10, 2008 11:52 AM
Posted on October 10, 2008 11:52
Hi!
THX for suggestion.
http://forums.oracle.com/forums/thread.jspa?messageID=2810511�
Looking forward for comments...
Posted by Damir Vadas | October 10, 2008 4:39 PM
Posted on October 10, 2008 16:39
How to share these scripts here with other Oracle APPS DBA?
-------------------------------------------------------------------
tuyen dung | viec lam | tim viec
Posted by nhat truong | August 19, 2009 1:11 AM
Posted on August 19, 2009 01:11
Nhat,
Damir has shared his scripts in the link shown in his Oct 10, 2008 comment above.
Regards,
Steven
Posted by Steven Chan
|
August 19, 2009 11:55 AM
Posted on August 19, 2009 11:55