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 |
ORA-16711: the resource guard index is out of bounds
ORA-12075: invalid object or field
ORA-13441: GeoRaster metadata SRS error
LPX-00308: attribute ~S not found in ~S
ORA-07606: szprv: $CHKPRO failure
ORA-23501: refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0
PLS-00627: 'string' must be a strongly typed ref cursor
PCC-00117: Invalid ARRAYLEN length variable type
ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_3970712838_6793 by 128 in tablespace SYSAUX? What is the solution for this issue?
ORA-19009: Missing XMLSchema keyword
ORA-00210: cannot open the specified controlfile
ORA-16047: DGID mismatch between destination setting and standby