OraFAQ Forum: Server Administration » Oracle 10g-Unix

Home » RDBMS Server » Server Administration » Oracle 10g-Unix - Reliability Problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 10g-Unix - Reliability Problem [message #253290]

Mon, 23 July 2007 07:14

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

Frank Naude
Messages: 4580
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

Report message to a moderator

Previous Topic:	MY DATABASE CAN NOT START
Next Topic:	Flashback is not enabled. Can I perform flashback database.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 23:10:30 CDT 2024