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
Messages: 225
Registered: July 2005
Senior Member

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.


[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
Next Topic: Flashback is not enabled. Can I perform flashback database.
Goto Forum:

Current Time: Sun Oct 23 17:47:14 CDT 2016

Total time taken to generate the page: 0.04093 seconds