Oracle11G 控制台 ORA-28001

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

  1. processing
[oracle@localhost ~]$ sqlplus /nolog
SQL> conn / as sysdba;
Connected.
SQL> ALTER USER SYSMAN IDENTIFIED BY password ACCOUNT UNLOCK;
SQL> quit
  1. test
[oracle@localhost ~]$ sqlplus /nolog
SQL> conn sysman/password
Connected.
SQL>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值