Cannot login to OBIEE 11g with correct user credentials

Scenario 1:

1. In your RPD, under Identity menu please check whether the user is listed or not.

          For ex. If I am trying to login using the user  'weblogic' , check whether weblogic user is listed           under Identity users in Identity.

     2.  If present, delete the user.

     3. Save the RPD and deploy it, if opened in offline mode

     4. Restart the OPMN services.

     5. if this is not your scenario or this doesn't resolve your issue, try Scenario 2.



Scenario 2:

1. Open the SQL developer and run the below query with Admin or SYS privilege

SELECT ACCOUNT_STATUS, USERNAME FROM DBA_USERS WHERE USERNAME  LIKE 'DEV%';
               (Please make sure your database schema for OBIEE starts with 'DEV')



     2.  Check the ACCOUNT_STATUS for the OBIEE schemas DEV_BIPLATFORM and DEV_MDS.



    3.   If the users are locked, run the below query

ALTER USER <username> ACCOUNT UNLOCK;



   4. If it shows an EXPIRED status, run the below query:

ALTER USER  <username>  IDENTIFIED BY <your_password>




   5. You can set the account status to NEVER EXPIRE and NEVER LOCKED state by running the below queries.

1.  Find the profile name of the user

             SELECT  USERNAME, PROFILE  FROM DBA_USERS WHERE USERNAME IS <username> ;

    2. Once you identify the Profile run the query,

             ALTER PROFILE  <profilename> LIMIT  PASSWORD_LIFE_TIME UNLIMITED;

             ALTER PROFILE  <profilename> LIMIT  PASSWORD_LOCK_TIME UNLIMITED;