EXP-00056: Erreur ORACLE 12805

[Epicentre team A]

Hi

Config:
- Server LINUX Red Hat 7, Oracle 9I
- Client: NT4 Server Oracle 8.1.7.0

Export is running from client and this error appears
EXP-00056: Erreur ORACLE 12805 rencontré
ORA-12805: le serveur d'interrogation parallèle s'est détruit inopinément

Is it necessary to migrato client to 9i ?

bests regards
Epicentre Team A

[Telemachus]

Check for a previous error. The 12805 means a parallel slave died because of
a previous error.
"Epicentre team A" <ora...@epicentre.fr> wrote in message
news:aplokk$clr$1...@wanadoo.fr...

[Billy Verreynne]

Epicentre team A wrote:

> Config:
> - Server LINUX Red Hat 7, Oracle 9I
> - Client: NT4 Server Oracle 8.1.7.0
>
> Export is running from client and this error appears
> EXP-00056: Erreur ORACLE 12805 rencontré
> ORA-12805: le serveur d'interrogation parallèle s'est détruit inopinément

12805, 00000, "parallel query server died unexpectedly"
// *Cause: A parallel query server died unexpectedly, PMON cleaning
// up the process.
// *Action: Check your system for anomalies and reissue the statement.
// If this error persists, contact your customer service
// representative. See trace file for more details.

> Is it necessary to migrato client to 9i ?

If you want to mess about with PQ, you should wear a hard hat. Or RTFM. ;-)

Try the import without doing it parallel. See if it works.

If you do need PQ, then make sure the instance has the basics for PQ
configured in the init.ora. Make sure that the number of PQ's that can be
spawned is not more than the number of Unix processes allowed for that Unix
user. Check memory.

In fact, pretty much do what the above oraerr info says. Check your system
for anomolies. Check the logs.

2'c comment - doing a PQ import over a network I think is not the best of
ideas. The bottleneck is likely to be the network itself and a PQ import
will not give the expected performance. I would zip the import file. Push
it from the NT box across the network to the Linux machine. Unzip it there.
And then load it.

Or do all this from Linux instead using a FTP get into a pipe, running
gunzip in the background, piping its data to the importer doing a direct
parallel load. This way you do not need any space on the Linux for the zip
file and unzipped dump file.

--
Billy