Sunday, January 9, 2011

Multi Node to Single Node Cloning - Oracle Apps 11i

Multi Node to Single Node Cloning – Oracle Apps 11i

With Oracle Applications 11.5.10 the ability to clone from a multi node to a single node system using rapid clone has now been certified.

Source System here refers to the multi node system to be cloned

Target System refers to the newly to be created single node system

Applications Version 11.5.10

The following Steps are required to be performed on the source system

1. Apply application tier patches using adpatch

Apply patch 4038964
Apply patch 4175764
Both the above patches are include in the consolidated update 2 or CU2 so in case you are on or later you can ignore this step.

2. Maintain snapshot information

Log in as the applications user on each application tier node and run 'Maintain Snapshot Information' by using adadmin.

3. Merge existing APPL_TOPs

Log in to the primary node of your application tier as the application user user and run:
$ cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]
$ perl appsTier merge
This will prompt you with option to merge secondary nodes
Now log in as the applications user to each of the secondary application tier nodes being merged and run:
$ cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]
$ perl appltop merge

4. Prepare the source system database tier.

Log on to the database tier of the source system as the oracle user and run the following commands:
$ cd [RDBMS ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]
$ perl dbTier
With this all the pre clone tasks on the source system have been completed.
The next set of tasks is required to be carried out on the target system that is the system on which you wish to place the merged single node instance.

5. Copy the following application tier directories

Copy the following application tier directories from the primary node of your source system to the target application tier node, retaining the original directory structure:
– [COMMON_TOP/util]
– [COMMON_TOP/clone>

6. Copy the required files for merging

Log in as the applications user to each of the secondary source nodes and recursively copy:
directory [COMMON_TOP]/clone/appl
- to -
directory [COMMMON_TOP]/clone/appl
on the target system node
Before proceeding with the next steps you must shutdown your oracle applications services and the database on the source system

  7. Copy the database tier file system

Log on to the source system as the database user
Copy the database (DBF) files from the source to the target system
Copy the source database ORACLE_HOME to the target system
After this you can now startup the database and applications services on your source system and release it for use.

8. Configure the target system database server

Log on to the target system as the database user and type the following commands to configure and start the database:
$ cd [RDBMS ORACLE_HOME]/appsutil/clone/bin
$ perl dbTier
This will prompt for new ORACLE_SID,ORACLE_HOME,Port Pool,JAVA_TOP and DATA_TOP give the appropriate values matching your target system
Once successful this should start your database and listener

9. Configure the application tier server nodes
The database and its listener should remain up before executing the next set of commands.
Log in to the merged APPL_TOP node as the applications user and execute the following commands:
$ cd [COMMON_TOP]/clone/bin
$ perl appsTier
This will prompt you new port pool for application tier services as well as new APPLTOP,COMMON_TOP,ORACLE_HOME and IAS_TOP
Successful completion of this task will bring up your application tier services on the target or the cloned node.

10. Post Clone Tasks
Log in to the target system application tier node as the APPLMGR user.
1.      Run the following tasks in adadmin for all products:o generate JAR files
o generate message files
o relink executables
o copy files to destination
2.      Change Apps,system,sysadmin passwords using FNDCPASS
3.      Update the following tables to clean up the source entries:
   - update wf_notification_attributes
- update wf_item_attribute_values
- update wf_systems
- update fnd_concurrent_requests log & our directories
- update fnd_concurrent_queues target_node names

4. update the profile options:  
   -Site Name & any custom profile options

1 comment:

  1. Very nice blog. Thanks. Speaking about technologies these days. All of the paperwork is left behind and now it is time to go virtual. Read about dataroom software and it will make sense to you.