Home » RDBMS Server » Server Administration » Oracle 10g-Unix - Reliability Problem
Oracle 10g-Unix - Reliability Problem [message #253290] Mon, 23 July 2007 07:14 Go to next message
mymot
Messages: 225
Registered: July 2005
Senior Member
hi,


I have got oracle 10g production database is running linux server and we got below errors everyday atleast 3/4 
times and many times a week. That means we have to restart our job everytime.

ORA-12827: insufficient parallel slaves available
ORA-03114: not connected to ORACLE




Any suggestions which could prevent this error and ensure reliability of oracle database.

thanks

[Updated on: Mon, 23 July 2007 07:17] by Moderator

Report message to a moderator

Re: Oracle 10g-Unix - Reliability Problem [message #253315 is a reply to message #253290] Mon, 23 July 2007 08:18 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Implement action below:

12827, 00000, "insufficient parallel query slaves available"
// *Cause: PARALLEL_MIN_PERCENT parameter was specified and fewer than
//         minimum slaves were acquired
// *Action: either re-execute query with lower PARALLEL_MIN_PERCENT or
//          wait until some running queries are completed, thus freeing
//          up slaves
Previous Topic: MY DATABASE CAN NOT START
Next Topic: Flashback is not enabled. Can I perform flashback database.
Goto Forum:
  


Current Time: Tue Dec 06 08:22:02 CST 2016

Total time taken to generate the page: 0.07348 seconds