Translate

Thursday 3 May 2012

Shahed

OBIEE 11G moving RCU from one database to another

OBIEE 11g moving RCU to another Database



Export schemas MDS and BI_PLATFORM to a new database.


Then change the Following in the Enterprise Manager (EM) and Weblogic Console

Login to Weblogic Console (http://%3cserver%3e:7001/console/)

Navigate to Services – Datasources














Click on Data Sources



Select Lock & Edit button








Click on the Datasource required and

Change all 3 datasources or if you have more change them too the new database credentials.


Select Connection Pool tab

Change the URL|Driver|Properties|Password

Save Changes for Each Datasource as you are going along

Activate all changes and Restart services.



Login to Weblogic Enterprise Manager (http://%3cserver%3e:7001/em/)


Then go to Business Intelligence folder -> coreapplication.

Go to the Deployment tab and then to Scheduler tab.


Change the database field to point to the new Database and apply changes.

You are Done.... !!







Note: only a member of this blog may post a comment.

Blog Archive



About Authors

Shahed Munir

Krishna Udathu

Shahed and Krishna are Oracle / Big Data Experts