ORA-25307: Enqueue rate too high. Enable flow control
- 3 Answers
- 14174 Views
- I also Faced
- E-Mail Answers
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 |
PCB-00628: Buffer type is incompatible with LOB type
ORA-15171: invalid syntax in the alias path after 'string'
ORA-02143: invalid STORAGE option
QSM-01019: no suitable materialized view found to rewrite this query
ORA-12150: TNS:unable to send data
NNL-00571: set|show save_config_on_stop [<on|off>]
TNS-00222: -------------------------------------------------------------------
ORA-26576: cannot acquire SR enqueue
PCC-02405: Variable is of undefined type
ORA-13611: The command string is not a valid advisor command.
LFI-00121: Only one of REPLACE, or PROT allowed for opty.
ORA-22165: given index [string] must be in the range of 0 to [string]
Oracle Errors 
