Oracle Database Errors or Warnings from Error ORA-32815 to ORA-32824

SQLServerF1

ORA-32815: message system link string is referenced by a foreign queue
Cause: An attempt was made to remove a message system link currently referenced by one or more registered foreign queues.
Action: Unregister all foreign queues using this message system link and retry the operation.
ORA-32816: foreign queue string is referenced by a subscriber or schedule
Cause: An attempt was made to unregister a foreign queue currently referenced by one or more subscribers or propagation schedules.
Action: Remove all subscribers and propagation schedules using this foreign queue and retry the operation.
ORA-32817: message system link string is not configured with a log queue for string
Cause: An attempt was made to add a propagation subscriber but the message system link was not configured with a log queue for the indicated propagation type.
Action: Alter the message system link to configure the link with a log queue for this propagation type.

ORA-32818: AQ queue string does not exist
Cause: An operation was attempted where the specified AQ queue does not exist.
Action: Specify the name of an existing AQ queue.
ORA-32819: AQ queue string must be a normal queue
Cause: An operation was attempted where the specified AQ queue exists but is not a normal queue.
Action: Specify the name of an AQ queue which was created as a normal queue (NORMAL_QUEUE).
ORA-32820: subscriber queue and exception queue must use same message system link
Cause: An operation was attempted for INBOUND propagation where the specified subscriber queue and exception queue reference different message system links.
Action: Specify an exception queue that is a registered foreign queue of the same message system link as the subscriber queue.

ORA-32821: subscriber queue and exception queue must have same payload type
Cause: An operation was attempted for OUTBOUND propagation where the AQ queues used for the subscriber queue and exception queue have different payload types.
Action: Specify an exception queue that has the same payload type as the subscriber queue.
ORA-32822: subscriber string is marked for removal
Cause: An administration operation was attempted for a subscriber which is marked for removal. If attempting to remove a subscriber, the Messaging Gateway agent is not running or is running but unable to remove the subscriber at this time.
Action: Do not issue propagation administration commands for a subscriber for which removal is pending. Wait for the subscriber to be removed by the agent or issue REMOVE_SUBSCRIBER with the FORCE option to force the subscriber to be removed.
ORA-32823: subscriber exists for queue string and destination string
Cause: An attempt was made to create a propagation subscriber when one already exists for the specified queue and destination pair.
Action: Specify a different queue and destination pair, or remove the subscriber using that pair and retry the operation.
ORA-32824: schedule exists for source string and destination string
Cause: An attempt was made to create a propagation schedule when one already exists for the specified source and destination pair.
Action: Specify a different source and destination pair, or remove the schedule using that pair and retry the operation.

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

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase 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 *