Oracle11G 控制台 ORA-28001

ORA-28001 the password has expired (DBD Error:OCISessionBegin)

It seems that when you’re experiencing a ORA-28001, or if the enterprise manager is unable to connect to the database instance, the probable cause to the issue is that the SYSMAN user password has expired. Not a problem, you an can unlock this user with the example below (in this case, the password for the SYSMAN is ‘password’)

1. processing

[oracle@localhost ~]$ sqlplus /nolog
SQL> conn / as sysdba;
Connected.
SQL> ALTER USER SYSMAN IDENTIFIED BY password ACCOUNT UNLOCK;
SQL> quit

2. test

[oracle@localhost ~]$ sqlplus /nolog
SQL> conn sysman/password
Connected.
SQL>