Chapter 19. 21000 ~ 21999

Chapter 19. 21000 ~ 21999
Prev		Next

Chapter 19. 21000 ~ 21999

21001: Unable to start transaction.

Cause	Cannot start the transaction.
Action	Check the cause of the failure and try again.

21002: No more undo space available.

Cause	Insufficient space remains in the undo tablespace.
Action	Free up space in the tablespace and specify autoextend in the datafile.

21003: Snapshot is too old.

Cause	The snapshot is too old to read.
Action	Check the cause of the failure and try again.

21004: No more extent available in tablespace '%1$s'.

Cause	Unable to create an additional extent in this table.
Action	Free up space in the tablespace and specify autoextend in the datafile.

21005: Unable to initialize datafile %1$s ('%2$d' in tablespace '%3$s').

Cause	Cannot initialize the datafile.
Action	Check the properties of the datafile.

21006: Unable to extend datafile '%1$d' in tablespace '%2$s'.

Cause	Cannot extend the datafile.
Action	Adjust the datafile so that it can be extended.

21007: Unable to shrink datafile '%1$d' in tablespace '%2$s'.

Cause	Cannot shrink the datafile.
Action	Remove segments occupying the datafile and then try again.

21008: Savepoint '%1$s' was not found.

Cause	The specified savepoint does not exist.
Action	Specify a valid savepoint.

21009: No tempfile was found.

Cause	No file exists in the temporary tablespace.
Action	Add files in the temporary tablespace and then try again.

21010: Tablespace %1$s was not found.

Cause	The specified tablespace does not exist.
Action	Specify a valid tablespace.

21011: Seqno overflow: %1$d undo segment.

Cause	Cannot continue to increase the sequence numbers of undo segments. The transaction is too long.
Action	Raise the uniform size of the undo tablespace, or use the AUTOALLOCATE option.

21012: Unable to serialize access for this transaction.

Cause	An attempt was made to access the modified data after the transactions began.
Action	The transaction is not accessible.

21013: Undo segment was not found in the UNDO tablespace.

Cause	The undo segment does not exist.
Action	Specify a valid undo segment.

21014: No space available in SYSTEM tablespace.

Cause	Cannot extend the undo segment of SYSTEM tablespace.
Action	Increase the size of the SYSTEM tablespace.

21015: Unable to create a system undo segment.

Cause	Unable to create an undo segment in the SYSTEM tablespace.
Action	Check the cause of the failure and try again.

21016: Insufficient processes (%1$d) for transaction recovery (at least %2$d needed).

Cause	Cannot recover non-committed transactions. The number of processes is insufficient.
Action	Increase the number of working processes and threads.

21017: Unable to bring undo segment (#%1$d) on/offline: %2$s.

Cause	Cannot bring the undo segment online or offline.
Action	Specify a valid segment.

21018: Undo segment was not found: '%1$d'.

Cause	The specified undo segment does not exist.
Action	Specify a valid segment.

21019: Lock held by in-doubt distributed transaction.

Cause	Lock is held by an in-doubt transaction.
Action	Fix the in-doubt transaction and then try again.

21020: Unable to specify undo tablespace %1$s as default undo tablespace.

Cause	The specified undo tablespace cannot be used as the default undo tablespace.
Action	Ensure that the specified tablespace is an undo tablespace and is not dropped or offline.

21021: Unable to use tablespace %1$d.

Cause	Cannot use the specified temporary tablespace because it was dropped or currently being dropped.
Action	Specify another temporary tablespace.

21022: No prepared transaction found with transaction ID %1$s.

Cause	Cannot find a prepared transaction with the requested transaction ID.
Action	Specify a valid ID.

21023: Unable to execute specified operation during TX recovery.

Cause	Cannot execute the operation because transaction is not completely recovered.
Action	Try again after the transaction recovery is complete.

21024: Unable to begin new transaction in current server mode.

Cause	Tasks cannot be performed in the current server mode.
Action	Start the server in NORMAL mode and then execute the task.

21025: Unable to extend segment: maximum number of extensions reached.

Cause	The number of extensions has reached the maximum limit specified in the segment.
Action	Raise the value of the MAXEXTENTS property of the segment.

21026: Sequence of undo segment %1$d has limit of %2$d.

Cause	The undo segment does not exist.
Action	Check the cause of the failure and try again.

21027: Unable to use temp tablespace in current server mode.

Cause	Cannot use a temporary tablespace in the current server mode.
Action	Start the server in NORMAL mode.

21028: Unable to bring minimum number of undo segments online.

Cause	The number of online undo segments exceeded the maximum limit.
Action	Increase the value of _USGMT_ONLINE_MAX parameter, or decrease the value of _USGMT_ONLINE_MIN parameter.

21029: Invalid specification for UNDO_TABLESPACE parameter.

Cause	The UNDO_TABLESPACE parameter is specified incorrectly.
Action	Specify a valid value in the UNDO_TABLESPACE parameter.

21030: DML operation is not permitted.

Cause	DML operation is not permitted.
Action	The transaction has been opened in read-only mode. Commit or roll back before trying again.

21031: Cannot allocate ITL for PE transaction.

Cause	Failed to allocate ITL for PE transaction.
Action	Try again.

21032: Failed to perform two-phase commit for the massive cluster system.

Cause	Failed in the slave node. The corresponding slave tx has failed.
Action	Check the reason and whether the slave node is alive. Try again.

21033: Cannot access a transaction (%1$d.%2$d.%3$d).

Cause	Cannot access a transaction (%1$d.%2$d.%3$d).
Action	Commit or roll back the transaction and then try again. Or make the status of the corresponding offline tablespace online.

21034: There is no snapshot that corresponds to the specified time.

Cause	There is no value that corresponds to the specified time in the mapping table.
Action	Increase the value of UNDO_RETENTION to store more snapshots.

21038: Unable to drop the datafile %1$s ('%2$s' in tablespace '%3$s').

Cause	Unable to drop the datafile.
Action	Check the properties of the datafile.

21039: User '%1$s' cannot be allocated an additional %2$d blocks within the '%3$s' tablespace.

Cause	Due to the quota configuration, additional blocks cannot be allocated within the tablespace.
Action	Check the quota configuration.

21040: Unable to execute specified operation during in-doubt TX recovery.

Cause	Cannot execute the operation because in-doubt transaction is not completely recovered.
Action	Fix the in-doubt transaction and then try again.

21042: Unable to begin new transaction in read only server mode.

Cause	Tasks cannot be performed in the current server mode.
Action	Start the server in READ WRITE mode and then execute the task.

21043: No such temprary file exists in the temporary tablespace.

Cause	No such temprary file exists in the temporary tablespace.
Action	Check the file name.

Prev		Next
Chapter 18. 19000 ~ 19999	Home	Chapter 20. 22000 ~ 22999