Trouble shoot: while starting bi server- error ORA-28001:The password has expired

While starting OBIEE Server getting below error because of schema password expiry.

Trouble Shoot: check the schema status

Solution:

1. Connect as sysdba to the database.

C:\Users\Siry>sqlplus / as sysdba

2. Set the password’s life time to unlimited.

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

4. Set the password for user.

SQL> ALTER USER user_name IDENTIFIED BY password;

6. Unlock the user account.

SQL> ALTER USER user_name ACCOUNT UNLOCK;

8. Make sure your user is not locked by executing below query.

SQL> SELECT USERNAME, ACCOUNT_STATUS FROM DBA_USERS;