Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ORACLEBIEE 12C DEV_BIPLATFORM password expired

Received Response
335
Views
3
Comments
3789821
3789821 Rank 1 - Community Starter

I am using OBIEE 12C. I found that the connection pool was "suspended" since I was receiving the error "Pool biplatform_datasource is Suspended, cannot allocate resources to applications..". I logged in to the data sources and I tried to resume the connections. However, I received the error that the password used from the connection poll has  expired.

The password for DEV_BIPLATFORM has expired. As a result I logged to the  DB and I created a new password for the  user  DEV_BIPLATFORM.

  • ALTER USER DEV_BIPLATFORM IDENTIFIED BY <PASSWORD>;

Now I logged in to the system. I  navigated to bi -> Services -> Data Sources -> biplatform_datasource and fixed the connection parameters with the new password. I  moved to the  Monitor tab to do some tests and I received the error that the account is locked...

I  unlocked it using the SQL-Developer:

  • ALTER USER DEV_BIPLATFORM IDENTIFIED BY <PASSWORD>;
  • ALTER  USER DEV_BIPLATFORM account unlock;

Then I  noticed that after a while the account is LOCKED again! I thought that probably some service is trying to connect as BI_PLATFORM with the old password that I do not know. Needless to the  say that from the bi -> Services -> Data Sources -> biplatform_datasource->Monitor  tab I never succeeded to test  the  connection. I was able to test the connection pool from WebLogic where I received that the connection parameters are correct (of course after a while the account become locked again).

I Googled the problem and found this: http://bitechiepawan.blogspot.com/2013/10/devbiplatform-and-devmds-passwords.html

The author  suggests that I should also modify the Business Intelligence scheduler.

pastedImage_8.png

But I can not find this screen on my version of EM12c.

Is there some point that I am missing?

Answers