Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Apply causes ORA-12805: parallel query server died unexpectedly

407338Sep 22 2006 — edited Sep 27 2006

Hi gurus,
I created an apply with a user-defined message handler for a queue. When a message is enqueued, the apply tries to do its work, but then is aborted because a fatal error has occurred: ORA-12805: parallel query server died unexpectedly.
Could anyone help me with this? I am desperate now.
Here is what comes from the log:

Dump file c:\oracle\product\10.2.0\admin\byzz10g\bdump\byzz10g_a002_640.trc
Fri Sep 22 09:15:05 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 2
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:405M/1014M, Ph+PgF:1795M/2442M, VA:1575M/2047M
Instance name: byzz10g

Redo thread mounted by this instance: 1

Oracle process number: 32

Windows thread id: 640, image: ORACLE.EXE (A002)

*** 2006-09-22 09:15:05.366
*** SERVICE NAME:(SYS$USERS) 2006-09-22 09:15:05.366
*** SESSION ID:(141.21) 2006-09-22 09:15:05.366
error 12805 in STREAMS process
ORA-12805: parallel query server died unexpectedly
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-12805: parallel query server died unexpectedly

Thank you very much!

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2006

Added on Sep 22 2006

#advanced-queueing, #database-key-features

1 comment

4,211 views