Oracle第一篇：解决连接数据库失败，提示ORA-28000:the account is locked的问题

查明哪个表或用户被锁了

select l.seesion_id sid,l.locked_mode,l.oracle_username,l.os_user_name,s.serial#,s.terminal,o.object_name,s.logon_time from v$locked_object l,all_objects o,v$session s where l.object_id = o.object_id and l.session_id = s.sid order by sid,s.serial#;

删除占用的session

sid和serial# 为上个语句查出来的具体值，需要替换下面语句的对应的参数值

alter system kill session 'sid,serial#'

解锁用户

alter user 用户名 account unlock