Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-03123

Re: ORA-03123

From: Herod <herodt_at_gmail.com>
Date: 21 Mar 2006 19:55:21 -0800
Message-ID: <1142999721.329125.144200@j33g2000cwa.googlegroups.com>


Your session is blocking/locking itself. Something is causing a transaction and you can't do anything because of it. Could be trying to spawn processes while the first one is busy.

I haven't seen those errors before.

03123, 00000, "operation would block"
// *Cause: This is a status code that indicates that the operation
// cannot complete now.
// *Action: None; this is not an error. The operation should be
retried
// again for completion.

03127, 00000, "no new operations allowed until the active operation ends"
// *Cause: An attempt was made to execute a new operation before the
active
// non-blocking operation completed or a new operation was attempted

//         before all the pieces of a column were inserted or fetched.

// *Action: Execute the new operation after the non-blocking operation
// completes. If piecewise binds/defines were done, execute the new // operation after all the pieces have been inserted or
fetched. Received on Tue Mar 21 2006 - 21:55:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US