Oracle Error Messages: 04/18/12

Wednesday, 18 April 2012

ORA-24088: AQ Agent string does not exist

ORA-24088: AQ Agent string does not exist

Cause: This AQ Agent does not exist

Action: Specify a valid AQ agent. Check the DBA_AQ_AGENTS view for a list of valid aq agents

ORA-24087: Invalid database user string

ORA-24087: Invalid database user string

Cause: An invalid database username was specified

Action: Specify a valid database user

ORA-24086: cannot create a 8.0 compatible string queue

ORA-24086: cannot create a 8.0 compatible string queue

Cause: An attempt was made to create a 8.0 compatible queue table and enable a feature that is supported only on 8.1 style queue tables

Action: This feature is not supported

ORA-24085: operation failed, queue string is invalid

ORA-24085: operation failed, queue string is invalid

Cause: An attempt was made to enqueue, dequeue or administer a queue which is invalid. This could have occured because the payload type of the queue s queue table was dropped.

Action: Drop the queue table setting the force option to true.

ORA-24084: DBLINK name in address field of agent string is not unique within the first 24 bytes

ORA-24084: DBLINK name in address field of agent string is not unique within the first 24 bytes

Cause: Advanced Queuing requires that the agent s dblink name should be unique within the first 24 bytes (for 8.0 compatible queuetables)

Action: Specify a dblink name that is unique within the first 24 bytes or migrate to 8.1 compatible queuetables where this restriction is not there.

ORA-24083: cannot specify remote subscribers for string QUEUE string

ORA-24083: cannot specify remote subscribers for string QUEUE string

Cause: An add_subscriber call with a non-null address field was issued on a queue which does not support remote subscribers. Remote subscribers are not supported for NON_PERSISTENT QUEUES.

Action: Specify a null address field and retry the call.

ORA-24082: propagation may still be happening for the schedule for QUEUE string and DESTINATION string

ORA-24082: propagation may still be happening for the schedule for QUEUE string and DESTINATION string

Cause: The snapshot process executing the propagation schedule did not respond to the disable propagation command.

Action: Make sure that the job for the propagation schedule has been ended.

ORA-24081: compatible parameter needs to be string or greater

ORA-24081: compatible parameter needs to be string or greater

Cause: The compatible parameter was not high enough to allow the operation.

Action: shutdown and startup with a higher compatibility setting.

ORA-24080: unschedule_propagation pending for QUEUE string and DESTINATION string

ORA-24080: unschedule_propagation pending for QUEUE string and DESTINATION string

Cause: A propagation administration command was issued for a queue and destination pair whose propagation is being unscheduled.

Action: Do not issue propagation administration commands for a propagation schedule on which there is a pending unschedule request.

ORA-24079: invalid name string, names with AQ$_ prefix are not valid for string

ORA-24079: invalid name string, names with AQ$_ prefix are not valid for string

Cause: An attempt was made to use a reserved prefix for the object name.

Action: Enter a different name for this object. Then, retry the operation.

ORA-24078: cannot specify a non-NULL SECONDARY_INSTANCE if PRIMARY_ INSTANCE was NULL

ORA-24078: cannot specify a non-NULL SECONDARY_INSTANCE if PRIMARY_ INSTANCE was NULL

Cause: A non-NULL value was specified for SECONDARY_INSTANCE when PRIMARY_INSTANCE was NULL.

Action: Specify a non-NULL primary instance before you specify a non-NULL secondary instance.

ORA-24077: cannot create propagation schedule for EXCEPTION queue string.string

ORA-24077: cannot create propagation schedule for EXCEPTION queue string.string

Cause: A SCHEDULE_PROPAGATION was issued for an EXCEPTION queue. Propagation schedules can be created only for NORMAL queues.

Action: To propagate messages from a queue specify the queue type as NORMAL.

ORA-24076: cannot perform operation string for NON_PERSISTENT queue string.string

ORA-24076: cannot perform operation string for NON_PERSISTENT queue string.string

Cause: One of the operations, SCHEDULE_PROPAGATION, ALTER_QUEUE, LISTEN, DEQUEUE was issued for a NON_PERSISTENT queue.

Action: Do not specify a NON_PERSISTENT queue for these operations.

ORA-24075: cannot specify agent with NULL address and non-NULL protocol

ORA-24075: cannot specify agent with NULL address and non-NULL protocol

Cause: An ADD_SUBSCRIBER or enqueue was attemoted with an agent that had a NULL address and a non-NULL protocol.

Action: Either specify a non-NULL address or set the protocol to NULL.

ORA-24074: RETRY_DELAY and MAX_RETRIES cannot be used for exception queue %.string

ORA-24074: RETRY_DELAY and MAX_RETRIES cannot be used for exception queue %.string

Cause: The CREATE_QUEUE or ALTER_QUEUE command was issued with a non-zero RETRY_DELAY and an exception queue.

Action: Do not specify RETRY_DELAY or MAX_RETRIES for exception queues.

ORA-24073: cannot specify RETENTION_TIME on exception queue string.string

ORA-24073: cannot specify RETENTION_TIME on exception queue string.string

Cause: An attempt was made to create or alter an exception queue by specifying a non-zero RETENTION_TIME.

Action: Use the default RETENTION_TIME parameter value for exception queues.

ORA-24072: cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table

ORA-24072: cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table

Cause: An attempt was made to upgrade or downgrade a queue table using the DBMS_AQADM.MIGRATE_QUEUE_TABLE procedure, but the user who executed the procedure does not own the queue.

Action: Reconnect as the owner of the queue table, and then execute the DBMS_ AQADM.MIGRATE_QUEUE_TABLE procedure.

ORA-24071: cannot perform operation string, queue table string is being migrated

ORA-24071: cannot perform operation string, queue table string is being migrated

Cause: An attempt was made to perform an operation on a queue in a queue table that is being migrated.

Action: Complete the queue table migration, and retry the operation.

ORA-24070: cannot upgrade queue table string while it is being downgraded

ORA-24070: cannot upgrade queue table string while it is being downgraded

Cause: An attempt was made to upgrade a queue table, but a previous command to downgrade the queue table has not yet completed succesfully.

Action: Complete the downgrade of the queue table by re-executing the DBMS_ AQADM.MIGRATE_QUEUE_TABLE procedure. Then, upgrade the queue table.

ORA-24069: cannot downgrade queue table string while it is being upgraded

ORA-24069: cannot downgrade queue table string while it is being upgraded

Cause: An attempt was made to downgrade a queue table, but a previous command to upgrade the queue table has not yet completed successfully.

Action: Complete the upragde of the queue table by re-executing the DBMS_ AQADM.MIGRATE_QUEUE_TABLE procedure. Then, downgrade the queue table.

ORA-24068: cannot start queue string, queue table string is being migrated

ORA-24068: cannot start queue string, queue table string is being migrated

Cause: An attempt was made to start a queue in a queue table that is being migrated.

Action: Complete the queue table migration, and retry the operation.

ORA-24067: exceeded maximum number of subscribers for queue string

ORA-24067: exceeded maximum number of subscribers for queue string

Cause: An attempt was made to add new subscribers to the specified, but the number of subscribers for this queue has exceeded the maximum number (1024) of subscribers allowed per queue.

Action: Remove existing subscribers before trying to add new subscribers.

ORA-24066: invalid privilege specified

ORA-24066: invalid privilege specified

Cause: An invalid privilege is specified for granting or revoking privilege

Action: Specify a valid privilege.

ORA-24065: propagation for QUEUE string and DESTINATION string already disabled

ORA-24065: propagation for QUEUE string and DESTINATION string already disabled

Cause: A DISABLE_SCHEDULE_PROPAGATION command was issued for a queue and destination pair whose propagation schedule already was disabled.

Action: Make sure the QUEUE and DESTINATION are correct when you issue the DISABLE_SCHEDULE_PROPAGATION command.

ORA-24064: propagation for QUEUE string and DESTINATION string already enabled

ORA-24064: propagation for QUEUE string and DESTINATION string already enabled

Cause: An ENABLE_SCHEDULE_PROPAGATION command was issued for a queue and destination pair whose propagation schedule already was enabled.

Action: Make sure the QUEUE and DESTINATION are correct when you issue the ENABLE_SCHEDULE_PROPAGATION command.

ORA-24063: cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers

ORA-24063: cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers

Cause: An attempt was made to downgrade the queue table when there were queues on which rule based subscribers are defined.

Action: Remove the rule based subscribers for all queues in this queue table and retry.

ORA-24062: Subscriber table string inconsistent with queue table string

ORA-24062: Subscriber table string inconsistent with queue table string

Cause: The subscriber table has not yet been successfully imported.

Action: Import the subscriber table before attempting to use the queue table. If the import failed, correct the problem and try to import the subscriber table again.

ORA-24061: cannot specify non-zero SECONDARY_INSTANCE if PRIMARY_ INSTANCE was zero

ORA-24061: cannot specify non-zero SECONDARY_INSTANCE if PRIMARY_ INSTANCE was zero

Cause: A non-zero value was specified for SECONDARY_INSTANCE when PRIMARY_INSTANCE was zero.

Action: Specify a non-zero primary instance before you specify a non-zero secondary instance.

ORA-24060: cannot convert QUEUE_TABLE, string already is compatible with release string

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.

ORA-24059: invalid COMPATIBLE parameter setting string specified in DBMS_ AQADM.string

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-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state

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-24057: cannot define subscriber with rule for queue string

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-24056: internal inconsistency for QUEUE string and destination string

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-24055: cannot delete propagation status rows that are in prepared state

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-24054: cannot propagate to an Oracle 8.0.3 release or lower release

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-24053: PRIMARY_INSTANCE and SECONDARY_INSTANCE must be non-negative

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-24052: cannot propagate object type payloads with LOB attributes to an 8.0 release

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-24051: cannot propagate object type payloads that have a REF attribute

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-24050: subscribers are not supported for exception queue string

ORA-24050: subscribers are not supported for exception queue string

Cause: An ADD_SUBSCRIBER, ALTER_SUBSCRIBER, or REMOVE_ SUBSCRIBER procedure was issued on a queue that was created as an EXCEPTION_QUEUE.

Action: Specify a NORMAL_QUEUE in the procedure.

ORA-24049: invalid agent name string, names with AQ$_ prefix are not valid

ORA-24049: invalid agent name string, names with AQ$_ prefix are not valid

Cause: An attempt was made to use a reserved prefix in the agent name.

Action: Enter a different value for the agent name. Then, retry the operation.

ORA-24048: cannot create QUEUE_TABLE, user does not have access to AQ object types

ORA-24048: cannot create QUEUE_TABLE, user does not have access to AQ object types

Cause: An attempt was made to issue the CREATE_QUEUE_TABLE command, but the user who issued the command does not have access to internal AQ object types.

Action: Use the DBMS_AQADM.GRANT_TYPE_ACCESS procedure to grant the user access to the AQ object types.

ORA-24047: invalid agent name string, agent name should be of the form NAME

ORA-24047: invalid agent name string, agent name should be of the form NAME

Cause: An invalid value was specified for the agent name parameter.

Action: Specify a string of the form NAME. Then retry the operation.

ORA-24046: protocol attribute reserved for future use

ORA-24046: protocol attribute reserved for future use

Cause: The protocol attribute of the AQ agent object type is reserved for future use.

Action: Do not specify the protocol attribute in the agent object type.

ORA-24045: invalid agent address string, agent address should be of the form (SCHEMA.(NAME(DATABASE LINK(

ORA-24045: invalid agent address string, agent address should be of the form (SCHEMA.(NAME(DATABASE LINK(

Cause: An invalid value was specified for the agent address parameter.

Action: Specify a string of the form (SCHEMA.(NAME(DATABASE LINK(.

ORA-24044: source string and destination string object types do not match

ORA-24044: source string and destination string object types do not match

Cause: A message recipient s queue has a different object structure than the sender s queue. The message cannot be propagated.

Action: Either remove the recipient from the subscriber s list for the sender s queue or create the destination queue with an object type that matches the source queue s object type.

ORA-24043: destination string uses a reserved name, names with AQ$_ prefix are not valid

ORA-24043: destination string uses a reserved name, names with AQ$_ prefix are not valid

Cause: An attempt was made to specify a reserved name for a destination.

Action: Enter a different value or NULL for the local destination. Then retry the operation.

ORA-24042: no propagation schedule exists for QUEUE string and DESTINATION string

ORA-24042: no propagation schedule exists for QUEUE string and DESTINATION string

Cause: AN UNSCHEDULE_PROPAGATION was issued for a queue and destination pair which has no existing propagation schedule.

Action: Verify the spelling of the specified QUEUE and DESTINATION and then reissue the call with the correct spelling.

ORA-24041: propagation schedule exists for QUEUE string and DESTINATION string

ORA-24041: propagation schedule exists for QUEUE string and DESTINATION string

Cause: A SCHEDULE_PROPAGATION was issued for a queue and destination pair which has an existing propagation schedule.

Action: Issue UNSCHEDULE_PROPAGATION to remove the existing schedule and then reissue the SCHEDULE_PROPAGATION call.

ORA-24039: Queue string not created in queue table for multiple consumers

ORA-24039: Queue string not created in queue table for multiple consumers

Cause: Either an ADD_SUBSCRIBER, ALTER_SUBSCRIBER, or REMOVE_ SUBSCRIBER procedure, or an ENQUEUE with a non-empty recipient list, was issued on a queue that was not created for multiple consumers.

Action: Create the queue in a queue table that was created for multiple consumers and retry the call. NLS_DO_NOT_TRANSLATE (24040,24040(

ORA-24038: RETRY_DELAY and MAX_RETRIES cannot be used for a 8.0 compatible multiple consumer queue

ORA-24038: RETRY_DELAY and MAX_RETRIES cannot be used for a 8.0 compatible multiple consumer queue

Cause: The CREATE_QUEUE or ALTER_QUEUE command was issued with a non-zero RETRY_DELAY and a QUEUE_TABLE that was created for multiple consumers and with COMPATIBLE parameter set to 8.0 .

Action: Either set the RETRY_DELAY to zero or upgrade the queue table to 8.1 compatible using the DBMS_AQADM.MIGRATE_QUEUE_TABLE procedure.

ORA-24037: schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE

ORA-24037: schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE

Cause: The schema specified in the QUEUE_NAME parameter of CREATE_ QUEUE is not the same as the schema specified in the QUEUE_TABLE parameter.

Action: Use the same schema name for both the QUEUE_NAME and QUEUE_ TABLE parameters and retry the command.

ORA-24036: invalid SORT_ORDER column string specified for queue table

ORA-24036: invalid SORT_ORDER column string specified for queue table

Cause: The create queue table command was issued with message_grouping set to TRANSACTIONAL and a sort order column other than priority. Only the priority column can be specified in the sort order for queue tables with transactional grouping.

Action: Change the sort order list in the create queue table command and retry the call.

ORA-24035: AQ agent string is not a subscriber for queue string

ORA-24035: AQ agent string is not a subscriber for queue string

Cause: An AQ agent that was not a subscriber for the queue was specified.

Action: Check the name and or or address of the agent and retry the call.

ORA-24034: application string is already a subscriber for queue string

ORA-24034: application string is already a subscriber for queue string

Cause: An application name that was already a subscriber for the queue was specified in the dbms_aq.subscribe call.

Action: none

ORA-24033: no recipients for message

ORA-24033: no recipients for message

Cause: An enqueue was performed on a queue that has been set up for multiple dequeuers but there were neither explicit recipients specified in the call nor were any queue subscribers determined to be recipients for this message.

Action: Either pass a list of recipients in the enqueue call or add subscribers to the queue for receiving this message.

ORA-24032: object string exists, index could not be created for queue table string

ORA-24032: object string exists, index could not be created for queue table string

Cause: Oracle AQ tried to create an index with the name specified in the error message. The index could not be created for the specified queue table because a object exists with the same name.

Action: Drop the object specified in the error message and retry the command. You can also choose a different name for the queue table.