back
Oracle® Database 11g / 12c / 18c error codes ORA-09870-ORA-12100
- ORA-09870: spini: failure initializing maximum number of open files.
- ORA-09871: TASDEF_NAME: translation error while expanding ?/dbs/tasdef@.dbf.
- ORA-09872: TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.
- ORA-09873: TASDEF_OPEN: open error when opening tasdef@.dbf file.
- ORA-09874: TASDEF_READ: read error, unable to read tasdef@.dbf file.
- ORA-09875: TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.
- ORA-09876: TASDEF_CLOSE: unable to close ?/dbs/tasdef@.dbf file.
- ORA-09877: sstascre: shmget error, unable to get a shared memory segment.
- ORA-09878: sstascre/sstasat: shmat error, unable to attach tas write page
- ORA-09879: sstascre/sstasat: shmat error, unable to attach tas read page
- ORA-09880: sstasfre/sstasdel: shmdt error, unable to detach tas write page
- ORA-09881: sstasfre/sstasdel: shmdt error, unable to detach tas read page
- ORA-09882: sstasfre/sstasdel: shmctl error, unable to remove tas shm page
- ORA-09883: Two Task interface: oratab file does not exist
- ORA-09884: Two Task interface: SID doens''t match current PU
- ORA-09885: osnTXtt: cannot create TXIPC channel
- ORA-09886: osnTXtt: translation error while expanding txipc@.trc.
- ORA-09888: osnTXtt: txipc channel creation failed
- ORA-09889: osnTXtt: access error on oracle executable
- ORA-09890: osnTXtt: malloc failed
- ORA-09908: slkmnm: gethostname returned error code.
- ORA-09909: Malloc of scratch buffer failed.
- ORA-09910: Unable to find ORACLE password file entry for user.
- ORA-09911: Incorrect user password.
- ORA-09912: Malloc of name buffer(s) failed.
- ORA-09913: Malloc of dummy name failed.
- ORA-09914: Unable to open the ORACLE password file.
- ORA-09915: Password encryption failed.
- ORA-09916: Required password was not specified.
- ORA-09918: Unable to get user privileges from SQL*Net
- ORA-09919: Unable to set label of dedicated server
- ORA-09920: Unable to get sensitivity label from connection
- ORA-09921: Unable to get information label from connection
- ORA-09922: Can''t spawn process - background log directory not created properly
- ORA-09923: Can''t spawn process - user log directory not created properly
- ORA-09924: Can''t spawn process - core dump directory not created properly
- ORA-09925: Unable to create audit trail file
- ORA-09926: Unable to set effective privilege set of the server
- ORA-09927: Unable to set label of server
- ORA-09928: Unable to restore the label of server
- ORA-09929: GLB of two labels is invalid
- ORA-09930: LUB of two labels is invalid
- ORA-09931: Unable to open ORACLE password file for reading
- ORA-09932: Close of ORACLE password file failed.
- ORA-09933: Deletion of old password file failed.
- ORA-09934: Link of current password file to old failed.
- ORA-09935: Unlink of current password file failed.
- ORA-09936: Open of ORACLE password file for write failed.
- ORA-09937: Chmod of ORACLE password file failed.
- ORA-09938: Save of signal handlers failed.
- ORA-09939: Restoration of signal handlers failed.
- ORA-09940: ORACLE password file header is corrupt
- ORA-09941: Version of orapasswd or installer is older than file.
- ORA-09942: Write of ORACLE password file header failed.
- ORA-09943: Allocation of memory for password list component failed.
- ORA-09944: Password entry is corrupt.
- ORA-09945: Unable to initialize the audit trail file
- ORA-09946: File name too long for buffer
- ORA-09947: Unable to allocate connection attributes structure
- ORA-09948: Process information label retrieval failed.
- ORA-09949: Unable to get client operating system privileges
- ORA-09950: Unable to get server operating system privileges
- ORA-09951: Unable to create file
- ORA-09952: scgcmn: lk_open_convert unexpected return: open failed
- ORA-09953: scggc: unexpected return of a lock convert
- ORA-09954: scgcc: unexpected return status to callback of lock close
- ORA-09955: scgcan: unexpected return status when canceling a lock
- ORA-09956: scgcm: unexpected lock status condition
- ORA-09957: Unable to send termination request to IMON
- ORA-09958: IMON: two processes with the same ORACLE pid are active
- ORA-09959: IMON: deletion of a process failed.
- ORA-09960: Unable to establish signal handler for termination signal
- ORA-09961: Unable to restore termination signal handler
- ORA-09966: falure in translation while expanding ?/dbs/lk for lock file
- ORA-09967: unable to create or open lock file
- ORA-09968: unable to lock file
- ORA-09969: unable to close or remove lock file
- ORA-09974: skxfidini: Error Initializing SDI Channel
- ORA-09975: kxfspini: Error Initializing SDI Process
- ORA-09976: skxfqdini: Error Creating Port
- ORA-09977: skxfqhini: Error Connecting
- ORA-09978: skxfqhdel: Error Disconnecting from another endpoint.
- ORA-09979: skxfqhsnd: Error Sending a message to another endpoint
- ORA-09980: skxfqdrcv: Error Receiving a message from another endpoint
- ORA-09981: skxfqdreg: Error Adding a page to the SDI buffer pool
- ORA-09982: skxfqddrg: Error Removing a page from the SDI buffer pool
- ORA-09983: skxfidsht: Error shutting down SDI channel
- ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist
- ORA-09985: SGA definition file could not be read
- ORA-09986: wrong number of bytes read from SGA definition file
- ORA-09987: unable to attach to SGA in READ-ONLY mode
- ORA-09988: error while detaching SGA
- ORA-09989: attempt to use invalid skgmsdef struct pointer
- ORA-10243: simulated error for test [string] of K2GTAB latch cleanup
- ORA-10244: make tranids in error msgs print as 0.0.0 (for testing)
- ORA-10259: get error message text from remote using explicit call
- ORA-10261: Limit the size of the PGA heap
- ORA-10262: Don''t check for memory leaks
- ORA-10263: Don''t free empty PGA heap extents
- ORA-10265: Keep random system generated output out of error messages
- ORA-10266: Trace OSD stack usage
- ORA-10267: Inhibit KSEDMP for testing
- ORA-10268: Don''t do forward coalesce when deleting extents
- ORA-10269: Don''t do coalesces of free space in SMON
- ORA-10270: Debug shared cursors
- ORA-10281: maximum time to wait for process creation
- ORA-10282: Inhibit signalling of other backgrounds when one dies
- ORA-10284: simulate zero/infinite asynch I/O buffering
- ORA-10452: Cannot do block media recovery; media recovery session may be in progress
- ORA-10456: cannot open standby database; media recovery session may be in progress
- ORA-10457: cannot close standby database due to active media recovery
- ORA-10458: standby database requires recovery
- ORA-10459: cannot start media recovery on standby database; another instance may be open
- ORA-10469: error creating control file backup, no checkpoint
- ORA-10546: Cannot perform block media recovery; standby database does not have requisite redo.
- ORA-10547: Cannot perform block media recovery; standby database is not caught up with primary.
- ORA-10548: Cannot perform block media recovery on a read-only plugged-in datafile.
- ORA-10549: Cannot perform block media recovery using a read-only plugged-in backup datafile.
- ORA-10552: Inconsistent plug-in file [string] encountered during standby recovery
- ORA-10553: Incompatible UNTIL CONSISTENT clause
- ORA-10554: Media recovery failed to bring datafile [string] to a consistent point
- ORA-10560: block type '[string]'
- ORA-10561: block type '[string]', data object# string
- ORA-10562: Error occurred while applying redo to data block (file# [string], block# [string])
- ORA-10563: Test recovery had to corrupt data block (file# [string], block# [string]) in order to proceed
- ORA-10564: tablespace [string]
- ORA-10565: Another test recovery session is active
- ORA-10566: Test recovery has used all the memory it can use
- ORA-10567: Redo is inconsistent with data block (file# [string], block# [string])
- ORA-10568: Failed to allocate recovery state object: out of SGA memory
- ORA-10570: Test recovery complete
- ORA-10571: Test recovery canceled
- ORA-10572: Test recovery canceled due to errors
- ORA-10573: Test recovery tested redo from change [string] to [string]
- ORA-10574: Test recovery did not corrupt any data block
- ORA-10575: Give up restoring recovered datafiles to consistent state: out of memory
- ORA-10576: Give up restoring recovered datafiles to consistent state: some error occurred
- ORA-10577: Can not invoke test recovery for managed standby database recovery
- ORA-10578: Can not allow corruption for managed standby database recovery
- ORA-10579: Can not modify control file during test recovery
- ORA-10580: Can not modify datafile header during test recovery
- ORA-10581: Can not modify redo log header during test recovery
- ORA-10582: The control file is not a backup control file
- ORA-10583: Can not recovery file [string] renamed as missing during test recovery
- ORA-10584: Can not invoke parallel recovery for test recovery
- ORA-10585: Test recovery can not apply redo that may modify control file
- ORA-10586: Test recovery had to corrupt 1 data block in order to proceed
- ORA-10587: Invalid count for ALLOW n CORRUPTION option
- ORA-10588: Can only allow 1 corruption for normal media/standby recovery
- ORA-10589: Test recovery had to corrupt [string] data blocks in order to proceed
- ORA-10614: Operation not allowed on this segment
- ORA-10615: Invalid tablespace type for temporary tablespace
- ORA-10616: Operation not allowed on this tablespace
- ORA-10617: Cannot create rollback segment in dictionary managed tablespace
- ORA-10618: Operation not allowed on this segment
- ORA-10619: Avoid assertions when possible
- ORA-10620: Operation not allowed on this segment
- ORA-10627: Dump the content of the index leaf block
- ORA-10628: Turn on sanity check for kdiss index skip scan state
- ORA-10630: Illegal syntax specified with SHRINK clause
- ORA-10631: SHRINK clause should not be specified for this object
- ORA-10632: Invalid rowid
- ORA-10633: No space found in the segment
- ORA-10634: Segment is already being shrunk
- ORA-10635: Invalid segment or tablespace type
- ORA-10636: ROW MOVEMENT is not enabled
- ORA-10637: The segment does not exist
- ORA-10638: Index status is invalid
- ORA-10639: Dump library cache during kksfbc-reparse-infinite-loop error
- ORA-10640: Operation not permitted during SYSTEM tablespace migration
- ORA-10641: Cannot find a rollback segment to bind to
- ORA-10642: Found rollback segments in dictionary managed tablespaces
- ORA-10643: Database should be mounted in restricted mode and Exclusive mode
- ORA-10644: SYSTEM tablespace cannot be default temporary tablespace
- ORA-10645: Recursive Extension in SYSTEM tablespace during migration
- ORA-10646: Too many recursive extensions during SYSTEM tablespace migration
- ORA-10647: Tablespace other than SYSTEM, [string], [string] not found in read only mode
- ORA-10648: Tablespace SYSAUX is not offline
- ORA-10649: Turn off/trace lob index freelist coalesce
- ORA-10651: incorrect file number block number specified
- ORA-10652: Object has on-commit materialized views
- ORA-10653: Table is in a cluster
- ORA-10654: Table is of type temporary or external
- ORA-10655: Segment can be shrunk
- ORA-10656: Table is in unusable state due to incomplete operation
- ORA-10657: Lob column to be shrunk does not exist
- ORA-10658: Lob column to be shrunk is marked unused
- ORA-10659: Segment being shrunk is not a lob
- ORA-10660: Segment is a shared lob segment
- ORA-10661: Invalid option specified
- ORA-10662: Segment has long columns
- ORA-10663: Object has rowid based materialized views
- ORA-10664: Table has bitmap join indexes
- ORA-10665: Inject Evil Literals
- ORA-10668: Inject Evil Identifiers
- ORA-10690: Set shadow process core file dump type (Unix only)
- ORA-10691: Set background process core file type (Unix only)
- ORA-10700: Alter access violation exception handler
- ORA-10701: Dump direct loader index keys
- ORA-10704: Print out information about what enqueues are being obtained
- ORA-10706: Print out information about global enqueue manipulation
- ORA-10707: Simulate process death for instance registration
- ORA-10828: memory allocator error
- ORA-10841: Default un-inintialized charact set form to SQLCS_IMPLICIT
- ORA-10842: Event for OCI Tracing and Statistics Info
- ORA-10848: OCI Non Blocking not supported with [string]
- ORA-10852: Enable tracing for Enqueue Dequeue Operations
- ORA-10854: Sets poll count used for AQ listen code under RAC
- ORA-10862: resolve default queue owner to current user in enqueue/dequeue
- ORA-10863: Control behavior of buffered background operations
- ORA-10865: Control tracing of notification operations
- ORA-10873: file [string] needs to be either taken out of backup mode or media recovered
- ORA-10877: error signaled in parallel recovery slave [string]
- ORA-10878: parallel recovery slave died unexpectedly
- ORA-10900: extent manager fault insertion event #[string]
- ORA-10902: disable seghdr conversion for ro operation
- ORA-10906: Unable to extend segment after insert direct load
- ORA-10914: invalid TABLESPACE GROUP clause
- ORA-10915: TABLESPACE GROUP cannot be specified for this type of tablespace
- ORA-10916: TABLESPACE GROUP already specified
- ORA-10917: TABLESPACE GROUP cannot be specified
- ORA-10918: TABLESPACE GROUP name cannot be the same as tablespace name
- ORA-10919: Default temporary tablespace group must have at least one tablespace
- ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group
- ORA-10921: Cannot drop tablespace belonging to default temporary tablespace group
- ORA-10922: Temporary tablespace group is empty
- ORA-10924: import storage parse error ignore event
- ORA-10925: trace name context forever
- ORA-10926: trace name context forever
- ORA-10927: trace name context forever
- ORA-10929: trace name context forever
- ORA-10930: trace name context forever
- ORA-10931: trace name context forever
- ORA-10932: trace name context forever
- ORA-10933: trace name context forever
- ORA-10936: trace name context forever
- ORA-10940: trace name context forever
- ORA-10941: trace name context forever
- ORA-10943: trace name context forever
- ORA-10944: trace name context forever
- ORA-10945: trace name context forever
- ORA-10946: trace name context forever
- ORA-10947: trace name context forever
- ORA-10970: backout event for bug 2133357
- ORA-10973: backout evet for 2619509
- ORA-10979: trace flags for join index implementation
- ORA-10997: another startup/shutdown operation of this instance inprogress
- ORA-12001: cannot create log: table '[string]' already has a trigger
- ORA-12002: there is no materialized view log on table "[string]"."[string]"
- ORA-12003: materialized view "[string]"."[string]" does not exist
- ORA-12004: REFRESH FAST cannot be used for materialized view "[string]"."[string]"
- ORA-12005: may not schedule automatic refresh for times in the past
- ORA-12007: materialized view reuse parameters are inconsistent
- ORA-12008: error in materialized view refresh path
- ORA-12010: cannot create materialized view log on table owned by SYS
- ORA-12011: execution of [string] jobs failed
- ORA-12012: error on auto execute of job [string]
- ORA-12013: updatable materialized views must be simple enough to do fast refresh
- ORA-12014: table '[string]' does not contain a primary key constraint
- ORA-12015: cannot create a fast refresh materialized view from a complex query
- ORA-12016: materialized view does not include all primary key columns
- ORA-12017: cannot alter primary key mview '[string]' to a rowid mview
- ORA-12018: following error encountered during code generation for "[string]"."[string]"
- ORA-12019: master table is a synonym to a remote object
- ORA-12020: materialized view [string] is not registered
- ORA-12021: materialized view "[string]"."[string]" is corrupt
- ORA-12022: materialized view log on "[string]"."[string]" already has rowid
- ORA-12023: missing index on materialized view "[string]"."[string]"
- ORA-12024: materialized view log on "[string]"."[string]" does not have primary key columns
- ORA-12025: materialized view log on "[string]"."[string]" already has primary keys
- ORA-12026: invalid filter column detected
- ORA-12027: duplicate filter column
- ORA-12028: materialized view type is not supported by master site [string]
- ORA-12029: LOB columns may not be used as filter columns
- ORA-12030: cannot create a fast refresh materialized view
- ORA-12031: cannot use primary key columns from materialized view log on "[string]"."[string]"
- ORA-12032: cannot use rowid column from materialized view log on "[string]"."[string]"
- ORA-12033: cannot use filter columns from materialized view log on "[string]"."[string]"
- ORA-12034: materialized view log on "[string]"."[string]" younger than last refresh
- ORA-12035: could not use materialized view log on "[string]"."[string]"
- ORA-12036: updatable materialized view log is not empty, refresh materialized view
- ORA-12037: unknown export format
- ORA-12039: unable to use local rollback segment "[string]"
- ORA-12040: master rollback segment option not support by master site [string]
- ORA-12041: cannot record ROWIDs for index-organized table "[string]"."[string]"
- ORA-12042: cannot alter job_queue_processes in single process mode
- ORA-12043: invalid CREATE MATERIALIZED VIEW option
- ORA-12044: invalid CREATE MATERIALIZED VIEW LOG option
- ORA-12045: invalid ALTER MATERIALIZED VIEW LOG option
- ORA-12046: cannot use trusted constraints for refreshing remote MV
- ORA-12047: PCT FAST REFRESH cannot be used for materialized view "[string]"."[string]"
- ORA-12048: error encountered while refreshing materialized view "[string]"."[string]"
- ORA-12051: ON COMMIT attribute is incompatible with other options
- ORA-12052: cannot fast refresh materialized view [string].[string]
- ORA-12053: this is not a valid nested materialized view
- ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
- ORA-12055: materialized view definition contains cyclic dependencies with existing materialized views
- ORA-12056: invalid REFRESH method
- ORA-12057: materialized view "[string]"."[string]" is INVALID and must complete refresh
- ORA-12058: materialized view cannot use prebuilt table
- ORA-12059: prebuilt table "[string]"."[string]" does not exist
- ORA-12060: shape of prebuilt table does not match definition query
- ORA-12061: invalid ALTER MATERIALIZED VIEW option
- ORA-12062: transaction [string] received out of sequence from site [string]
- ORA-12063: unable to apply transaction from site [string]
- ORA-12064: invalid refresh sequence number: [string]
- ORA-12065: unknown refresh group identifier [string]
- ORA-12066: invalid CREATE MATERIALIZED VIEW command
- ORA-12067: empty refresh groups are not allowed
- ORA-12068: updatable mview log for mview "[string]"."[string]" does not exist
- ORA-12069: invalid object for offline instantiation
- ORA-12070: cannot offline instantiate materialized view "[string]"."[string]"
- ORA-12071: definition query of "[string]"."[string]" is invalid for offline instantiation
- ORA-12072: updatable materialized view log data for "[string]"."[string]" cannot be created
- ORA-12073: request cannot be processed
- ORA-12074: invalid memory address
- ORA-12075: invalid object or field
- ORA-12076: invalid threshold value
- ORA-12077: temporary updatable materialized view log does not exist
- ORA-12078: fast refresh of refresh group ID [string] failed
- ORA-12081: update operation not allowed on table "[string]"."[string]"
- ORA-12082: "[string]"."[string]" cannot be index organized
- ORA-12083: must use DROP MATERIALIZED VIEW to drop "[string]"."[string]"
- ORA-12084: must use ALTER MATERIALIZED VIEW to alter "[string]"."[string]"
- ORA-12085: materialized view log on "[string]"."[string]" already has object id
- ORA-12086: table "[string]"."[string]" is not an object table
- ORA-12087: online redefinition not allowed on tables owned by "[string]"
- ORA-12088: cannot online redefine table "[string]"."[string]" with unsupported datatype
- ORA-12089: cannot online redefine table "[string]"."[string]" with no primary key
- ORA-12090: cannot online redefine table "[string]"."[string]"
- ORA-12091: cannot online redefine table "[string]"."[string]" with materialized views
- ORA-12092: cannot online redefine replicated table "[string]"."[string]"
- ORA-12093: invalid interim table "[string]"."[string]"
- ORA-12094: error during online redefinition
- ORA-12096: error in materialized view log on "[string]"."[string]"
- ORA-12097: changes in the master tables during refresh, try refresh again
- ORA-12098: cannot comment on the materialized view
- ORA-12100: materialized view log on "[string]"."[string]" already has sequence