Re: ORA-12805 Parallel Query server died unexpectedly

Are you getting any trace files - do these hold anything that gives you a clue as to the real error ?

There used to be an event (I think 10397) that you could set so that PQ slaves would return the 'real' error message instead of the generic masking error message.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



David OConnell wrote in message ...


>We're getting intermittent ORA-12805 parallel query server died

>unexpectedly errors when creating B-Tree indexes (in a warehouse

>product script) on Oracle 8.1.7.2 with AIX 4.3.3.

>