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.
But I can not find this screen on my version of EM12c.
Is there some point that I am missing?