Oracle Database Errors or Warnings from Error ORA-24071 to ORA- 24080

SQLServerF1

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-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-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-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-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-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-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-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-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-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.

Above are list of Oracle Database Errors or Warnings from Error ORA-24071 to ORA-24080 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.

 

Oracle Database Errors or Warnings from Error ORA-24061 to ORA- 24028

SQLServerF1

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-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-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-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-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-24066: invalid privilege specified
Cause: An invalid privilege is specified for granting or revoking privilege
Action: Specify a valid privilege.

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-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-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-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-24028: cannot create a reciever non-repudiable single consumer queue
Cause: Tried to create a reciever non-repudiable single consumer queue
Action: This feature is not supported

Above are list of Oracle Database Errors or Warnings from Error ORA-24061 to ORA-24028 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.