Monday, December 29, 2014

OBIEE 11g: Changing the RCU Schema to a new database

We are all well aware that before installing OBIEE11g, it is mandatory to install RCU because it creates repository metadata into the database. For some reason we might want to change the metadata repository to some other database,the question here is can we ?...Well yes, we can do it.

Say we have a  System 1 – OBIEE11g and database (orcl1) with RCU metadata repository and a System 2 – Database (orcl2).Now we want to move the RCU from orcl1 to orcl2  

Most importantly we can change the RCU repository metadata from one database to another database without impacting the current installed OBIEE11g environment.

Steps:
Firstly, ensure the RCU Repository metadata is created in the new database.

Logon to Weblogic Server Admin Console
Click on services


Click on Data sources



Click on bip_datasource and click on connection pool

Click on “Lock & Edit” button


Provide the new database details like host name, instance and password as shown above.

Do the same for all four data sources (EMPsystemregistry, mds-owsm, rtd_datasource), save and activate changes.

Logon to Enterprise Manager



Go to Business intelligence folder – coreapplication – deployment – scheduler.

Provide the new database details, apply and activate the changes.

Restart the services and run the analysis (analytics).

Note: The same steps can be followed when there is a name change of RCU database or hostname.

No comments:

Post a Comment