如何消除OEM中ORA-28000: the account is locked 的提示?

显示全部楼层 · 2005-10-30 17:05:33

应是是帐户锁定.
用SYS,SYSTEM,SYSMAN登录都是这样.
这样操作:
在CMD中启动SQLPLUS;
用SYSTEM登录:
执行:
ALTER USER SYSMAN ACCOUNT UNLOCK;
显示用户已更改.

打开http://fanzy:5500/em (fanzy是主机名称)
启动,登录是用SYSTEM.
依然是:
SQLException

ORA-28000: the account is locked

启动/关闭:确认

当前状态 open
操作关闭 immediate
是否确实要执行此操作?
***
哪里错了?

千问 · 2005-10-30 17:05:33

http://blog.itpub.net/post/493/15071
please refer my blog. I posted an article which described this issue.
The key point is that:You might changed password for SYSMAN
in SQLPLUS, but EM doesn't identify your modification.
好久没有更新了，明天准备更新一下，呵呵!