Oracle Database Errors or Warnings from Error ORA-26789 to ORA-26804

SQLServerF1

ORA-26789: Cannot split propagation string because only one propagation originates from its source queue “string”.”string”
Cause: Only one propagation originated from the propagation source queue.
Action: Please do not split this propagation.
ORA-26790: Requesting a lock on string “string” timed out
Cause: Could not get a lock on the object because another process was holding the lock.
Action: Please try later.
ORA-26791: Cannot split or merge propagation “string”
Cause: A process tried to split or merge this propagation, but failed and left STREAMS in an inconsistent state.
Action: Query DBA_RECOVERABLE_SCRIPT_BLOCKS view, and roll back the script which tried to split or merge this propagation.

ORA-26792: Invalid source database name string
Cause: The value for the source database global name was not valid.
Action: Specify a valid database global name. If the source database is not the local database, check the listener is up and running.
ORA-26793: Number of capture processes that enqueued message to queue “string”.”string” not equal to one
Cause: Split-merge API requires only one capture process enqueued message to the queue where the propagation originated
Action: Please drop one capture, or split or merge another propagation.
ORA-26794: Hierarchically enabled tables not supported
Cause: Hierarchically enabled tables are not supported.
Action: Disable hierarchy for the table.

ORA-26800: Apply not the only subscriber for “string”.”string”.
Cause: The combined capture and apply optimization could not be used since Apply was not the lone subscriber to the queue.
Action: Apply has to be the only subscriber to the queue.
ORA-26801: More than one subscriber for “string”.”string”.
Cause: The combined capture and apply optimization could not be used since there was more than one subscriber to the queue.
Action: Configure a single subscriber – apply or propagation for the queue.
ORA-26802: Queue “string”.”string” has messages.
Cause: The combined capture and apply optimization could not be used since the queue had messages.
Action: Make sure queue is empty before starting apply and capture.
ORA-26803: Subscribers have changed for queue “string”.”string”.
Cause: The combined capture and apply optimization could not be used since the subscribers had changed.
Action: Optimization can be used only if the queue has a single subscriber.
ORA-26804: Apply “string” is disabled.
Cause: The apply process was disabled or aborted.
Action: Start the apply process.

Above are list of Oracle Database Errors or Warnings from Error ORA-26789 to ORA-26804 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 *