Symptom: OPMN coreapplication fails to start even though you are able to login to the Enterprise manager and the console.
Some of the log entries will be as follows:
Received exception while creating connection for pool "EPMSystemRegistry": ORA-28001: the password has expired>
MDS-01376: Unable to get database connection from data source "mds-owsm" configured with JNDI name "jdbc/mds/owsm".
The DBMS driver exception was: ORA-28001: the password has expired
Error Message From BI Security Service: WSM-06162 The policy referenced by URI "oracle/wss_username_token_service_policy" could not be retrieved as connection to Policy Manager cannot be established at "t3://<SERVERNAME>:7001" due to invalid configuration or inactive state.
CAUSE: This error occurs when the MDS SCHEMA AND BIPLATFORM Schema is not accessible or is locked.
SOLUTION:
1. Check the RCU installed DB tables - eg: DEV_BIPLATFORM / DEV_MDS by using the below db statements
select username,account_status from dba_users;
output :
DEV_BIPLATFORM OPEN
DEV_MDS expired/locked (or just expired)
2. if it shows the "expired" here is the problem then. here is the solution
ALTER USER ACCOUNT UNLOCK;
Note :
If the password has expired make sure to revert it back to the password you used during installation.
ALTER USER DEV_MDS IDENTIFIED BY Oracle11g;
Restart the services.
3 comments:
I have performed the ALTER USER DEV_MDS IDENTIFIED BY Oracle11g;
still when i restart the services it is showing the same error, can I have your number so that I'll call you directly, please
Can you please paste the exact error that you are getting?
I'm able to log onto enterprise manager and console with the same password which I'm trying for analytics, but I'm not able to log onto analytics. In sql developer when I ran "select username,account_status from dba_users;" it is showing the password has been expired for DEV_BIPLATFORM and DEV_USER. And when I click on START BI services it is showing that "account has been locked" in Command prompt.
Post a Comment