Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
ORACLEBIEE 12C DEV_BIPLATFORM password expired

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?
Answers
-
Follow these steps - https://support.oracle.com/knowledge/Middleware/2320517_1.html
Also set the oracle user password to not expire to avoid having to do this again. Make Oracle password never expire
0 -
Many thanks for your reply Joel! I actually don't have access to oracle support but I think I fixed it the following way (I post it for other that also do not have access):
- WebLogic Domain (TopRight) --> Security --> Credentials
- oracle.bi.system
- datasource.biplatform
And changed the credentials there.
0 -
Best way to do, Reset the password with old password. if you are using new password you need update password for all data sources in console.
0