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’)
- processing
[oracle@localhost ~]$ sqlplus /nolog
SQL> conn / as sysdba;
Connected.
SQL> ALTER USER SYSMAN IDENTIFIED BY password ACCOUNT UNLOCK;
SQL> quit
- test
[oracle@localhost ~]$ sqlplus /nolog
SQL> conn sysman/password
Connected.
SQL>