Oracle Error Numbers
ORA-00001 .. ORA-01000
ORA-01001 .. ORA-02000
ORA-02001 .. ORA-03000
ORA-03001 .. ORA-04000
ORA-04001 .. ORA-05000
ORA-05001 .. ORA-06000
ORA-06001 .. ORA-07000
ORA-07001 .. ORA-08000
ORA-08001 .. ORA-09000
ORA-09001 .. ORA-10000
ORA-10001 .. ORA-11000
ORA-11001 .. ORA-12000
ORA-12001 .. ORA-13000
ORA-13001 .. ORA-14000
ORA-14001 .. ORA-15000
ORA-15001 .. ORA-16000
ORA-16001 .. ORA-17000
ORA-17001 .. ORA-18000
ORA-18001 .. ORA-19000
ORA-19001 .. ORA-20000
ORA-20001 .. ORA-21000
ORA-21001 .. ORA-22000
ORA-22001 .. ORA-23000
ORA-23001 .. ORA-24000
ORA-24001 .. ORA-25000
ORA-25001 .. ORA-26000
ORA-26001 .. ORA-27000
ORA-27001 .. ORA-28000
ORA-28001 .. ORA-29000
ORA-29001 .. ORA-30000
ORA-30001 .. ORA-31000
ORA-31001 .. ORA-32000
ORA-32001 .. ORA-33000
ORA-33001 .. ORA-34000
ORA-34001 .. ORA-35000
ORA-35001 .. ORA-36000
ORA-36001 .. ORA-37000
ORA-37001 .. ORA-38000
ORA-38001 .. ORA-39000
ORA-39001 .. ORA-40000
ORA-40001 .. ORA-41000
ORA-41001 .. ORA-42000
ORA-42001 .. ORA-43000
ORA-43001 .. ORA-44000
ORA-44001 .. ORA-45000
............
....
ORA-00001: unique constraint (
string
.
string
)
ORA-00017: session requested to set trace event
ORA-00018: maximum number of sessions exceeded
ORA-00019: maximum number of session licenses exceeded
ORA-00020: maximum number of processes (
string
) exceeded
ORA-00021: session attached to some other process; cannot switch session
ORA-00022: invalid session ID; access denied
ORA-00023: session references process private memory; cannot detach session
ORA-00024: logins from more than one process not allowed in single-process mode
ORA-00025: failed to allocate
string
ORA-00026: missing or invalid session ID
ORA-00027: cannot kill current session
ORA-00028: your session has been killed
ORA-00029: session is not a user session
ORA-00030: User session ID does not exist.
ORA-00031: session marked for kill
ORA-00032: invalid session migration password
ORA-00033: current session has empty migration password
ORA-00034: cannot
string
in current PL/SQL session
ORA-00036: maximum number of recursive SQL levels (
string
) exceeded
ORA-00037: cannot switch to a session belonging to a different server group
ORA-00038: Cannot create session: server group belongs to another user
ORA-00039: error during periodic action
ORA-00040: active time limit exceeded - call aborted
ORA-00041: active time limit exceeded - session terminated
ORA-00042: Unknown Service name
string
ORA-00043: remote operation failed
ORA-00050: operating system error occurred while obtaining an enqueue
ORA-00051: timeout occurred while waiting for a resource
ORA-00052: maximum number of enqueue resources (
string
) exceeded
ORA-00053: maximum number of enqueues exceeded
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-00055: maximum number of DML locks exceeded
ORA-00056: DDL lock on object `
string
.
string
ORA-00057: maximum number of temporary table locks exceeded
ORA-00058: DB_BLOCK_SIZE must be
string
to mount this database (not
ORA-00059: maximum number of DB_FILES exceeded
ORA-00060: deadlock detected while waiting for resource
ORA-00061: another instance has a different DML_LOCKS setting
ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0
ORA-00063: maximum number of log files exceeded
string
ORA-00064: object is too large to allocate on this O/S (
string
,
ORA-00065: initialization of FIXED_DATE failed
ORA-00067: invalid value
string
for parameter
strin
ORA-00068: invalid value
string
for parameter
strin
ORA-00069: cannot acquire lock -- table locks disabled for
string
ORA-00070: command
string
is not valid
ORA-00071: process number must be between 1 and
string
ORA-00072: process "
string
" is not active
ORA-00073: command
string
takes between
string
ORA-00074: no process has been specified
ORA-00075: process "
string
" not found in this instance
ORA-00076: dump
string
not found
ORA-00077: dump
string
is not valid
ORA-00078: cannot dump variables by name
ORA-00079: variable
string
not found
ORA-00080: invalid global area specified by level
string
ORA-00081: address range [
string
,
string
) is
ORA-00082: memory size of
string
is not in valid set of [1], [2], [4]
ORA-00083: warning: possibly corrupt SGA mapped
ORA-00084: global area must be PGA, SGA, or UGA
ORA-00085: current call does not exist
ORA-00086: user call does not exist
ORA-00087: command cannot be executed on remote instance
ORA-00088: command cannot be executed by shared server
ORA-00089: invalid instance number in ORADEBUG command
ORA-00090: failed to allocate memory for cluster database ORADEBUG command
ORA-00091: LARGE_POOL_SIZE must be at least
string
ORA-00092: LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC
ORA-00093:
string
must be between
string
and
ORA-00094:
string
requires an integer value
ORA-00096: invalid value
string
for parameter
strin
ORA-00097: use of Oracle SQL feature not in SQL92
string
Level
ORA-00098: creating or mounting the database requires a parameter file
ORA-00099: warning: no parameter file was specified
ORA-00100: no data found
ORA-00101: invalid specification for system parameter DISPATCHERS
ORA-00102: network protocol
string
cannot be used by dispatchers
ORA-00103: invalid network protocol; reserved for use by dispatchers
ORA-00104: deadlock detected; all public servers blocked waiting for resources
ORA-00105: too many dispatcher configurations
ORA-00106: cannot startup/shutdown database when connected to a dispatcher
ORA-00107: failed to connect to ORACLE listener process
ORA-00108: failed to set up dispatcher to accept connection asynchronously
ORA-00109: invalid value for attribute
string
:
stri
ORA-00110: invalid value
string
for attribute
strin
ORA-00111: invalid attribute
string
ORA-00112: value of
string
is null
ORA-00113: protocol name
string
is too long
ORA-00114: missing value for system parameter SERVICE_NAMES
ORA-00115: connection refused; dispatcher connection table is full
ORA-00116: SERVICE_NAMES name is too long
ORA-00117: PROTOCOL, ADDRESS or DESCRIPTION must be specified
ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified
ORA-00119: invalid specification for system parameter
string
ORA-00122: cannot initialize network configuration
ORA-00123: idle public server terminating
ORA-00125: connection refused; invalid presentation
ORA-00126: connection refused; invalid duplicity
ORA-00127: dispatcher
string
does not exist
ORA-00128: this command requires a dispatcher name
ORA-00129: listener address validation failed `
string
`
ORA-00130: invalid listener address `
string
`
ORA-00131: network protocol does not support registration `
string
`
ORA-00132: syntax error or unresolved network name `
string
`
ORA-00133: value of
string
is too long
ORA-00134: invalid DISPATCHERS specification #
string
ORA-00150: duplicate transaction ID
ORA-00151: invalid transaction ID
ORA-00152: current session does not match requested session
ORA-00153: internal error in XA library
ORA-00154: protocol error in transaction monitor
ORA-00155: cannot perform work outside of global transaction
ORA-00160: global transaction length
string
is greater than maximum (
ORA-00161: transaction branch length
string
is illegal (maximum allowed
ORA-00162: external dbid length
string
is greater than maximum (
ORA-00163: internal database name length
string
is greater than maximum
ORA-00164: distributed autonomous transaction disallowed within migratable distributed transaction
ORA-00165: migratable distributed autonomous transaction with remote operation is not allowed
ORA-00166: remote/local nesting level is too deep
ORA-00200: control file could not be created
ORA-00201: control file version
string
incompatible with ORACLE version
ORA-00202: control file: `
string
`
ORA-00203: using the wrong control files
ORA-00204: error in reading (block
string
, # blocks
ORA-00205: error in identifying control file, check alert log for more info
ORA-00206: error in writing (block
string
, # blocks
ORA-00207: control files are not for the same database
ORA-00208: number of control file names exceeds limit of
string
ORA-00209: control file blocksize mismatch, check alert log for more info
ORA-00210: cannot open the specified control file
ORA-00211: control file does not match previous control files
ORA-00212: block size
string
below minimum required size of
ORA-00213: cannot reuse control file; old file size
string
,
ORA-00214: control file `
string
` version
string
ORA-00215: must be at least one control file
ORA-00216: control file could not be resized for migration from 8.0.2
ORA-00217: control file could not be resized for new record types
ORA-00218: block size
string
of control file `
strin
ORA-00219: required control file size (
string
logical blocks) exceeds ma
ORA-00220: control file not mounted by first instance, check alert log for more info
ORA-00221: error on write to control file
ORA-00222: operation would reuse name of a currently mounted control file
ORA-00223: convert file is invalid or incorrect version
ORA-00224: control file resize attempted with illegal record type (
string
ORA-00225: expected size
string
of control file differs from actual size
ORA-00226: operation disallowed while alternate control file open
ORA-00227: corrupt block detected in control file: (block
string
, # bloc
ORA-00228: length of alternate control file name exceeds maximum of
string
ORA-00229: operation disallowed: already hold snapshot control file enqueue
ORA-00230: operation disallowed: snapshot control file enqueue unavailable
ORA-00231: snapshot control file has not been named
ORA-00232: snapshot control file is nonexistent, corrupt, or unreadable
ORA-00233: copy control file is corrupt or unreadable
ORA-00234: error in identifying or opening snapshot or copy control file
ORA-00235: control file fixed table inconsistent due to concurrent update
ORA-00236: snapshot operation disallowed: mounted control file is a backup
ORA-00237: snapshot operation disallowed: control file newly created
ORA-00238: operation would reuse a filename that is part of the database
ORA-00250: archiver not started
ORA-00251: LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string
str
ORA-00252: log
string
of thread
string
is em
ORA-00253: character limit
string
exceeded by archive destination string
ORA-00254: error in archive control string `
string
`
ORA-00255: error archiving log
string
of thread
str
ORA-00256: cannot translate archive destination string
string
ORA-00257: archiver error. Connect internal only, until freed.
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
ORA-00259: log
string
of open instance
string
ORA-00260: cannot find online log sequence
string
for thread
ORA-00261: log
string
of thread
string
is be
ORA-00262: current log
string
of closed thread
stri
ORA-00263: there are no logs that need archiving for thread
string
ORA-00264: no recovery required
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
ORA-00266: name of archived log file needed
ORA-00267: name of archived log file not needed
ORA-00268: specified log file does not exist `
string
`
ORA-00269: specified log file is part of thread
string
not
ORA-00270: error creating archive log
string
ORA-00271: there are no logs that need archiving
ORA-00272: error writing archive log
string
ORA-00273: media recovery of direct load data that was not logged
ORA-00274: illegal recovery option
string
ORA-00275: media recovery has already been started
ORA-00276: CHANGE keyword specified but no change number given
ORA-00277: illegal option to the UNTIL recovery flag
string
ORA-00278: log file `
string
` no longer needed for this recovery
ORA-00279: change
string
generated at
string
ORA-00280: change
string
for thread
string
i
ORA-00281: media recovery may not be performed using dispatcher
ORA-00282: UPI
string
call not supported, use ALTER DATABASE RECOVER
ORA-00283: recovery session canceled due to errors
ORA-00284: recovery session still in progress
ORA-00285: TIME not given as a string constant
ORA-00286: no members available, or no member contains valid data
ORA-00287: specified change number
string
not found in thread
ORA-00288: to continue recovery type ALTER DATABASE RECOVER CONTINUE
ORA-00289: suggestion :
string
ORA-00290: operating system archival error occurred. See error below
ORA-00291: numeric value required for PARALLEL option
ORA-00292: parallel recovery feature not installed
ORA-00293: control file out of sync with redo log
ORA-00294: invalid archivelog format specifier `
string
`
ORA-00295: datafile/tempfile number
string
is invalid, must be between 1
ORA-00296: maximum number of files (
string
) exceeded for RECOVER DATAFIL
ORA-00297: must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START
ORA-00298: Missing or invalid attribute value
ORA-00299: must use file-level media recovery on data file
string
ORA-00300: illegal redo log block size
string
specified - exceeds limit
ORA-00301: error in adding log file `
string
` - file cannot be created
ORA-00302: limit of
string
logs exceeded
ORA-00303: cannot process Parallel Redo
ORA-00304: requested INSTANCE_NUMBER is busy
ORA-00305: log
string
of thread
string
incon
ORA-00306: limit of
string
instances in this database
ORA-00307: requested INSTANCE_NUMBER out of range, maximum is
string
ORA-00308: cannot open archived log `
string
`
ORA-00309: log belongs to wrong database
ORA-00310: archived log contains sequence
string
; sequence
ORA-00311: cannot read header from archived log
ORA-00312: online log
string
thread
string
:
ORA-00313: open failed for members of log group
string
of thread
ORA-00314: log
string
of thread
string
, expe
ORA-00315: log
string
of thread
string
, wron
ORA-00316: log
string
of thread
string
, type
ORA-00317: file type
string
in header is not log file
ORA-00318: log
string
of thread
string
, expe
ORA-00319: log
string
of thread
string
has i
ORA-00320: cannot read file header from log
string
of thread
ORA-00321: log
string
of thread
string
, cann
ORA-00322: log
string
of thread
string
is no
ORA-00323: Current log of thread
string
not useable and all others need
ORA-00324: log file `
string
` translated name `
strin
ORA-00325: archived log for thread
string
, wrong thread #
ORA-00326: log begins at change
string
, need earlier change
ORA-00327: log
string
of thread
string
, phys
ORA-00328: archived log ends at change
string
, need later change
ORA-00329: archived log begins at change
string
, need change
ORA-00330: archived log ends at change
string
, need change
ORA-00331: log version
string
incompatible with ORACLE version
ORA-00332: archived log is too small - may be incompletely archived
ORA-00333: redo log read error block
string
count
s
ORA-00334: archived log: `
string
`
ORA-00335: online log
string
: No log with this number, log does not exis
ORA-00336: log file size
string
blocks is less than minimum
ORA-00337: log file `
string
` does not exist and no size specified
ORA-00338: log
string
of thread
string
is mo
ORA-00339: archived log does not contain any redo
ORA-00340: IO error processing online log
string
of thread
ORA-00341: log
string
of thread
string
, wron
ORA-00342: archived log does not have expected resetlogs SCN
string
ORA-00344: unable to re-create online log `
string
`
ORA-00345: redo log write error block
string
count
ORA-00346: log member marked as STALE and closed
ORA-00347: log
string
of thread
string
, expe
ORA-00348: single-process redo failure. Must abort instance
ORA-00349: failure obtaining block size for `
string
`
ORA-00350: log
string
of instance
string
(th
ORA-00351: recover-to time invalid
ORA-00352: all logs for thread
string
need to be archived - cannot enabl
ORA-00353: log corruption near block
string
change
ORA-00354: corrupt redo log block header
ORA-00355: change numbers out of order
ORA-00356: inconsistent lengths in change description
ORA-00357: too many members specified for log file, the maximum is
string
ORA-00358: Too many file members specified, the maximum is
string
ORA-00359: logfile group
string
does not exist
ORA-00360: not a logfile member:
string
ORA-00361: cannot remove last log member
string
for group
ORA-00362: member is required to form a valid logfile in group
string
ORA-00363: log is not the archived version
ORA-00364: cannot write header to new log member
ORA-00365: the specified log is not the correct next log
ORA-00366: log
string
of thread
string
, chec
ORA-00367: checksum error in log file header
ORA-00368: checksum error in redo log block
ORA-00369: Current log of thread
string
not useable and other log being
ORA-00370: potential deadlock during kcbchange operation
ORA-00371: not enough shared pool memory, should be atleast
string
bytes
ORA-00372: file
string
cannot be modified at this time
ORA-00373: online log version
string
incompatible with ORACLE version
ORA-00374: parameter db_block_size =
string
invalid ; must be a multiple
ORA-00376: file
string
cannot be read at this time
ORA-00377: Frequent backups of file
string
causing write operation to st
ORA-00378: buffer pools cannot be created as specified
ORA-00379: no free buffers available in buffer pool
string
for block siz
ORA-00380: cannot specify db_
string
k_cache_size since
ORA-00381: cannot use both new and old parameters for buffer cache size specification
ORA-00382:
string
not a valid block size, valid range [
ORA-00383: DEFAULT cache for blocksize
string
cannot be reduced to zero
ORA-00384: Insufficient memory to grow cache
ORA-00385: cannot enable Very Large Memory with new buffer cache parameters
ORA-00386: use_indirect_data_buffers not supported
ORA-00390: log
string
of thread
string
is be
ORA-00391: All threads must switch to new log format at the same time
ORA-00392: log
string
of thread
string
is be
ORA-00393: log
string
of thread
string
is ne
ORA-00394: online log reused while attempting to archive it
ORA-00395: online logs for the clone database must be renamed
ORA-00396: error
string
required fallback to single-pass recovery
ORA-00397: instance recovery process terminated with error
ORA-00398: abort thread recovery due to reconfiguration
ORA-00399: corrupt change description in redo log
ORA-00400: invalid release value
string
for parameter
ORA-00401: the value for parameter
string
is not supported by this relea
ORA-00402: database changes by release
string
cannot be used by release
ORA-00403:
string
(
string
) is not the same a
ORA-00404: Convert file not found: `
string
`
ORA-00405: compatibility type "
string
"
ORA-00406: COMPATIBLE parameter needs to be
string
or greater
ORA-00407: rolling upgrade from release
string
.
stri
ORA-00408: parameter
string
is set to TRUE
ORA-00409: COMPATIBLE needs to be
string
or higher to use AUTO SEGMENT S
ORA-00437: ORACLE feature is not licensed. Contact Oracle Corp. for assistance
ORA-00438:
string
Option not installed
ORA-00439: feature not enabled:
string
ORA-00443: background process "
string
" did not start
ORA-00444: background process "
string
" failed while starting
ORA-00445: background process "
string
" did not start after
ORA-00446: background process started when not expected
ORA-00447: fatal error in background process
ORA-00448: normal completion of background process
ORA-00449: background process `
string
` unexpectedly terminated with erro
ORA-00450: background process `
string
` did not start
ORA-00451: foreground process died unexpectedly
ORA-00452: foreground process unexpectedly terminated with error
string
ORA-00453: backgroud process `
string
` is dead
ORA-00469: CKPT process terminated with error
ORA-00470: LGWR process terminated with error
ORA-00471: DBWR process terminated with error
ORA-00472: PMON process terminated with error
ORA-00473: ARCH process terminated with error
ORA-00474: SMON process terminated with error
ORA-00475: TRWR process terminated with error
ORA-00476: RECO process terminated with error
ORA-00477: SNP* process terminated with error
ORA-00478: SMON process terminated due to error
string
ORA-00479: RVWR process terminated with error
string
ORA-00480: LCK* process terminated with error
ORA-00481: LMON process terminated with error
ORA-00482: LMD* process terminated with error
ORA-00483: During shutdown a process abnormally terminated
ORA-00484: LMS* process terminated with error
ORA-00485: DIAG process terminated with error
string
ORA-00486: ASMB process terminated with error
ORA-00487: CTWR process terminated with error
ORA-00488: RBAL process terminated with error
ORA-00489: ARB* process terminated with error
ORA-00490: PSP process terminated with error
ORA-00491: RMS0 process terminated with error
ORA-00492: GTX* process terminated with error
ORA-00493: GMON process terminated with error
ORA-00566: cannot request processor group - NUMA not enabled
ORA-00567: Requested processor group
string
is too large (maximum
ORA-00568: Maximum number of interrupt handlers exceeded
ORA-00569: Failed to acquire global enqueue.
ORA-00600: internal error code, arguments: [
string
], [
ORA-00601: cleanup lock conflict
ORA-00602: internal programming exception
ORA-00603: ORACLE server session terminated by fatal error
ORA-00604: error occurred at recursive SQL level
string
ORA-00606: Internal error code
ORA-00607: Internal error occurred while making a change to a data block
ORA-00608: testing error [
string
] [
string
] [
ORA-00609: could not attach to incoming connection
ORA-00610: Internal error code
ORA-00700: soft internal error, arguments: [
string
], [
ORA-00701: object necessary for warmstarting database cannot be altered
ORA-00702: bootstrap verison `
string
` inconsistent with version `
ORA-00703: maximum number of row cache instance locks exceeded
ORA-00704: bootstrap process failure
ORA-00705: inconsistent state during start up; shut down the instance, then restart it
ORA-00706: error changing format of file `
string
`
ORA-00710: new tablespace name is the same as the old tablespace name
ORA-00711: new tablespace name is invalid
ORA-00712: cannot rename system tablespace
ORA-00720: ALTER DATABASE RESET COMPATIBILITY command has been de-supported
ORA-00721: changes by release
string
cannot be used by release
ORA-00722: Feature "
string
"
ORA-00723: Initialization parameter COMPATIBLE must be explicitly set
ORA-00724: ALTER DATABASE CONVERT command has been de-supported
ORA-00725: Desupported ALTER DATABASE SET STANDBY clause specified:
string
ORA-00740: datafile size of (
string
) blocks exceeds maximum file size
ORA-00741: logfile size of (
string
) blocks exceeds maximum logfile size
ORA-00750: database has been previously mounted and dismounted
ORA-00751: could not obtain resilvering status for file
ORA-00752: recovery detected a lost write of a data block
ORA-00820: Specified value of sga_max_size is too small, needs to be at least
s
ORA-00821: Specified value of sga_target
string
M is too small, needs to
ORA-00822: MMAN process terminated with error
ORA-00823: Specified value of sga_target greater than sga_max_size
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log f
ORA-00825: cannot set DB_BLOCK_BUFFERS if SGA_TARGET or MEMORY_TARGET is set
ORA-00826: cannot set SGA_TARGET or MEMORY_TARGET for an ASM instance
ORA-00827: could not shrink sga_target to specified value
ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings
ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled
ORA-00832: no streams pool created and cannot automatically create one
ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least
ORA-00839: SGA_TARGET cannot be modified to the specified value
ORA-00840: PGA_AGGREGATE_TARGET cannot be modified to the specified value
ORA-00841: MEMORY_TARGET not supported on this system
ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account, see alert log for more information
ORA-00844: Parameter not taking MEMORY_TARGET into account, see alert log for more information
ORA-00845: MEMORY_TARGET not supported on this system
ORA-00846: could not shrink MEMORY_TARGET to specified value
ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together
ORA-00910: specified length too long for its datatype
ORA-00911: invalid character
ORA-00912: input parameter too long
ORA-00953: missing or invalid index name
ORA-00956: missing or invalid auditing option
ORA-00960: ambiguous column naming in select list
ORA-00962: too many group-by / order-by expressions
ORA-00964: table name not in FROM list
ORA-00965: column aliases not allowed for `*`
ORA-00972: identifier is too long
ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here
ORA-00977: duplicate auditing option
ORA-00980: synonym translation is no longer valid
ORA-00981: cannot mix table and system auditing options
ORA-00983: cannot audit or noaudit SYS user actions
ORA-00991: only MAC privileges may be granted to procedures
Page :
....
Search Error
Top Sites in the Web
contact:errcodes@gmail.com © Copyright 2008
www.11ghelp.com
All Rights Reserved.