connect
sys/sa@orcl
as sysdba;
解除死锁
alter system kill session '144,69';
connect
sys/oracle@orcl
as sysdba;
--查看全部用户
select * from dba_users;
--部分用户的状态account_status 是EXPIRED & LOCKED 即 失效并锁定。可以先给用户解锁
alter user scott account unlock;
--再给用户修改密码
alter user scott identified by IES2010;
--用户scott的状态account_status已经变成open，可以连接操作用户了。
