Home > IT Answers > Oracle > ORA-03127: no new operations allowed until the active operation ends
Costaf
40 pts.
 ORA-03127: no new operations allowed until the active operation ends
ORA-03127, Oracle 11g, Oracle Reports 10g
Good Morning, Since oracle 10g and even after upgrading to oracle 11g , e keep getting an oracle error: ORA-03127: no new operations allowed until the active operation ends, in relation to a diferent db table, every time the error occurs. including db tables that have maintenunce every day. can anyone tell me why this error occurs? thanks in advance, costaf .

Software/Hardware used:
oracle 11g linux cluster,windows 2008 r2 application servers and oracle reports 10g
ASKED: March 21, 2012  12:13 PM
UPDATED: March 22, 2012  3:35 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What specific operations are being performed when the error occurs ?
Are these operations being performed by an application ? if so, what application and how is it connecting to the database ?
Is there a failure pattern ?

carlosdl
 63,535 pts.
 

Hi, Thank you for your reply, the operations are selects, inserts and update to db tables. the aplication connects to oracle db through oracle odbc . until now i havent been able to find a pattern.

Costaf
 40 pts.
 

i´m sorry, in the previous comment , i wanted to say that application servers connect to the oracle db linux 11g cluster , via oracle oledb.

Costaf
 40 pts.