死鎖的話

用select   *   from   v$session;找到已經斷線的session,   記下sid和serial#的值;    用alter   system   kill   session   'sid,   serial#'殺死該session.    

重起oracle

[[email protected] ~]# su oracle
[[email protected] root]$ sqlplus '/as sysdba'