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

Last updated on AUGUST 06, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.151020 to 11.1.1.9.170418 [Release 11g]
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms