Oracle Error Messages: 02/14/12

Tuesday, 14 February 2012

ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group

ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group

Cause: An attempt was made to offline a tablespace in the default database temporary tablespace group.

Action: Either change the database default temporary tablespace or change the tablespace group of this tablespace.

ORA-10919: Default temporary tablespace group must have at least one tablespace

ORA-10919: Default temporary tablespace group must have at least one tablespace

Cause: An attempt was made to move the only tablespace in the default database temporary tablespace group to another tablespace group.

Action: Either change the database default temporary tablespace or add another tablespace to the group that this tablespace belongs to.

ORA-10918: TABLESPACE GROUP name cannot be the same as tablespace name

ORA-10918: TABLESPACE GROUP name cannot be the same as tablespace name

Cause: The tablespace group name specified in the command is the same as the tablespace being CREATEd or ALTERed.

Action: Please specify an appropriate tablespace group name.

ORA-10917: TABLESPACE GROUP cannot be specified

ORA-10917: TABLESPACE GROUP cannot be specified

Cause: The tablespace name specified in the command is actually the name of a tablespace group.

Action: Please specify an appropriate tablespace name.

ORA-10916: TABLESPACE GROUP already specified

ORA-10916: TABLESPACE GROUP already specified

Cause: In CREATE or ALTER TABLESPACE, the TABLESPACE GROUP option was specified more than once.

Action: Remove all but one of the TABLESPACE GROUP specifications.

ORA-10915: TABLESPACE GROUP cannot be specified for this type of tablespace

ORA-10915: TABLESPACE GROUP cannot be specified for this type of tablespace

Cause: In CREATE or ALTER TABLESPACE, the TABLESPACE GROUP clause was used while creating or altering a tablespace that is not TEMPORARY.

Action: Remove the TABLESPACE GROUP clause.

ORA-10914: invalid TABLESPACE GROUP clause

ORA-10914: invalid TABLESPACE GROUP clause

Cause: An invalid option appears for TABLESPACE GROUP clause.

Action: Specify a valid tablespace group name.

ORA-10906: Unable to extend segment after insert direct load

ORA-10906: Unable to extend segment after insert direct load

Cause: This is a restriction with insert direct load transactions.

Action: When a segment has been insert direct loaded, avoid DMLs that could cause more space to be consumed.

ORA-10902: disable seghdr conversion for ro operation

ORA-10902: disable seghdr conversion for ro operation

Cause: causes seghdr conversion to be turned off for ro ops(#555856)

Action: this should be enabled only if determined that bug 555856 has occured. Table needs to be exported subsequently

ORA-10900: extent manager fault insertion event #string

ORA-10900: extent manager fault insertion event #string

Cause: causes faults to be generated in instrumented extent code

Action: this should only be enabled for internal testing

ORA-10865: Control tracing of notification operations

ORA-10865: Control tracing of notification operations

Cause: NA

Action: THIS IS NOT A USER ERROR NUMBER or MESSAGE. THIS DOES NOT NEED TO BE TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.

ORA-10863: Control behavior of buffered background operations

ORA-10863: Control behavior of buffered background operations

Cause: NA

Action: THIS IS NOT A USER ERROR NUMBER or MESSAGE. THIS DOES NOT NEED TO BE TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.

ORA-10862: resolve default queue owner to current user in enqueue or dequeue

ORA-10862: resolve default queue owner to current user in enqueue or dequeue

Cause: resolve default queue owner to current user in enqueue or dequeue.

Action: turn on if client wish to resolve the default queue owner to the current user. If not turned on, the default queue owner will be resolved to the login user.

ORA-10854: Sets poll count used for AQ listen code under RAC

ORA-10854: Sets poll count used for AQ listen code under RAC

Cause: NA

Action: THIS IS NOT A USER ERROR NUMBER or MESSAGE. THIS DOES NOT NEED TO BE TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.

ORA-10852: Enable tracing for Enqueue Dequeue Operations

ORA-10852: Enable tracing for Enqueue Dequeue Operations

Cause: NA

Action: THIS IS NOT A USER ERROR NUMBER or MESSAGE. THIS DOES NOT NEED TO BE TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL TESTING.

ORA-10842: Event for OCI Tracing and Statistics Info

ORA-10842: Event for OCI Tracing and Statistics Info

Cause: This event is meant for tracing OCI Calls and getting statistics

Action: This event sets tracing OCI Calls and gets statistics info

ORA-10841: Default un-inintialized charact set form to SQLCS_IMPLICIT

ORA-10841: Default un-inintialized charact set form to SQLCS_IMPLICIT

Cause: client side, such as JDBC-THIN 8i client sends 0 as charset form

Action: This event sets charset form as SQLCS_IMPLICIT when it is 0

ORA-10707: Simulate process death for instance registration

ORA-10707: Simulate process death for instance registration

Cause: When enabled, process commits suicide to test instance registration recovery code.

Action: Level indicates where the process will die

ORA-10706: Print out information about global enqueue manipulation

ORA-10706: Print out information about global enqueue manipulation

Cause: When enabled, prints out activity in ksi routines.

Action: Level indicates details: 0-4: show args for each main call 5-9: also indicate callbacks 10+: also printout time for each line

ORA-10704: Print out information about what enqueues are being obtained

ORA-10704: Print out information about what enqueues are being obtained

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

ORA-10701: Dump direct loader index keys

ORA-10701: Dump direct loader index keys

Cause: Dumps index keys at various points in a direct load based on the value of this event.

Action: none

ORA-10700: Alter access violation exception handler

ORA-10700: Alter access violation exception handler

Cause: Use this event to control what the VMS exception handler does when it encounters an access violation.

Action: Level: lamp;gt;=10 Suspend current process on access violation *** SET THIS EVENT ONLY UNDER THE SUPERVISION OF ORACLE DEVELOPMENT ***

ORA-10691: Set background process core file type (Unix only)

ORA-10691: Set background process core file type (Unix only)

Cause: Control core file size file for background processes

Action: Level 1: Detach SGA before dumping core

ORA-10690: Set shadow process core file dump type (Unix only)

ORA-10690: Set shadow process core file dump type (Unix only)

Cause: Control core file size for shadow processes

Action: Level 1: Detach SGA before dumping core Level 2: Do not produce any core

ORA-10668: Inject Evil Identifiers

ORA-10668: Inject Evil Identifiers

Cause: event 10668 is set to some number lamp;gt; 0, causing 1 or (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

ORA-10665: Inject Evil Literals

ORA-10665: Inject Evil Literals

Cause: Event 10665 is set to some number lamp;gt; 0, causing 1 or (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-10664: Table has bitmap join indexes

ORA-10664: Table has bitmap join indexes

Cause: SHRINK was issued on a table with bitmap join indexes.

Action: Drop bitmap join indexes and reissue SHRINK on the object.

ORA-10663: Object has rowid based materialized views

ORA-10663: Object has rowid based materialized views

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

ORA-10662: Segment has long columns

ORA-10662: Segment has long columns

Cause: Shrink was issued on a segment with long columns. This is not supported.

Action: none

ORA-10661: Invalid option specified

ORA-10661: Invalid option specified

Cause: Check option can be specified for one segment only

Action: none

ORA-10660: Segment is a shared lob segment

ORA-10660: Segment is a shared lob segment

Cause: Shrink was issued on a segment that was being shared by multiple lob columns

Action: none

ORA-10659: Segment being shrunk is not a lob

ORA-10659: Segment being shrunk is not a lob

Cause: Shrink was issued on a segment that should be a first class lob or other data type stored in lob

Action: none

ORA-10658: Lob column to be shrunk is marked unused

ORA-10658: Lob column to be shrunk is marked unused

Cause: Shrink was issued on a lob segment that is marked as unused

Action: none

ORA-10657: Lob column to be shrunk does not exist

ORA-10657: Lob column to be shrunk does not exist

Cause: Shrink was issued on a lob segment that did not exist

Action: none

ORA-10656: Table is in unusable state due to incomplete operation

ORA-10656: Table is in unusable state due to incomplete operation

Cause: ALTER TABLE SHRINK operation was tried on the table which is in unusable state because of previously failed or incomplete operation.

Action: If the previous operation was

ORA-10655: Segment can be shrunk

ORA-10655: Segment can be shrunk

Cause: Error message returned when called in probe mode by OEM

Action: none

ORA-10654: Table is of type temporary or external

ORA-10654: Table is of type temporary or external

Cause: It is illegal to shrink a temporary table or an external table

Action: none

ORA-10653: Table is in a cluster

ORA-10653: Table is in a cluster

Cause: It is illegal to shrink a table belonging to a cluster

Action: none

ORA-10652: Object has on-commit materialized views

ORA-10652: Object has on-commit materialized views

Cause: It is illegal to issue shrink on an object with on-commit materialized views

Action: none

ORA-10651: incorrect file number block number specified

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

ORA-10648: Tablespace SYSAUX is not offline

ORA-10648: Tablespace SYSAUX is not offline

Cause: The SYSAUX tablespace was online while SYSTEM tablespace was being migrated.

Action: Alter the SYSAUX tablespace status to offline and retry migration.

ORA-10647: Tablespace other than SYSTEM, string, string not found in read only mode

ORA-10647: Tablespace other than SYSTEM, string, string not found in read only mode

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.

ORA-10646: Too many recursive extensions during SYSTEM tablespace migration

ORA-10646: Too many recursive extensions during SYSTEM tablespace migration

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.

ORA-10645: Recursive Extension in SYSTEM tablespace during migration

ORA-10645: Recursive Extension in SYSTEM tablespace during migration

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.

ORA-10644: SYSTEM tablespace cannot be default temporary tablespace

ORA-10644: SYSTEM tablespace cannot be default temporary tablespace

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.

ORA-10643: Database should be mounted in restricted mode and Exclusive mode

ORA-10643: Database should be mounted in restricted mode and Exclusive mode

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.

ORA-10642: Found rollback segments in dictionary managed tablespaces

ORA-10642: Found rollback segments in dictionary managed tablespaces

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

ORA-10641: Cannot find a rollback segment to bind to

ORA-10641: Cannot find a rollback segment to bind to

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.

ORA-10640: Operation not permitted during SYSTEM tablespace migration

ORA-10640: Operation not permitted during SYSTEM tablespace migration

Cause: SYSTEM tablespace is being migrated to locally managed format.

Action: Reissue this command once SYSTEM tablespace migration is over.

ORA-10639: Dump library cache during kksfbc-reparse-infinite-loop error

ORA-10639: Dump library cache during kksfbc-reparse-infinite-loop error

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.

ORA-10638: Index status is invalid

ORA-10638: Index status is invalid

Cause: Cannot shrink an index which is being rebuilt or disabled is an unusable state.

Action: none

ORA-10637: The segment does not exist

ORA-10637: The segment does not exist

Cause: Segment to be shrunk has been dropped

Action: none

ORA-10636: ROW MOVEMENT is not enabled

ORA-10636: ROW MOVEMENT is not enabled

Cause: To shrink a data segment, row movement must be enabled.

Action: Enable row movement and reissue this command.

ORA-10635: Invalid segment or tablespace type

ORA-10635: Invalid segment or tablespace type

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