Oracle11G 控制台 ORA-28001

emergencysun

于 2023-03-16 21:38:09 发布

阅读量291

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 oracle sql

本文链接：https://blog.youkuaiyun.com/emergencysun/article/details/129600511

当遇到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>