Friday 18 May 2012

ORA-30060: Internal event for RECO tracing

ORA-30060: Internal event for RECO tracing

Cause: internal use only

Action: none

ORA-30055: NULL snapshot expression not allowed here

ORA-30055: NULL snapshot expression not allowed here

Cause: The snapshot expression is NULL.

Action: Specify a non-NULL snapshot expression.

ORA-30054: invalid upper limit snapshot expression

ORA-30054: invalid upper limit snapshot expression

Cause: The upper limit snapshot expression is less than the lower limit snapshot expression.

Action: Specify a valid upper limit snapshot expression.

ORA-30053: invalid upper limit snapshot expression

ORA-30053: invalid upper limit snapshot expression

Cause: The upper limit snapshot expression is greater than the SQL statement read snapshot.

Action: Specify a valid upper limit snapshot expression.

ORA-30052: invalid lower limit snapshot expression

ORA-30052: invalid lower limit snapshot expression

Cause: The lower limit snapshot expression was below the UNDO_RETENTION limit.

Action: Specify a valid lower limit snapshot expression.

ORA-30051: VERSIONS clause not allowed here

ORA-30051: VERSIONS clause not allowed here

Cause: A VERSIONS clause was specified when it was not allowed.

Action: Do not use the VERSIONS clause

ORA-30049: Internal event for TA enq tracing

ORA-30049: Internal event for TA enq tracing

Cause: internal use only

Action: none

ORA-30048: Internal event for IMU auto-tuning

ORA-30048: Internal event for IMU auto-tuning

Cause: internal use only

Action: none

ORA-30047: Internal event for kti tracing

ORA-30047: Internal event for kti tracing

Cause: internal use only

Action: none

ORA-30046: Undo tablespace string not found in control file.

ORA-30046: Undo tablespace string not found in control file.

Cause: The specified undo tablespace is not present in the control file.

Action: Modify the CREATE CONTROLFILE statement that created the current control file to include undo tablespace(s) and reissue the statement.

ORA-30045: No undo tablespace name specified

ORA-30045: No undo tablespace name specified

Cause: If Create Database has the datafile clause, then undo tablespace name has to be specified, unless using OMF.

Action: Specify the undo tablespace name.

ORA-30044: Retention can only specified for undo tablespace

ORA-30044: Retention can only specified for undo tablespace

Cause: An attempt was made to specify retention for a non-undo tablespace.

Action: Modify the CREATE TABLESPACE statement.

ORA-30043: Invalid value string specified for parameter Undo_Management

ORA-30043: Invalid value string specified for parameter Undo_Management

Cause: the specified undo management mode is invalid

Action: Correct the parameter value in the initialization file and retry the operation.

ORA-30042: Cannot offline the undo tablespace

ORA-30042: Cannot offline the undo tablespace

Cause: Cannot offline an undo tablespace that is in use

Action: Switch to a different undo tablespace and then try to offline

ORA-30041: Cannot grant quota on the tablespace

ORA-30041: Cannot grant quota on the tablespace

Cause: User tried to grant quota on an undo or temporary tablespace

Action: Check the tablespace name and reissue the command

ORA-30040: Undo tablespace is offline

ORA-30040: Undo tablespace is offline

Cause: Cannot operate on an offlined undo tablespace

Action: Online the undo tablespace and redo the operation

ORA-30039: Cannot drop the undo tablespace

ORA-30039: Cannot drop the undo tablespace

Cause: Cannot drop an undo tablespace that is in use

Action: Switch to a different undo tablespace and then try to drop

ORA-30038: Cannot perform parallel insert on non-partitioned object

ORA-30038: Cannot perform parallel insert on non-partitioned object

Cause: Attempt to perform parallel insert on a non-partitioned object after a previous DML on the object in the same transaction.

Action: Commit before issueing the insert.

ORA-30037: Cannot perform parallel DML after a prior DML on the object

ORA-30037: Cannot perform parallel DML after a prior DML on the object

Cause: Attempt to perform parallel DML after another DML on the same object in the same transaction.

Action: Use bitmap segments to perform multiple (parallel) DML operations on the same object. Or commit before issueing the DML

ORA-30036: unable to extend segment by string in undo tablespace string

ORA-30036: unable to extend segment by string in undo tablespace string

Cause: the specified undo tablespace has no more space available.

Action: Add more space to the undo tablespace before retrying the operation. An alternative is to wait until active transactions to commit.

ORA-30035: Undo tablespace cannot be specified as default temporary tablespace

ORA-30035: Undo tablespace cannot be specified as default temporary tablespace

Cause: Undo tablespace cannot be specified as default temporary tablespace for the database

Action: Check the tablespace name and reissue the command

ORA-30034: Undo tablespace cannot be specified as temporary tablespace

ORA-30034: Undo tablespace cannot be specified as temporary tablespace

Cause: Undo tablespace cannot be specified as default temporary tablespace for the user

Action: Check the tablespace name and reissue the command

ORA-30033: Undo tablespace cannot be specified as default user tablespace

ORA-30033: Undo tablespace cannot be specified as default user tablespace

Cause: It is incorrect to specify undo tablespace as default user tablespace

Action: Check the tablespace name and reissue the command

ORA-30032: the suspended (resumable) statement has timed out

ORA-30032: the suspended (resumable) statement has timed out

Cause: A correctible error was signaled in the resumable session and the error was not cleared within the timeout interval.

Action: Fix the correctible error within the timeout. Default is 2 hours. Or increase the (resumable) timeout.

ORA-30031: the suspended (resumable) statement has been aborted

ORA-30031: the suspended (resumable) statement has been aborted

Cause: DBA or the user aborted the execution of the suspended statement in the resumable session

Action: none

ORA-30030: suppress resumable related error message

ORA-30030: suppress resumable related error message

Cause: none

Action: This event is to be used if the errors 30031 and 30032 wish to be suppressed.

ORA-30029: no active undo tablespace assigned to instance

ORA-30029: no active undo tablespace assigned to instance

Cause: the current instance does not have an active undo tablespace assigned to execute transactions.

Action: ask DBA to create an undo tablespace, online the undo tablespace and then retry operation.

ORA-30028: Automatic Undo Management event for NTP testing

ORA-30028: Automatic Undo Management event for NTP testing

Cause: test events for internal use only

Action: none.

ORA-30027: Undo quota violation - failed to get string (bytes)

ORA-30027: Undo quota violation - failed to get string (bytes)

Cause: the amount of undo assigned to the consumer group of this session has been exceeded.

Action: ask DBA to increase undo quota, or wait until other transactions to commit before proceeding.

ORA-30026: Undo tablespace string has unexpired undo with string(sec) left, Undo_Retention=string(sec)

ORA-30026: Undo tablespace string has unexpired undo with string(sec) left, Undo_Retention=string(sec)

Cause: Tried to drop a tablespace that contains unexpired undo information

Action: lower setting of UNDO_RETENTION or wait a while before reissue command to drop undo tablespace

ORA-30025: DROP segment string (in undo tablespace) not allowed

ORA-30025: DROP segment string (in undo tablespace) not allowed

Cause: Explicit DROP operation is not allowed on undo tablespace segments

Action: Check the undo segment name and reissue statement if necessary.

ORA-30024: Invalid specification for CREATE UNDO TABLESPACE

ORA-30024: Invalid specification for CREATE UNDO TABLESPACE

Cause: You have specified an clause that should not used with CREATE UNDO TABLESPACE

Action: Drop the clause from the command and reissue it.

ORA-30023: Duplicate undo tablespace specification

ORA-30023: Duplicate undo tablespace specification

Cause: Cannot create more than one undo tablespace during database creation

Action: Modify the command to contain only one undo tablespace

ORA-30022: Cannot create segments in undo tablespace

ORA-30022: Cannot create segments in undo tablespace

Cause: Cannot create segments in undo tablespace

Action: Check the tablespace name and reissue command

ORA-30021: Operation not allowed on undo tablespace

ORA-30021: Operation not allowed on undo tablespace

Cause: This operation is not allowed on undo tablespaces

Action: Check the tablespace name and reissue command if necessary

ORA-30020: UNDO_MANAGEMENT=AUTO needs Compatibility string or greater

ORA-30020: UNDO_MANAGEMENT=AUTO needs Compatibility string or greater

Cause: Auto undo management mode not allowed in specified compatibility release

Action: restart instance in correct compatibility release

ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

Cause: This operation only allowed in Manual Undo mode.

Action: restart instance in Manual Undo_Management mode and retry operation.

ORA-30018: Create Rollback Segment failed, USN string is out of range

ORA-30018: Create Rollback Segment failed, USN string is out of range

Cause: the system runs out of undo segment number. Too many undo segments exist.

Action: drop some of the unused undo segments and retry operation.

ORA-30017: segment string is not supported in string Undo Management mode

ORA-30017: segment string is not supported in string Undo Management mode

Cause: the type of the specified undo segment is incompatible with the current undo management mode of the instance.

Action: Check the undo segment name and the undo management mode and reissue statement if necessary.

ORA-30016: undo tablespace string is already in use by this instance

ORA-30016: undo tablespace string is already in use by this instance

Cause: the specified undo tablespace is currently used by this instance. The operation failed.

Action: If the specified undo tablespace name is wrong, reissue the statement with the correct name.

ORA-30015: previously offlined undo tablespace string is still pending

ORA-30015: previously offlined undo tablespace string is still pending

Cause: the current operation is not allowed because an undo tablespace containing active transactions is pending from a previous SWITCH UNDO operation. The operation will be allowed again after all transactions in the previous undo tablespace are committed.

Action: Wait for all previous transactions to commit before reissuing the current statement.

ORA-30014: operation only supported in Automatic Undo Management mode

ORA-30014: operation only supported in Automatic Undo Management mode

Cause: the operation is only supported in automatic undo mode.

Action: restart instance in Automatic Undo Management mode before retrying operation.

ORA-30013: undo tablespace string is currently in use

ORA-30013: undo tablespace string is currently in use

Cause: the specified undo tablespace is currently used by another instance.

Action: Wait for the undo tablespace to become available or change to another name and reissue the statement.

ORA-30012: undo tablespace string does not exist or of wrong type

ORA-30012: undo tablespace string does not exist or of wrong type

Cause: the specified undo tablespace does not exist or of the wrong type.

Action: Correct the tablespace name and reissue the statement.

ORA-30011: Error simulated: psite=string, ptype=string

ORA-30011: Error simulated: psite=string, ptype=string

Cause: error generated for testing purposes.

Action: None.

ORA-30006: resource busy; acquire with WAIT timeout expired

ORA-30006: resource busy; acquire with WAIT timeout expired

Cause: The requested resource is busy.

Action: Retry the operation later.

ORA-30005: missing or invalid WAIT interval

ORA-30005: missing or invalid WAIT interval

Cause: A non-zero integer must be specified for wait interval (in seconds) after the WAIT keyword.

Action: Correct the syntax and retry.

ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here

ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here

Cause: SYS_CONNECT_BY_PATH function is called at places other than select list.

Action: Remove calls to SYS_CONNECT_BY_PATH function at places other than select list.

ORA-30001: trim set should have only one character

ORA-30001: trim set should have only one character

Cause: Trim set contains more or less than 1 character. This is not allowed in TRIM function.

Action: Change trim set to have only 1 character.

ORA-30000: missing either trim specification or char expression in TRIM

ORA-30000: missing either trim specification or char expression in TRIM

Cause: Since FROM is specified in TRIM function, either trim specification (TRAILING, HEADING, BOTH) or trim character or both must be specified.

Action: Add either trim specification (TRAILING, HEADING, BOTH) or trim character or both.

ORA-29975: Cannot register a query in the middle of an active transaction

ORA-29975: Cannot register a query in the middle of an active transaction

Cause: User tried to register a query within an uncommitted transction.

Action: Commit the transaction and retry.

ORA-29974: Internal event for PL or SQL debugging

ORA-29974: Internal event for PL or SQL debugging

Cause: None

Action: none

ORA-29973: Unsupported query or operation during change notification registration

ORA-29973: Unsupported query or operation during change notification registration

Cause: The user attempted to register an unsupported query type or an unsupported operation like a DML or DDL for change notification.

Action: Please check the statement being executed and refer to the documentation.

ORA-29972: user does not have privilege to change or create registration

ORA-29972: user does not have privilege to change or create registration

Cause: User passed in an incorrect or someone else s regid or handle.

Action: Check the passed in regid or reg handle

ORA-29971: Specified table name not found or does not have any registrations

ORA-29971: Specified table name not found or does not have any registrations

Cause: The database could not locate the passed in table name

Action: CHeck the table name passed in.

ORA-29970: Specified registration id does not exist

ORA-29970: Specified registration id does not exist

Cause: An incorrect regid value was passed to dbms_chnf procedure.

Action: pass the correct regid value.

ORA-29968: No primary operator bindings found for ancillary binding #string

ORA-29968: No primary operator bindings found for ancillary binding #string

Cause: At least one ancillary binding of the specified operator could not be validated because all of its associated primary operator bindings have been dropped.

Action: Either drop the ancillary binding whose primary operators are missing, or drop the entire operator, if this is the only binding. This binding cannot be re-validated.

ORA-29967: Cannot drop an operator binding with dependent objects

ORA-29967: Cannot drop an operator binding with dependent objects

Cause: The operator binding that is being dropped has dependent objects.

Action: Either drop the dependent objects first and then issue the ALTER OPERATOR DROP BINDING command or specify the FORCE option with ALTER OPERATOR DROP BINDING.

ORA-29966: The only binding of an operator cannot be dropped

ORA-29966: The only binding of an operator cannot be dropped

Cause: This operator only has one binding. It cannot be dropped using Alter Operator Drop Binding.

Action: If you wish to drop the entire operator, call Drop Operator.

ORA-29965: The specified binding does not exist

ORA-29965: The specified binding does not exist

Cause: The binding specified in the DROP BINDING clause is not a valid binding for this operator.

Action: Specify an existing binding for this op in DROP BINDING clause.