Oracle账号锁定以及修改密码篇

1.切换到Oracle

su - oracle

2.切换用户

conn {user}/{password}

如果出现ORA-28000: the account is locked

切换到sys

conn  /as sysdba

解除限制

alter user {user} account unlock;

；号要带上

3.切换成你要登录的用户

conn {user}/{password}
ERROR:
ORA-28001: the password has expired

重新输入新的密码就行