1.首先在sysdba 权限下,连接SH
conn sh/sh
此时报错
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
2.此时查询SH 用户的状态
select username,account_status from dba_users where username ='SH'
username ACCOUNT_STATUS
------------------------------ ------------------------------
------------------------------ ------------------------------
SH EXPIRED & LOCKED
此时的状态是 过期 锁住
3.解锁。修改密码步骤。
首先解锁
连接sysdba
(1).conn sys/sys as sysdba
connect
(2).alter user sh account unlock;
user alter
(3).alter user sh identified by hr;
User altered
此时就能连接SH了
(4).conn sh/sh
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30176559/viewspace-1609464/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30176559/viewspace-1609464/