I have recently come across an issue where few of our BI components
went down and while stopping/restarting the services, It prompts for weblogic
User Name and Password and also failing to start the services.
I have started analyzing the AdminServer log files in OBIEE 12c where I found the issue details like
caused by java.sql.SQLException: ORA-28001: the password
Then I understand that the supporting schemas like MDS,
BIPLATFORM, IAU, OPSS and etc., accounts are expired in database. Here is the
steps that how I have resolved that.
Step1: Connect to oracle database as a sys user and run the below query to get the expired accounts.
Above query will result all the expired account details.
Above query will result all the accounts starting with the name 'DEV_'
If you see the above screenshot, 6 accounts are expired. Lets start fixing it.
Step2: First we have to get the existing password for the expired accounts. For that run below query.
This query will give the password for only DEV_BIPLATFORM account. same like, get the password for all the accounts.
Step3: Reset the password for the account
(Optional: If any account is locked)
Disable Password expiry
If you need to know the Profile name , then Please run the