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 |
DRG-13006: sub lexer for this language is not defined
TNS-00257: Number of Successful Requests : number
ORA-13462: invalid blocking specification
SQL*Loader-00466: Column string does not exist in table string.
ORA-31110: Action failed as resource string is locked by name
PCC-01011: USAGE IS BINARY clause must be terminated by "." on same line
ORA-23326: object group "string"."string" is quiesced
ORA-01075: you are currently logged on
ORA-32142: maximum number of iterations exceeded
AMD-00141: parameter string of "string" not valid starting around "string"
ORA-22370: incorrect usage of method string
NNL-00213: No entry with specified index number, try "SHOW SYSTEM_QUERIES"