Re: EXP-00056: Erreur ORACLE 12805

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