Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-25307: Enqueue rate too high. Enable flow control
- 3 Answers
- 14944 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 |
PLS-01902: : hex to raw conversion error
TNS-00541: underlying transport does not exist.
ORA-19735: wrong creation SCN - control file expects initial plugged-in datafile
PLS-00711: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared twice
RMAN-04004: error from recovery catalog database: string
TNS-04078: Unable to resume atleast one of the gateways.
ORA-28653: tables must both be index-organized
ORA-14113: partitioned table cannot have column with LOB datatype
TNS-00072: * start - start up process_name
ORA-37026: (XSMLTRESYNC01) Object workspace object cannot be resynced without dimension workspace object.
ORA-02881: sou2o: Could not revoke access to protected memory
ORA-30387: invalid rewrite mode for REWRITE_EQUIVALENCE API
Oracle Errors 
