OBIEE 11g Support Schema Password Change (DEV_MDS/DEV_BIPLATFORM)

OBIEE 11g DEV_MDS/DEV_BIPLATFORM has been Changed.

I have seen several posts in OTN forum, Need to change passwords supported schemas for OBIEE 11g (MDS/BIPLATFORM).  Some times    it may even get locked and the password expiration default setting of the Oracle RDBMS 11g database.  But once you change this for any reason that is where the fun begins.  The password can be changed using below syntax.

Alter user DEV_BIPLATFROM  identified by  “NEW PASSWORD”

Ex: Alter User DEV_BIPLATFORM identified by  satya1234

Frequently users got locked in database due to this the Web logic services didn’t start up properly. Ultimately the resolve was to update the user account with an unlimited password lifetime grant similar to the PL/SQL code below.  This code below simply sets the default profile with which a user/schema may be associated.

  ALTER PROFILE DEFAULT LIMIT
  FAILED_LOGIN_ATTEMPTS UNLIMITED
  PASSWORD_LIFE_TIME UNLIMITED

But once this is done it actually causes issues with the WLS and OBI system’s ability to connect to those schemas,  Either way both the MDS schema required by Fusion Middleware Control (EM) and the BIPLATFORM schema that controls the OBI Agents..

We need to make changes in both Enterprise Manager(http://satya:7001/em) for Scheduler Configuration and Console http://localhost:7001/console ) for pointing BIPLATFORM and MDS to new schemas .

Login to http:satya:7001/console  and click on Services –> Data Sources .

We have to change the connection pool for the following schemas shown in screenshot.

 Click on Connection Pool

Here we have to give the following parameters .

Password: <Enter the New password)
Confirm Password:< password again)

Similarly do the same for the schema “mds-owsm”  that I highlighted in the previous screenshot .
Now, Stop all the OBIEE services and start it again .
In windows : Start –>All Programs –> Oracle Business Intelligence –> Stop BI Services/Start BI Services .

Scheduler:

 Login to em (http://localhost:7001/em). Navigate to Business Intelligence –> coreapplication and click on Schedular tab here you can find the TNS entry and User and password of the old schemas .

Click on Lock&Edit and change the TNS Entries as per ur database and enter User and Password  of BIPLATFORM .
 

Click on Apply and Activate changes .

After activated the changes you need to restart the all OBIEE services.

Thanks,

Satya Ranki Reddy