There are a few "must" use patches for Streams on 10.2.0.2. In case you have not applied those patches, I'd suggest first applying those. I have a list of patches for Solaris 10. Since your OS is Linux, you may want to contact Oracle support to get that.
I suppose the apply process has already ABORTED. Is capture looking good? What does the STATUS and ERROR_MESSAGE fields of DBA_APPLY and DBA_CAPTURE say?
If you have set parallelism for apply, try without any parallelism.
Another thing to check when the error started happening, what type of transactions were happening on the source database - was it just OLTP or BATCH?
I have come across the "ORA-10388: parallel query server interrupt (failure)" error, but I can't recall if I got the ORA-00001: unique constraint... violation.
Some more info would be useful .... key init.ora settings, settings for capture and apply ..
On 9/22/06, genegurevich@xxxxxxxxxxxxxxxxxxxxx < genegurevich@xxxxxxxxxxxxxxxxxxxxx> wrote:
We have recently implemented an application with streams on Linux using Oracle 10.2.0.2. Since last I am seeing apply process failing every few minutes with the following error in the alert log:
ORA-10388: parallel query server interrupt (failure) Sat Sep 23 02:06:34 2006 Streams APPLY A001 with pid=40, OS id=32280 stopped Sat Sep 23 02:06:34 2006 Errors in file /opt/oracle/admin/pihs10/bdump/pihs101_a001_32280.trc: ORA-12801: error signaled in parallel query server P000, instance rwlp75l1.ihs.discoverfinancial.com:pihs101 (1) ORA-00001: unique constraint (SYS.I_STREAMS_APPLY_SPILL_TXN) violated
I have searched metalink but did not find any relevant info. Has anyone seen that error and has an explanation and a fix?