OBIEE platform DBUSER password reset

Often you may find that when you come to start and OBIEE environment, it may fail with errors relating to the fact the OBIEE platform and mds accounts are either locked, or the stored passwords within the OBIEE configuration are out of step with whats held in the database.  You may see errors in the bi_server.log file such as :-

creating connection for pool “rtd_datasource”: ORA-28000: the account is locked

<BEA-001129> <Received exception while creating connection for pool “mds-owsm”: ORA-28001: the password has expired

When querying the DBA_USERS table within the database, you may discover the accounts are locked/expired :-

SQL> select username,account_status from dba_users where username like ‘DEV%';
USERNAME                    ACCOUNT_STATUS
—————————— ——————————–
DEV_BIPLATFORM  EXPIRED
DEV_MDS                        EXPIRED

If you do know the password, you can get away with reseting the account with the same password i.e.

alter user DEV_MDS identified by <original_password>;

alter user DEV_BIPLATFORM identified by <original_password>;     

You may not know the password, so you may end up having to reset the password as listed below.

alter user DEV_MDS identified by DEV_MDS;
alter user DEV_BIPLATFORM identified by DEV_BIPLATFORM;

Once reset, you will beable to test via a SQL * Plus connection.
However the various connections configured within OBIEE will need to be reset before you can successfully restart the OBIEE environment. The following steps below take you through the areas you will need to reset the DEV_MDS and DEV_BIPLATFORM password if you have had to reset the password with a new password in the steps above

Login to the Web Logic Console i.e. http://hlcdb01:7001/console
navigate to bifoundation_domain –> Services –> Data Sources. Check each data source for where the passwords are storeed typically you will need to modify these :-

bip_datasource > connection pool tab, reset the password for DEV_BIPLATFORM
EPMSystemRegistry > connection pool tab, reset the password for DEV_BIPLATFORM
mds_owsm > connection pool tab, reset the password for DEV_MDS

Click save and apply, a full restart will be required once all steps are performed.

Next step is to Login to the OBIEE Enterprise Manager Console i.e. http://hlcdb01:7001/em. You will need to reset the stored password for the NQS Scheduler, otherwise the service will fail to start

• Expand “Business intelligence” menu on the left;
• Click the “Deployment” tab;
• Click the “Scheduler” tab under deployment;
• Click “Lock and Edit Configuration” button;
• Set the password and hit “Apply”;
• Click the “Activate Changes” button;

Once all new passwords have been applied, a full restart, and all services should now start successfully