ORA-00054问题解决

进入sysdba用户；
执行

select l.session_id,o.owner,o.object_name from
v$locked_object l,dba_objects o where l.object_id=o.object_id;

找到sessionid

SELECT sid, serial#, username, oSUSEr,
terminal,program ,action, prev_exec_start
FROM v$session where sid = 找到的sessionid;

杀掉

alter system kill session '找到的sessionid,对应的Serial';