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-25402: transaction must roll back
ORA-24126: invalid CASCADE_FLAG passed to DBMS_REPAIR.string procedure
RMAN-08026: channel string: copied archive log
PLS-00224: object 'string' must be of type function or array to be used this way
SQL*Loader-00416: SDF clause for field string in table string references a non existent field.
ORA-09763: osnmpx: send/receive error exchanging Mach ports.
NNL-00982: Not forwarded, no servers found: number
PLS-00708: Pragma string must be declared in a package specification
PCB-00102: Input file name length exceeds the maximum length
PCC-02045: CMD-LINE: Option is not unique:
ORA-02212: duplicate PCTFREE option specification
ORA-23356: masterdef recognizes a master which does not recognize the masterdef