ToolLook up
Oracle error lookup
What an ORA- error usually means, what to check first, and the denrepo scripts that help. Type a code or words from the message. You can also type an ORA- code straight into the search bar.
The tool runs entirely in your browser. Nothing you type into it is sent anywhere.
Errors covered
- ORA-00001: unique constraint (%s.%s) violated
- ORA-00018: maximum number of sessions exceeded
- ORA-00020: maximum number of processes (%s) exceeded
- ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
- ORA-00060: deadlock detected while waiting for resource
- ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.
- ORA-00600: internal error code, arguments: [%s], [%s], ...
- ORA-00604: error occurred at recursive SQL level %s
- ORA-00904: "%s": invalid identifier
- ORA-00942: table or view does not exist
- ORA-01000: maximum open cursors exceeded
- ORA-01017: invalid username/password; logon denied
- ORA-01031: insufficient privileges
- ORA-01033: ORACLE initialization or shutdown in progress
- ORA-01034: ORACLE not available
- ORA-01089: immediate shutdown or close in progress - no operations are permitted
- ORA-01110: data file %s: '%s'
- ORA-01113: file %s needs media recovery
- ORA-01157: cannot identify/lock data file %s - see DBWR trace file
- ORA-01194: file %s needs more recovery to be consistent
- ORA-01422: exact fetch returns more than requested number of rows
- ORA-01489: result of string concatenation is too long
- ORA-01555: snapshot too old: rollback segment number %s with name "%s" too small
- ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
- ORA-01652: unable to extend temp segment by %s in tablespace %s
- ORA-01653: unable to extend table %s.%s by %s in tablespace %s
- ORA-01654: unable to extend index %s.%s by %s in tablespace %s
- ORA-01688: unable to extend table %s.%s partition %s by %s in tablespace %s
- ORA-01691: unable to extend lob segment %s.%s by %s in tablespace %s
- ORA-01722: invalid number
- ORA-01861: literal does not match format string
- ORA-01950: no privileges on tablespace '%s'
- ORA-02291: integrity constraint (%s.%s) violated - parent key not found
- ORA-04021: timeout occurred while waiting to lock object
- ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
- ORA-04031: unable to allocate %s bytes of shared memory ("%s","%s","%s","%s")
- ORA-04068: existing state of packages%s%s%s has been discarded
- ORA-06512: at %sline %s
- ORA-08102: index key not found, obj# %s, file %s, block %s (%s)
- ORA-12154: TNS:could not resolve the connect identifier specified
- ORA-12170: TNS:Connect timeout occurred
- ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ORA-12519: TNS:no appropriate service handler found
- ORA-12537: TNS:connection closed
- ORA-12541: TNS:no listener
- ORA-16014: log %s sequence# %s not archived, no available destinations
- ORA-19809: limit exceeded for recovery files
- ORA-19815: WARNING: db_recovery_file_dest_size of %s bytes is %s%% used, and has %s remaining bytes available.
- ORA-28030: Server encountered problems accessing LDAP directory service
- ORA-28274: No ORACLE password attribute corresponding to user nickname exists
- ORA-28000: the account is locked
- ORA-28001: the password has expired
- ORA-28002: the password will expire within %s days
- ORA-30036: unable to extend segment by %s in undo tablespace '%s'
- ORA-65011: Pluggable database %s does not exist.
- ORA-65096: invalid common user or role name