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
Hi Christian,
I want to clone the whole environment that is the database the catalog. I want to create two identical instances.
Farrukh
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?
Gianni yes.
Can you provide the link pls?
Thanks
The first results from Google:
https://gerardnico.com/dat/obiee/admin/12c/bar
https://docs.oracle.com/middleware/1221/biee/BIESG/configrepos.htm
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?
Farrukh Nasir
( Still a learner )
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"?
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
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 ...
Charles
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.
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.
Hello Oracle Analytics Community, We are investigating a dashboard compatibility issue between Oracle Analytics Server (OAS) 7.6 and OAS 7.0. Some dashboards originally created in Oracle BI 12c can be opened in OAS 7.6 but fail to open after being archived and imported into OAS 7.0. During our investigation, we found the…
Hi all, We’re running into an issue with an on-premises Oracle Analytics Server 2026 integrated with Active Directory and hoping someone has seen this or knows if a patch is available. Environment: Oracle Analytics Server 2026 (on-premises) WebLogic 14.1.2.0.0, JDK 21, Oracle Linux DB-backed catalog (Oracle DB, BIPLATFORM…
We have a requirement Creating a Bar graph using Cost Center Tree hierarchy as prompt/filter. Created a Bar Graph using Cost Center Tree Hierarchy as a prompt. When I'm selecting values through selection steps from Cost Center Tree Hierarchy, the Bar Graph not refreshing as the selected values are not passing to Graph…
I have 2 tabs on the workbook that use the same dataset. I would rather not use 2 different datasets. Can I code an expression filter or something to remove those records?
Can you please help resolve this error. WebLogic version is 12c. OAS is 6.4