Sunday, November 12, 2006

Cloning OracleAS 10g + E-Business Suite Environments

Cloning an E-Business Suite environment is easy. Cloning an E-Business Suite environment that's been integrated with Oracle Application Server 10g is not quite as easy, unfortunately.

What's Cloning?

Cloning is the process of creating an identical copy of an already existing Oracle Applications system, including both the application-tier and database-tier.

Why Clone?

Reasons for cloning E-Business Suite environments include:
  • Creating a copy of the production system for testing updates
  • Migrating an existing system to new hardware
  • Creating a stage area to reduce patching downtime
One of our more risk-averse customers informed me that they may create up to 15 clones of an E-Business Suite environment between the TEST and PRODUCTION rollout phases.

The Easy Part

The E-Business Suite Release 11i was architected to support cloning. Experienced Apps DBAs know that the easiest way to create clones of their environments is to use the Rapid Clone utility introduced in 11.5.8. Creating a n E-Business Suite clone is as simple as copying your application-tier and database-tier files to the new target system and then running the perl-based Rapid Clone (adcfgclone.pl) utility.

The Not-So Easy Part

Oracle Application Server 10g was designed with different goals in mind. Consequently, there are no Oracle tools available today to clone an entire OracleAS 10g environment in a single step. In other words, OracleAS 10g does not have the equivalent of a Rapid Clone utility.

In the absence of a single turnkey tool like Rapid Clone, creating clones of new OracleAS 10g environments is a more involved process. Not impossible, mind you -- but definitely more involved.

Things get even more complicated when an E-Business Suite environment is integrated with Oracle Application Server 10g.

Nothing But Net

There are neither tools nor formal documents available from the Applications Technology Group or from Application Server Development, for cloning E-Business Suite environments that have been integrated with OracleAS 10g.

In short, there are no tools available to meet the comprehensive cloning requirements for combined OracleAS 10g + E-Business Suite environments today.

Warning: Trail Ahead Requires Exploration

If you're willing to experiment a bit, the following are general guidelines to point you in the right direction. Some customers and Oracle Consultants have used the following approaches to get the job done but have reported that there was some trial-and-error involved.

These are neither detailed nor comprehensive instructions. The following should be attempted only by system administrators who have a solid understanding of the principles outlined in Metalink Note 261914.1.

Cloning Scenarios

Assuming that you have an E-Business Suite environment that's been successfully integrated with OracleAS 10g, here are a few cloning scenarios that may apply to you:
  1. Create a clone of your Discoverer environment
  2. Create a clone of your Single Sign-On / Oracle Internet Directory environment
  3. Create a clone of your Portal environment
Creating a Clone of Your Discoverer 10g Environment

If you've integrated Discoverer 10g with your E-Business Suite environment but have not chosen the Single Sign-On option, then the cloning process is relatively painless:
  1. Use Rapid Clone to create a clone of your E-Business Suite, including the application-tier and database-tier. Remember that the E-Business Suite database already contains the Discoverer 10g End-User Layer.
  2. Create a fresh install of Discoverer 10g on your new server and point it to the End-User Layer in the cloned E-Business Suite instance.
Creating a Clone of Your Single Sign-On / Oracle Internet Directory Environment

If you've integrated Single Sign-On and Oracle Internet Directory 10g with your E-Business Suite environment, do the following:
  1. Use Rapid Clone to create a clone of your E-Business Suite, including the application-tier and database-tier.
  2. In your newly-cloned E-Business Suite instance, set the APPS_SSO_LDAP_SYNC profile option to "Disabled" at the site level (since there's no new Oracle Internet Directory instance to synchronize with yet).
  3. In your newly-cloned E-Business Suite instance, unlink all E-Business Suite users that were linked to the original Oracle Internet Directory 10g users (i.e. where FND_USER.USER_GUID is populated), since the those old links are no longer valid. Those E-Business Suite users will need to be linked to their corresponding accounts in the as-yet non-existent new Oracle Internet Directory instance.
  4. Create a fresh install of Single Sign-On and Oracle Internet Directory 10g on your new server.
  5. Assuming that you enabled bidirectional provisioning between the E-Business Suite and Oracle Internet Directory, do one of the following (but not all three):

    a) Redo your bulkload from the E-Business Suite into Oracle Internet Directory, reregister your E-Business Suite environment using the Bidirectional Provisioning Profile, and enable the APPS_SSO_AUTO_LINK_USER profile option, and set the profile option APPS_SSO_LDAP_SYNC back to Enabled at site level.

    b) Export your LDAP namespace from your original Oracle Internet Directory instance into an LDIF file, and then import the LDIF file into the new Oracle Internet Directory instance. Reregister your E-Business Suite environment using the Bidirectional Provisioning Profile, and (assuming that the Oracle Internet Directory accounts are identical to the E-Business Suite accounts) enable the APPS_SSO_AUTO_LINK_USER profile option, and set the profile option APPS_SSO_LDAP_SYNC back to Enabled at site level.

    c) Connect the original Oracle Internet Directory instance to your new Oracle Internet Directory instance via a connector, synchronizing the namespaces. Reregister your E-Business Suite environment using the Bidirectional Provisioning Profile, and (assuming that the Oracle Internet Directory accounts are identical to the E-Business Suite accounts) enable the APPS_SSO_AUTO_LINK_USER profile option, and set the profile option APPS_SSO_LDAP_SYNC back to Enabled at site level.
Creating a Clone of Your Portal Environment
  1. Portal requires a working Single Sign-On setup, so complete the previous section first.
  2. If you haven't already done so, create a fresh install of Portal 10g on your new server.
  3. Use the existing Portal 10g documentation to export your portal content and metadata from the original Portal instance. Import that content into the new Portal 10g instance.
  4. Reregister the OAF Web Provider from your new E-Business Suite instance in your new Portal instance.

No comments: