Oracle11G 控制台 ORA-28001

原创于 2023-03-16 21:38:09 发布 · 291 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #oracle #sql

当遇到ORA-28001错误或企业管理员无法连接到数据库实例时，问题可能是因为SYSMAN用户的密码已过期。解决方法是使用SQL命令解锁并更新该用户的密码。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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>