Before installing OBIEE11g, it is mandatory to install RCU because it
creates repository metadata into the database. If you want to change
the metadata repository to some other database due to various reasons,
you can do it.
Scenario: System 1 – OBIEE11g and database (orcl1) with RCU metadata repository. System 2 – Database (orcl2). You 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).
Scenario: System 1 – OBIEE11g and database (orcl1) with RCU metadata repository. System 2 – Database (orcl2). You 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).
No comments:
Post a Comment