본문 바로가기

Server Story..../Windows Server

오라클 DB 락 해결방법


1) root 계정이나 system 계정으로 로긴한다

2) sqlplus '/as sysdba'

3) desc v$lock

4) select object_id from dba_objects where object_name = 'ST_IFINTERNET';

5) SELECT sid FROM v$lock where id1 = object_id;

6) SELECT sid,serial# from v$session where sid = sid;

7) alter system kill session 'sid,serial#';