OBIEE 12c Cloning the Production Environment to a Test Server.

Hamza Shakeel

Hi Guys,

I want to know is there a way to clone my OBIEE 12.1.2.0 from production to test like we do in Oracle EBS.

Please share a solution if you have done that.

Regards,

Farrukh Nasir Siddiqui

Hamza Shakeel

Hi Christian,

I want to clone the whole environment that is the database the catalog. I want to create two identical instances.

Regards,

Farrukh

Gianni Ceresa

984465 wrote:I want to create two identical instances.

I assume you mean from a content point of view and not the binaries etc.

So you installed 2 separate instances, one is PROD and the other TEST, you have content in PROD and you want that content to be "cloned" to TEST?

Did you look at the BAR file concept and important / exporting the instance in OBIEE 12c documentation?

Hamza Shakeel

Gianni yes.

Can you provide the link pls?

Thanks

Gianni Ceresa

The first results from Google:

https://gerardnico.com/dat/obiee/admin/12c/bar

https://docs.oracle.com/middleware/1221/biee/BIESG/configrepos.htm

Hamza Shakeel

Hi All,

Sorry to be noob, but I am new to this application.

What I failed to understand from google and other links was by using BAR will the database will be included in the bar file or only the data model, content model, and authorization model will be in it.

what is the best practice you guys use to transfer the whole db too?

expdp impdp commands?

Regards,

Farrukh Nasir

( Still a learner )

[Deleted User]

Nico references this support note: https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=2406648.1

So depending on your version you need to run exportserviceinstance / export_service_instance and import_bar / importarchive.

Regarding "transfer the whole db too": What's your goal for that? Which DB do you want to "transfer"?

Gianni Ceresa

In addition of what Christian said, if by "DB" you mean the source of data, of course it isn't included. OBIEE doesn't store data, the databases to which it connects to run analysis aren't part of OBIEE and the tool has a "read-only" approach with those, therefor they will never be exported or included into any OBIEE export/import.

Only the connections to those DBs will be included, so if you export PROD and import into TEST, your TEST environment will connect to the PROD database when running analysis.

You maybe want to clearly put on a paper what is your final process you have in mind, I don't think you plan to move PROD to TEST daily as it's more TEST supposed to come before PROD in a standard approach. Give us a better view of your final target and the answers will be more adapted to that

Charles M

Hi,

Take a look at this note: OBIA 11g: How to Refresh Test Environment With Production Database (Doc ID 2232718.1). It may help with this type of approach ...

Regards,

Charles

Hamza Shakeel

Hi All,

Thanks for your suggestions it is really helping me clearing my concepts.

Gianni Ceresa

By DB i mean the on my OBIEE server I have created a Oracle DB Schema. That contains all my data.

Now I want that schema containing all my tables and procedures and other objects to be accessible to the TEST instance i will be creating using the BAR.

Regards,

Farrukh

[Deleted User]

984465 wrote:By DB i mean the on my OBIEE server I have created a Oracle DB Schema. That contains all my data.Now I want that schema containing all my tables and procedures and other objects to be accessible to the TEST instance i will be creating using the BAR.

The source data being anaylzed can lie anywhere and will be accessible to OBI as long as your new server can reach it via a network connection. No need to duplicate it.