ORACLE BUSINESS INTELLIGENCE WORLD

Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles





  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 345,608 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

OBIEE11g – RCU Metadata Source Change

Posted by Santosh Kumar Gidadmani on April 21, 2012

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).

– Santosh

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

 
%d bloggers like this: