by Robert Townsend
Database Specialists, Inc.
About Database Specialists, Inc.
Database Specialists, Inc. provides remote DBA services and onsite database support for your mission critical Oracle systems. Since 1995, we have been providing Oracle database consulting in Solaris, HP-UX, Linux, AIX, and Windows environments. We are DBAs, speakers, educators, and authors. Our team is continually recognized by Oracle, at national conferences and by leading trade publications. Learn more about our remote DBA, database tuning, and consulting services. Or, call us at 415-344-0500 or 888-648-0500.
Cloning Oracle Applications 11i instances can be a daunting task. Developers are constantly asking for refreshes of both the database and code trees. With the advent of Oracle Applications 11i and its myriad port numbers, meeting cloning schedules can be challenging to say the least. The good news is that once you have upgraded to Oracle Applications patch level 11.5.8, you have at your disposal an advanced method of cloning the application tree (called Rapid Clone) and you stand a greater chance of making your customers happy.
Many customer sites have implemented earlier versions of Oracle Applications11i, including 11.5.6 and 11.5.7. Many of these sites are satisfied with the functionality of the current release and have no interest in moving to a higher level. Others can't upgrade due to the combination of applications they have already installed. DBAs responsible for supporting these sites need not despair. Patch number 2926786 allows you to apply Rapid Clone on your application environment without upgrading the Oracle Applications modules. Rapid Clone requires the foundation to be upgraded to patch 2942559. As a side benefit, this patch includes AutoConfig, which manages system configuration.
It is advisable to read Oracle's Metalink note 230672.1, which details how to set up and run Rapid Clone, and note 165195.1, which outlines the use of AutoConfig. Of course, since we live in such rapidly changing environments, it is strongly recommended that you double check patch numbers and ensure that you have all prerequisites for your particular installation before applying any patches.
The Basic Steps for Cloning
After installing the Rapid Clone and AutoConfig patches, you are ready to clone an instance. There are ten basic steps involved. I have outlined them below:
Version 188.8.131.52 of the Oracle Universal Installer and Perl 5.005 should be installed and included in your path. Be sure to review your install logs after cloning to make sure there are no errors. After you have verified connectivity in the cloned environment, have a user navigate through the system to verify the clone is functional and complete.
Cloning an Oracle Applications environment is complicated, but Rapid Clone makes it a lot easier. The steps provided here are intended to give you an overview of the process. Be sure to read the Metalink notes cited and other available documentation for additional information.
About the Author
Robert Townsend is a Senior Staff Consultant with Database Specialists, Inc. and has over twenty years of professional experience as a DBA and programmer. He also has over ten years of experience in support of Oracle Financials and Manufacturing Applications running on Unix and NT platforms. You may contact Robert by email at firstname.lastname@example.org.
Still Looking for Help on this Subject? Get a Consultation
We would be happy to talk with you about our services and how our senior-level database team might help you. Call Database Specialists at 415-344-0500 or 888-648-0500 or fill out a free consultation request form.
If you'd like to receive our complimentary monthly newsletter with database tips and new white paper announcements, sign up for The Specialist.
Copyright © 2005 Database Specialists, Inc. http://www.dbspecialists.com