Oracle解锁,解决“ORA-00054:资源正忙”错误
一.处理步骤:
--1.获取被锁对象的session_id
SELECT session_id FROM v$locked_object;
--2.通过session_id获取v$session的sid和serial#
SELECT sid, serial#, username, oSUSEr FROM v$session where sid = session_id;
--3.终止相关进程。
ALTER SYSTEM KILL SESSION 'sid,serial';
二.示例:
SQL> select session_id from v$locked_object;
SESSION_ID
----------
141
SQL> SELECT sid, serial#, username, osuser FROM v$session where sid = 141;
SID SERIAL# USERNAME OSUSER
---------- ---------- ------------------------------ ------------------------------
141 41464 VC VC02\Admin
SQL> ALTER SYSTEM KILL SESSION '141,41464';
System altered
SQL> select session_id from v$locked_object;
SESSION_ID
----------
ORA-01172、ORA-01151错误处理 http://www.linuxidc.com/Linux/2013-06/86529.htm
ORA-00600 [2662]错误解决 http://www.linuxidc.com/Linux/2013-06/86528.htm
ORA-01078 和 LRM-00109 报错解决方法 http://www.linuxidc.com/Linux/2012-07/66044.htm
ORA-00471 处理方法笔记 http://www.linuxidc.com/Linux/2013-09/90017.htm
ORA-00314,redolog 损坏,或丢失处理方法 http://www.linuxidc.com/Linux/2013-09/90646.htm
ORA-00257 归档日志过大导致无法存储的解决办法 http://www.linuxidc.com/Linux/2013-09/90594.htm
更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12
本文永久更新链接地址:http://www.linuxidc.com/Linux/2014-05/101850.htm