ORA-25307: Enqueue rate too high. Enable flow control
Answers were Sorted based on User's Feedback
Answer / michael ojejinmi
to resolve this what i did was to stop and restart the
capture and apply processes on the source and destination
databases, and this resolved the problem.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / michael ojejinmi
Also if you don't dedicate a large enough streams pool size
to your source database, then the streams process uses your
shared pool(about 10% of it), if thats already pegged by
not using binds, then there'll not be enough shared memory
for your source database queue, thereby resulting in a
queue buffer overflow, so increase your streams_pool_size
parameter, that should help with the ORA_25307 error.
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / guest
Cause: Subscribers cannot keep pace with the enqueue rate.
Action: Try enqueue after sleeping for some time.
Please add more information about this Error
Is This Answer Correct ? | 1 Yes | 3 No |
PCC-02116: You must specify a file extension using the HEADER option
ORA-25205: the QUEUE string.string does not exist
PCC-00005: Unsupported datatype in line number of file string
ORA-16759: Resource guard unable to start logical apply engine with initial SCN
NZE-29195: CRL is expired
ORA-24308: illegal define position
TNS-01048: No changes to save for string.
NNL-00562: unregister <name> [-d<address>] [-l<listener_name>] : unregister an object with Oracle Names
ORA-06770: TLI Driver: error sending version
ORA-38402: invalid name: empty string or spaces in the name
ORA-02098: error parsing index-table reference (:I)
ORA-32625: illegal dimension in cell reference predicate