Oracle Database Errors or Warnings from Error ORA-24051 to ORA- 24060

SQLServerF1

ORA-24051: cannot propagate object type payloads that have a REF attribute
Cause: An ADD_SUBSCRIBER or ENQUEUE procedure with a non-NULL address field in the agent type was issued on a queue whose payload has a REF attribute. Propagation of object type payloads that have a REF attribute currently is not supported.
Action: Specify an agent with a NULL address field so that the agent can dequeue from the same queue. Or, change the object type definition to one that does not use REF attributes.
ORA-24052: cannot propagate object type payloads with LOB attributes to an 8.0 release
Cause: The recipient of a message with LOB attributes was using an Oracle 8.0 release. Propagation of LOB attributes is supported only in Oracle 8.1 and higher releases.
Action: Upgrade the target release to Oracle 8.1 and retry. Or, change the object type definition to one that does not use LOBs.
ORA-24053: PRIMARY_INSTANCE and SECONDARY_INSTANCE must be non-negative
Cause: One of PRIMARY_INSTANCE or SECONDARY_INSTANCE was negative.
Action: Specify non-negative integers for PRIMARY_INSTANCE and SECONDARY_INSTANCE.

ORA-24054: cannot propagate to an Oracle 8.0.3 release or lower release
Cause: The recipient of a message was using an Oracle 8.0.3 release or lower release. Propagation is supported only in Oracle 8.0.4 and higher releases.
Action: Upgrade the target release to Oracle 8.0.4 or higher and retry.
ORA-24055: cannot delete propagation status rows that are in prepared state
Cause: An attempt was made to use the internal administration procedure to delete status rows from the SYS.AQ$_PROPAGATION_STATUS table that were in the prepared state.
Action: Wait for the propagation to complete successfully before retrying the operation.
ORA-24056: internal inconsistency for QUEUE string and destination string
Cause: The sequence numbers used in the SYS.AQ$_PROPAGATION_STATUS table were inconsistent for the given queue and destination.
Action: Contact Oracle Worldwide Support.

ORA-24057: cannot define subscriber with rule for queue string
Cause: An ADD_SUBSCRIBER or ALTER_SUBSCRIBER procedure with a rule was issued on a queue for which rule based subscribers are not supported. Rule based subscribers currently are supported only for NORMAL (persistent) multi-consumer queues created using an Oracle release 8.1.0 or higher compatible queue table.
Action: Create a NORMAL multi-consumer queue in an Oracle release 8.1.0 or higher compatible queue table, and retry the call. Or, if the queue is a normal (persistent) multi-consumer queue, convert the queue table to Oracle 8.1.0 or higher compatibility and retry.
ORA-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state
Cause: An attempt was made to downgrade the queue table when there were messages being propagated that were in the prepared state.
Action: Wait for the propagation to complete before retrying the operation.
ORA-24059: invalid COMPATIBLE parameter setting string specified in DBMS_AQADM.string
Cause: An invalid compatible parameter was specified in the DBMS_AQADM procedure. The parameter setting must be of the form ‘8.x.y’ where x is the release number and y is the update number.
Action: Specify a valid COMPATIBLE parameter setting, and retry the operation.
ORA-24060: cannot convert QUEUE_TABLE, string already is compatible with release string
Cause: The source queue table in the DBMS_AQADM procedure is compatible with the specified COMPATIBLE parameter setting.
Action: Choose a different COMPATIBLE parameter setting to convert the queue table to the desired compatibility.

Above are list of Oracle Database Errors or Warnings from Error ORA-24051 to ORA-24060 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *