OBIEE 11g: How To Reset Essbase Password After Changing the BIPLATFORM Passwords To Avoid Essbase Start Failures and ORA-28000 Errors (Doc ID 2006560.1)

Last updated on MARCH 10, 2021

Applies to:

Goal

You have changed your RCU database schema passwords in the databaes and in the JDBC connection pools via  How To Update OBIEE 11g Configuration When The Repository (RCU) Schemas Have Changed (Doc ID 1307835.1)

Ensure you have changed all the schemas, including bip_datasource, mds_owsm, EPMSystemRegistry and rtd_datasource (if used); otherwise, you may encounter 'ORA-28000: the account is locked' errors.

If the all the steps are not followed, then Essbase may fail to start via OPMN

This document describes how to change service Account Passwords for Essbase Studio or Essbase Server on OBIEE integrated environment.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.