How To Move The OBIA and ODI 11g Repositories To a New RDBMS Instance or Schema
Last updated on FEBRUARY 28, 2018
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.1 and later
Information in this document applies to any platform.
Having the database and BI Application servers, both running on the same machine. Now planning to move the database to a new server or a new instance or a new schema. The goal is to point the existing BI Apps to the new DB target.
The process requires a full and working installation of BI Apps in the original machine/DB/schema. From now on called 'Source Server'
- Have a complete Installation of BIAPPS in Source Server.
- Need to move only the schemas to another server. From now on called 'Destination Server'.
- WLS Installation will remain on Source Server.
Good Practices for Performance:
The process should only move OBIA Components IO schema, OBIA Components Repository schema, and ODI Repositories schema. The OBIA DW schema should "always" remain on the same server where the ODI Agent is for performance purposes. When the Agent populates the target, it better not have to use the Network anymore, and if the DW is also moved, then the Agent should move with it.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms