Oracle 12c R2 Error Codes and Solution Suggestions from ORA-10614 to ORA-10707
- ORA-10614: Operation not allowed on this segment
Cause: This procedure can be used only on segments in tablespaces with AUTO SEGMENT SPACE MANAGEMENT
Action: Recheck the segment name and type and re-issue the statement
Cause: Tablespace with AUTO SEGMENT SPACE MANAGENEMT specified cannot be used as a temporary tablespace
Action: Recheck the tablespace name and re-issue the statement
Cause: Cannot perform the operation on tablespace with AUTO SEGMENT SPACE MANAGEMENT
Action: Recheck the tablespace name and re-issue the statement
Cause: Rollback segments cannot be created in dictionary managed tablespaces when SYSTEM tablespace is locally managed
Action: Recheck the tablespace name and re-issue the statement
Cause: This DBMS_SPACE operation is not permitted on segments in tablespaces with AUTO SEGMENT SPACE MANAGEMENT
Action: Recheck the segment name and type and re-issue the statement
Cause: A bug (or upgrade) hits unicode assertions (csid, csform, bfc)
Action: Event makes RDBMS skip assertions and patch up datastructures
Cause: Cannot alter freelist storage parameter for segments in tablespaces with AUTO SEGMENT SPACE MANAGEMENT
Action: Recheck the segment name and re-issue the statement
- ORA-10621: specify retry count for online index build cleanup DML lock get
- ORA-10624: Disable UJV invalidation on drop index
- ORA-10625: Turn off redo log dump for the index when OERI 12700
- ORA-10626: specify timeout for online index rebuild to wait for DML
- ORA-10627: Dump the content of the index leaf block
Cause: Generate a complete index tree dump, not just an overview during alter session set events immediate trace name treedump
Action: This event is recommended only for small table/index since it
Cause: Will do sanity checking on the kdiss state.
Action: set this event only under the supervision of Oracle development
- ORA-10629: force online index build to backoff and retry DML lock upgrade
- ORA-10630: Illegal syntax specified with SHRINK clause
Cause: An illegal option was specified with the SHRINK clause
Action: Verify the SQL Reference Manual and reissue the command
Cause: It is incorrect to issue shrink on the object
Action: Verify the object name and type and reissue the command
Cause: Segment Highwatermark was overwritten due to shrink and space reused
Action: Reissue this command.
Cause: Only one invocation of shrink can be in progress on a segment at any time
Action: Reissue the command after the first shrink is over
Cause: Cannot shrink the segment because it is not in auto segment space managed tablespace or it is not a data, index or lob segment.
Action: Check the tablespace and segment type and reissue the statement
Cause: To shrink a data segment, row movement must be enabled.
Action: Enable row movement and reissue this command.
Cause: Segment to be shrunk has been dropped
Action: n/a
Cause: Cannot shrink an index which is being rebuilt or disabled is an unusable state.
Action: n/a
Cause: During this error a library cache dump is necessary , so enable librarycache dump if event is set.
Action: Dump a library cache if this event is set when reparse error.
Cause: SYSTEM tablespace is being migrated to locally managed format.
Action: Reissue this command once SYSTEM tablespace migration is over.
Cause: SYSTEM tablespace migration requires rollback segment in locally managed tablespace.
Action: Drop rollback segments in dictionary managed tablespaces other than SYSTEM and create rollback segments in locally managed tablespace and retry migration.
Cause: When SYSTEM tablespace is migrated found rollback segments in dictionary managed tablespaces.
Action: Drop the rollback segments in dictionary managed tablespaces and reissue the command
Cause: When SYSTEM tablespace is being migrated database should be mounted in Exclusive mode and in Restricted mode.
Action: Reissue this command after mounting the database in right mode.
Cause: When SYSTEM tablespace is being migrated no user should have SYSTEM as the default temporary tablespace.
Action: Reissue this command after altering the default temporary tablespace setting for all users.
Cause: When SYSTEM tablespace is being migrated, dictionary tables tried to extend recursively. Must be caught and processed internally. Should not be thrown to the user.
Action: Report the error as a bug.
Cause: When SYSTEM tablespace is being migrated, dictionary tables tried to extend recursively more than 1000 times.
Action: If SYSTEM tablespace is very large, then simply reissue the tablespace migration command.
Cause: When SYSTEM tablespace is being migrated, tablespaces other than the three should be ALTERed to read only.
Action: Alter the tablespace status to read only and retry migration.
Cause: The SYSAUX tablespace was online while SYSTEM tablespace was being migrated.
Action: Alter the SYSAUX tablespace status to offline and retry migration.
Cause: Will turn off or trace lob index freelist coalescing
Action: set this event only under the supervision of Oracle development
- ORA-10650: disable cache-callback optimisation
- ORA-10651: incorrect file number block number specified
Cause: The dba specified is not valid
Action: Check if the dba specified belongs to the segment and is under the segment HWM and reissue the statement
Cause: It is illegal to issue shrink on an object with on-commit materialized views
Action: n/a
Cause: It is illegal to shrink a table belonging to a cluster
Action: n/a
Cause: It is illegal to shrink a temporary table or an external table
Action: n/a
Cause: Error message returned when called in probe mode by OEM
Action: n/a
Cause: ALTER TABLE SHRINK operation was tried on the table which is in unusable state because of previously failed/incomplete operation.
Action: If the previous operation was – DROP COLUMN, resubmit DROP COLUMN CONTINUE – DROP TABLE, resubmit DROP TABLE table PURGE
Cause: Shrink was issued on a lob segment that did not exist
Action: n/a
Cause: Shrink was issued on a lob segment that is marked as unused
Action: n/a
Cause: Shrink was issued on a segment that should be a first class lob or other data type stored in lob
Action: n/a
Cause: Shrink was issued on a segment that was being shared by multiple lob columns
Action: n/a
Cause: Check option can be specified for one segment only
Action: n/a
Cause: Shrink was issued on a segment with long columns. This is not supported.
Action: n/a
Cause: Shrink was issued on an object with rowid based materialized views.
Action: Drop the rowid based materialized views and issue shrink on the object
Cause: SHRINK was issued on a table with bitmap join indexes.
Action: Drop bitmap join indexes and reissue SHRINK on the object.
Cause: Event 10665 is set to some number > 0, causing 1/(value-1) of all literals to be replaced by 2000 letter ‘A’s. A value of 1 does not corrupt anything.
Action: never set this event
- ORA-10666: Do not get database enqueue name
- ORA-10667: Cause sppst to check for valid process ids
- ORA-10668: Inject Evil Identifiers
Cause: event 10668 is set to some number > 0, causing 1/(value-1) of all identifiers to be replaced by a maximum amount of x’s. It is common for an identifier to be parsed once with a max of 30 bytes, then reparsed later with a max of 4000, so it may not be possible to inject such an identifier without the aid of this event. A value of 1 causes no identifiers to be corrupted.
Action: never set this event
Cause: Control core file size for shadow processes
Action: Level 1: Detach SGA before dumping core Level 2: Do not produce any core
Cause: Control core file size file for background processes
Action: Level 1: Detach SGA before dumping core
Cause: Use this event to control what the VMS exception handler does when it encounters an access violation.
Action: Level: >=10 Suspend current process on access violation *** SET THIS EVENT ONLY UNDER THE SUPERVISION OF ORACLE DEVELOPMENT ***
Cause: Dumps index keys at various points in a direct load based on the value of this event.
Action: n/a
Cause: Enable application continuity debugging
Action: Level indicates details. Level: 0x0001: Transaction intention debugging 0x1000: Failure injection testing 0x2000: Failure injection testing 0x4000: Failure injection testing
Cause: When enabled, prints out arguments to calls to ksqcmi and ksqlrl and the return values.
Action: Level indicates details: Level: 1-4: print out basic info for ksqlrl, ksqcmi 5-9: also print out stuff in callbacks: ksqlac, ksqlop 10+: also print out time for each line
Cause: When enabled, prints out activity in ksi routines.
Action: INternal system parameter (_ksi_trace) can be used in addition to setting this event to limit output information on selected set of global enqueue server enqueue type(s) For example: _ksi_trace = RTXA output information only for RT and XA lock types. Level indicates details: 0-4: show args for each main call 5-9: also indicate callbacks 10+: also printout time for each line
Cause: When enabled, process commits suicide to test instance registration recovery code.
Action: Level indicates where the process will die