Changing MDS and BIPLATFORM schemas

1. Oracle Database
2. OBIEE Server
3. OBIEE RPD
4. OBIEE Maps
5. Weblogic
6. Errors
7. Upgrade
8. Customize
9. Patch

This is a bit tricky.

In case your database policy does not allow you to unlock or alter the MDS or BIPLATFORM schemas using the old password you will need to follow the steps give below to get the services back up again.

POINT TO BE NOTED:

The real problem starts after the MDS, BIPLATFORM schemas are updated with new password. The WSL and BI System will not be able to communicate to these schema as it still refer the old passwords!


The impact of this change is pretty clear and simple. Nothing will work as usual! :)




STEPS to FIX MDS password

1. Login to the Fusion Middleware Control (EM)
2. Expand WebLogic Domain > bifoundation_domain
3. Under the bifoundation_domain, expand the WebLogic Domain dropdown and select JDBC Data Sources

1. 
2. Select mds-owsm from the list and click Edit
   
3. Under the connection properties tab change the password and click the Apply button (upper right of form)
   
4. Restart OBI Services

STEPS TO FIX BIPLATFORM PASSWORD

1. Login to the Fusion Middleware Control (EM)
2. Expand Business Intelligence > coreapplication
3. Click on the Deployment tab
4. Click on the Scheduler tab
5. Click the Lock & Edit Configuration button
6. Once the option to edit the scheduler metadata becomes available enter the new password for the schema/user
   
7. Click Apply
8. Click Activate Changes
9. Just restart the scheduler. Or, bounce OBI Services just to be ready and steady if so desired.

Thanks,

SHARE SHARE SHARE

About test