Replicate or clone OBIA 11 to new server

Question

Hi,

How to migrate or clone entire OBIA 11 setup from one server to another server. DB also will be migrated to new server.

Which strategy will be appropriate.

1. Cloning DB & APP tier

2. Setup New instance & do import/export from old instance

If anyone did it pls share high level steps.

Thanks in advance.

Charles M · Answer

Hi -

I worked on a similar task to replicate our entire OBIA (version 11.1.1.10.1; including ODI) instance to a different server. In this case the target database was already existing, and synched-up with the source database. So, I can't speak to the database portion of your question - I would say to consult your DBA/Infrastructure team on your options.

In terms of the application tier, I used a combination of some MOS notes and product documentation to work it out. It wasn't easy, and I encountered many issues. There are plenty of manual tasks and edits to do. Ultimately, I wound up completing about 95% of it. I did have an issue with the ODI agent on the target side. I wasn't able to get it resolved during the time we had allocated to this. I believe it was similar to this: OBIA 11g oraclediagent Not Starting After Cloning Getting ODI-10163: This OPSS user BIAppsSystemUser has different GUID than the one found in Oracle Data Integrator repository (Doc ID 2014749.1).

Honestly, you may be better of doing a fresh install of all the components, including the database (I believe this is the recommended method from Oracle for Bi Apps). Then, bringing back any customizations.

Also, there are some other community posting for this topic too. Maybe, do a quick search for 'clone/cloning' in the forums.

Here are some references if you decide to take this route:

OBIEE 11g Test-to-Production (T2P) / Clone Procedures Guide (Doc ID 1625533.1)

OBIA 11g How to Migrate Configurations and Customizations from Development to a Test or a Production Environment (Doc ID 1984269.1)

How To Move ODI From Test Environment To Production Environment Using Cloning (T2P) (Doc ID 2011064.1)

https://docs.oracle.com/middleware/11119/core/ASADM/testprod.htm#BABGJGCF

https://docs.oracle.com/cd/E28280_01/core.1111/e10105/testprod.htm#ASADM339

I will point out one thing that was particularly frustrating. On the last step of 1625533.1, there is an typo in the note. I have informed MOS of this ...

The 'domainHostName' parameter should not point to the source. It should be the target. > https://docs.oracle.com/cd/E28280_01/core.1111/e10105/clone.htm#ASADM318

Regards,

Charles

SriniVEERAVALLI · Answer

See how that works with Cloning!