obiee11g bi_server1 state changed to admin mode when started.

Error: when started obiee bi_server1 state changed to Admin mode.

Error in log file: The Network Adapter could not establish the connection

Cause: bi_server not able to connect to the database.

Solution: Check the users that expired and locked in DB using the query.

Connect to your database from obiee installed machine using sqlplus

(sqlplus user/pass@hostname:1521/orcl)

select username, account_status from dba_users where ACCOUNT_STATUS LIKE '%EXPIRED%';

and check whether DEV_MDS or DEV_BIPLATFORM is there or not.

If these users are locked unlock the user.

In my case SYSMAN account is expired so unlock the user and restart OBIEE.

Connect to sqlplus using nolog : >sqlplus /nolog

after that unlock the user using below mentioned query.

SQL> conn / as sysdba

Connected.
SQL> alter user sysman identified by [new password]

2  /

User altered.
SQL> alter user sysman account unlock;

User altered.
SQL> exit