APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 37,356 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    March 2009
    M T W T F S S
    « Feb   Apr »
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  
  • Archives

  • Authors

Single Node Cloning 11.5.10.2 on Win03 Enviornment

Posted by appsinfo on March 2, 2009

Single Node Cloning

In the last post we have discussed about what cloning is, now we will learn how to clone an ERP instance in a single node enviornment ie single node to single node cloning.

Operating Sytem Pre-Requsites:

  1.  VC++ 6.0
  2.  VC ++ Service Pack 5 or higher
  3.  MKS 8.0.
  4. GNU Make 3.77
  5. Zip utility 3.0.

Application Pre-Requisites

Single Node cloning is simple, how ever you need to install Rapid Clone and AutoConfig patches, then you are ready to clone an instance. 

 5414396 -11i RAPIDCLONE CONSOLIDATED FIXES JUL/2008

Developer 6i Patch

6372396–Latest TXK Autoconfig and Template Patch

Following are the basic steps in cloning the ERP 11.5.10.2 application in windows enviornment:

Before going to the below steps you need to run the enviornment file on database tier and application tier accordingly.

Apply the above patches follow the readme document carefully.

Step 1: Prepare for source database clone:

cd E:\oracle\devdb\10.2.0\appsutil\scripts\dev_mydomain

perl adpreclone.pl dbTier

Step 2:  Prepare for source application clone:

cd %COMMON_TOP%/admin/scripts/<SID>

perl adpreclone.pl appsTier

Step 3:  Copy the application tier file system and Data files:

Logon to the source system as APPLMGR and shut down the server processes.

Copy the following application directories from the source to the target node/file system or you can copy all the tops

  • DATA_TOP
  • RDBMS_TOP
  • %APPL_TOP%
  • %OA_HTML%
  • %OA_JAVA%
  • %COMMON_TOP%/util
  • %COMMON_TOP%/clone
  • %806 ORACLE_HOME%
  • %iAS ORACLE_HOME%

Shut down the source database and copy it to the target node/file system.

Restart the source database and source application server processes.

Step 4:  Configure the target system database sever:

cd %ORACLE_HOME%/appsutil/clon/bin

perl adcfgclone.pl dbTier

Step 5:  Configure the target system application tier:

cd %COMMON_TOP%/clone/bin

perl adcfgclone.pl appsTier

Note: If you are using Oracle Workflow, you must update wf_notification_attributes and wf_item_attribute_values.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: