What is Oracle I-setup

Oracle iSetup:

What is Oracle I-setup.
Oracle iSetup is a data migration and reporting tool
It is a part of the Oracle E-Business suite.
This tool consists of the Migrator and the Reporter:


What is Migrator:
The Migrator helps you to migrate data from one instance of the Oracle E-Business suite to another.

How to migrate data using I-setup:
•
Extract select data from an Oracle E-Business suite instance.
Transform select attributes of the extracted data objects as per your requirements.
Load data to the target Oracle E-Business suite instance.

What is Reporter in I-setup
Reporterhelps you to generate reports.
You can Generate reports on the extracted data.
You can Compare two sets of extracted data to identify differences.

How to setup I-setup in Oracle E-Business suite instance (Source and Target)

Source Instance – mysource
Target Instance – mytarget


Step 1:
Copy the $FND_SECURE/target.dbc file from target server to Source server under same location
Add target TNS information in Source tnsnames.ora file and verify following:
Tnsping target_sid

Step 2:

Login as sysadmin in Target Instance and add iSetup Responsibilty if not already there
Login as sysadmin in Source Instance and add Oracle iSetup responsibility to sysadmin

Switch responsibility to Oracle iSetup
go to Administration
and click on Instance Mapping
Click on “Create” at the Top left:
Enter the Name, DBC file name and Responsibility name of Target environment as shown below:
click on Apply



Verify Target entry on the screen:

Additional Changes..
Login to Target Application as sysadmin
Go to Concurrent Manager – Define
Query for Standard Manager
Click on Work Shifts and verify the sleep time is =< 30secs Login to Target Database server and change OPEN_CURSORS value in init.ora to 750
Bounce the Target APP and DB processes

You source and target are setup to use Oracle I-setup.

Pre-req, Please make sure that you have applied all the patches related to I-setup.