Oracle hata kodları

• 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 contentionWait: oturum, başka bir transaction'ın tuttuğu row-level lock'ı bekliyor
• log file syncWait: oturum, commit'te LGWR'ın redo'yu diske yazmasını bekliyor
• db file sequential readWait: tek bloklu fiziksel okuma; genellikle index ya da tablo erişimi
• db file scattered readWait: çok bloklu fiziksel okuma; genellikle full table scan ya da index fast full scan
• buffer busy waitsWait: başka bir oturumun okuduğu ya da değiştirdiği buffer üzerinde contention
• gc buffer busyWait (RAC): instance'lar arasında taşınan cache fusion block'u üzerinde contention
• library cache lockWait: library cache nesne handle'ı üzerinde contention (parse/DDL sıralaması)
• 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 readWait: oturum, buffer cache'i atlayıp blokları doğrudan PGA'ya okuyor
• latch: cache buffers chainsWait: cache buffers chains latch üzerinde contention
• 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
• ORA-27102out of memory
• ORA-04030out of process memory when trying to allocate N bytes
• ORA-12537TNS:connection closed
• ORA-03135connection lost contact
• ORA-01033ORACLE initialization or shutdown in progress
• ORA-00600internal error code, arguments: [...]
• ORA-07445exception encountered: core dump
• ORA-01102cannot mount database in EXCLUSIVE mode
• ORA-29913error in executing ODCIEXTTABLEOPEN callout
• ORA-19804cannot reclaim N bytes disk space from M bytes limit
• ORA-00494enqueue held for too long by 'inst N, osid M'
• 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
• ORA-00020maximum number of processes (N) exceeded
• ORA-01113file N needs media recovery
• ORA-02393exceeded call limit on CPU usage
• ORA-12801error signaled in parallel query server Pnnn