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 |
RMAN-06545: "string" is an invalid response - please re-enter.
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
ORA-12479: file label string must equal DBHIGH string
ORA-12900: must specify a default temporary tablespace for a locally managed database
ORA-16220: no failed transaction found
ORA-22289: cannot perform string operation on an unopened file or LOB
ORA-27125: unable to create shared memory segment
IMP-00085: multiple input files specified for unbounded export file
ORA-25293: Remote Recipient Subsribers and buffered operations not possible for Queue string
ORA-06009: NETASY: dialogue filename too long
ORA-14319: DEFAULT cannot be specified with other values
ORA-30658: attempt was made to create a temporary table with EXTERNAL organization