Home » Server Options » Replication » ORA-12801(Error signaled in parallel query server)
ORA-12801(Error signaled in parallel query server) [message #75066] Mon, 18 June 2001 23:14 Go to next message
Rajee
Messages: 17
Registered: June 2001
Junior Member
Hi,
Actually we want to upgrade an oracle database in 7.3.4 to oracle 8.1.7. The database is working perfect in oracle 7.3.4 and oracle 8.1.7 if we use export/import options. But, if we use migration assistant (GUI-in WinNT) we are getting ora-12801 error followed by ora-00942 (table or view does not exist). This problem is coming when we try to execute a particular query, that too from the front end - VB6.0. The same query is running perfectly if we run it in the backend. Can anyone help us out in this. Please

With regards,
rajee

----------------------------------------------------------------------
Re: ORA-12801(Error signaled in parallel query server) [message #75105 is a reply to message #75066] Mon, 27 August 2001 09:05 Go to previous messageGo to next message
Brad Herder
Messages: 2
Registered: July 1999
Junior Member
We are having a very similar problem after upgrading to Oracle 8. Cold Fusion queries that worked before are now aborting (on an intermittent basis). My specific error is:

ORA-12801: error signaled in parallel query server P002 ORA- 00942: table or view does not exist

Is there a fix for this???

----------------------------------------------------------------------
Re: ORA-12801(Error signaled in parallel query server) [message #75112 is a reply to message #75105] Wed, 17 October 2001 06:01 Go to previous messageGo to next message
R. S. Bisht
Messages: 1
Registered: October 2001
Junior Member
We have Oracle 8i installed in two different servers:-

1). Dual Processor, 1GB of RAM
2). PIII 700 Mhz PC with 256 MB of RAM

If I run the query in 1st the server the, query is executing fine, but in 2nd server it is giving the above mentioned error !!!

My query is using "UNION ALL"

----------------------------------------------------------------------
Re: ORA-12801(Error signaled in parallel query server) [message #75147 is a reply to message #75066] Mon, 25 February 2002 06:45 Go to previous messageGo to next message
TERADATA
Messages: 1
Registered: February 2002
Junior Member
GET TERADATA THEN!
Re: ORA-12801(Error signaled in parallel query server) [message #75169 is a reply to message #75066] Wed, 01 May 2002 11:21 Go to previous messageGo to next message
Stephen Pradeep
Messages: 1
Registered: May 2002
Junior Member
Hi,

check v$tablespace;

The name correponding to the TS# is the tablespace which is causing this problem.
Change the default Storage parameters(intial extent next maxextents) of that Tablespace to accomodate the table you are trying to create.

It should solve your problem!
Oracle internally uses the Temp Tablespace when large tables are created and the storage parameters for TEMp may not be geared to handle your create statement!

Regards,
Stephen
Re: ORA-12801(Error signaled in parallel query server) [message #75258 is a reply to message #75066] Wed, 28 August 2002 09:25 Go to previous messageGo to next message
vk
Messages: 13
Registered: December 2001
Junior Member
It seems there are quite some issues with ORA 8.1 parallel servers. Some of them are fixed with 8.1.7.4.

Best way to avoid the ORA-12801 is to turn of the PARALLELIZATION compeletely. Though it can slow down the operations.
Re: ORA-12801(Error signaled in parallel query server) [message #75469 is a reply to message #75112] Thu, 19 February 2004 04:09 Go to previous messageGo to next message
Mike Vere
Messages: 1
Registered: February 2004
Junior Member
I am receiving this same error, did you ever resolve it?
Re: ORA-12801(Error signaled in parallel query server) [message #109356 is a reply to message #75469] Wed, 23 February 2005 21:03 Go to previous message
Chirag Majmundar
Messages: 1
Registered: February 2005
Junior Member
Same error here..!!

Has anybody got the solution for that?

- Chirag Majmundar
Previous Topic: ORA-01219: database not open: queries allowed on fixed tables/views only
Next Topic: Replication and standby datbase
Goto Forum:
  


Current Time: Fri Sep 19 19:31:46 CDT 2014

Total time taken to generate the page: 0.11310 seconds