ORA-00054、ORA-08002

https://docs.oracle.com/cd/B10501_01/server.920/a96525/e7500.htm

ORA-00054

resource busy and acquire with NOWAIT specified

1.查询

SELECT OBJECT_NAME AS 对象名称, S.SID, S.SERIAL#, P.SPID AS 系统进程号
  FROM V$LOCKED_OBJECT L, DBA_OBJECTS O, V$SESSION S, V$PROCESS P
 WHERE L.OBJECT_ID = O.OBJECT_ID
   AND L.SESSION_ID = S.SID
   AND S.PADDR = P.ADDR;

2.kill

alter system kill session 'SID,SERIAL#'

 

ORA-08002

ORA-08002 sequence string.CURRVAL is not yet defined in this session

Cause: Sequence CURRVAL has been selected before sequence NEXTVAL.

Action: Select NEXTVAL from the sequence before selecting CURRVAL.