Oracle 오류 코드

• ORA-00001Unique constraint violated
• ORA-00054Resource busy and acquire with NOWAIT specified or timeout expired
• ORA-00060Deadlock detected while waiting for resource
• ORA-01017Invalid username/password; logon denied
• ORA-01555Snapshot too old: rollback segment number too small
• ORA-01652Unable to extend temp segment by N in tablespace
• ORA-04031Unable to allocate N bytes of shared memory
• ORA-12154TNS: could not resolve the connect identifier specified
• ORA-12514TNS: listener does not currently know of service requested in connect descriptor
• ORA-00942Table or view does not exist
• ORA-01031Insufficient privileges
• ORA-00257Archiver error. Connect internal only, until freed
• ORA-01000Maximum open cursors exceeded
• ORA-00018Maximum number of sessions exceeded
• ORA-28000The account is locked
• ORA-01578Oracle data block corrupted (file #, block #)
• ORA-01722Invalid number
• ORA-02049Timeout: distributed transaction waiting for lock
• enq: TX - row lock contention대기: 다른 트랜잭션이 보유한 행 수준 락에 세션이 블로킹됨
• log file sync대기: 커밋 시 LGWR이 redo를 디스크에 플러시하기를 세션이 기다림
• db file sequential read대기: 단일 블록 물리 읽기, 보통 인덱스 또는 테이블 조회
• db file scattered read대기: 다중 블록 물리 읽기, 보통 full table scan 또는 index fast full scan
• buffer busy waits대기: 다른 세션이 이미 읽거나 수정 중인 버퍼에 대한 경합
• gc buffer busy대기(RAC): 인스턴스 간 전송 중인 cache fusion 블록에 대한 경합
• library cache lock대기: library cache 객체 핸들 경합(parse/DDL 직렬화)
• ORA-00604error occurred at recursive SQL level
• ORA-01438value larger than specified precision allowed for this column
• ORA-01400cannot insert NULL into (column)
• ORA-02291integrity constraint violated - parent key not found
• ORA-02292integrity constraint violated - child record found
• ORA-00979not a GROUP BY expression
• ORA-00918column ambiguously defined
• ORA-06550line/column PLS-... PL/SQL compilation error
• ORA-04068existing state of packages has been discarded
• ORA-01427single-row subquery returns more than one row
• ORA-12899value too large for column
• ORA-30926unable to get a stable set of rows in the source tables
• ORA-08103object no longer exists
• ORA-01843not a valid month
• ORA-14400inserted partition key does not map to any partition
• ORA-01536space quota exceeded for tablespace
• direct path read대기: buffer cache를 거치지 않고 PGA로 블록을 직접 읽는 세션
• latch: cache buffers chains대기: cache buffers chains latch 경합
• ORA-00955name is already used by an existing object (이름이 기존 개체에서 이미 사용 중)
• ORA-02449unique/primary keys in table referenced by foreign keys (테이블의 고유/기본 키가 외래 키에서 참조됨)
• ORA-01950no privileges on tablespace 'name' (테이블스페이스에 대한 권한 없음)
• ORA-01110data file N: 'path'
• ORA-16038log N sequence# M cannot be archived
• ORA-19809limit exceeded for recovery files
• ORA-00376file N cannot be read at this time
• ORA-12520TNS:listener could not find available handler for requested type of server (리스너가 요청한 서버 유형의 핸들러를 찾지 못함)
• ORA-28001the password has expired
• ORA-38029object statistics are locked
• ORA-00845MEMORY_TARGET not supported on this system (이 시스템에서 MEMORY_TARGET 미지원)
• ORA-27102out of memory
• ORA-04030out of process memory when trying to allocate N bytes (N바이트 할당 중 프로세스 메모리 부족)
• ORA-12537TNS:connection closed
• ORA-03135connection lost contact
• ORA-01033ORACLE initialization or shutdown in progress (ORACLE 초기화 또는 종료 진행 중)
• ORA-00600internal error code, arguments: [...]
• ORA-07445exception encountered: core dump
• ORA-01102cannot mount database in EXCLUSIVE mode
• ORA-29913error in executing ODCIEXTTABLEOPEN callout (ODCIEXTTABLEOPEN callout 실행 오류)
• ORA-19804cannot reclaim N bytes disk space from M bytes limit (M바이트 한도에서 N바이트 디스크 공간을 회수할 수 없음)
• ORA-00494enqueue held for too long by 'inst N, osid M' (enqueue가 너무 오래 보유됨)
• ORA-04021timeout occurred while waiting to lock object (객체 락 대기 중 타임아웃 발생)
• ORA-04061existing state of package/procedure has been invalidated (패키지/프로시저의 기존 상태가 무효화됨)
• ORA-01466unable to read data - table definition has changed (데이터를 읽을 수 없음 - 테이블 정의 변경됨)
• ORA-08176consistent read failure; rollback data not available (consistent read 실패. rollback 데이터 없음)
• ORA-00020maximum number of processes (N) exceeded (최대 프로세스 수(N) 초과)
• ORA-01113file N needs media recovery
• ORA-02393exceeded call limit on CPU usage
• ORA-12801error signaled in parallel query server Pnnn (parallel query server에서 오류 발생)