ORA-03127 error? [message #288646] |
Tue, 18 December 2007 04:25 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
trantuananh24hg
Messages: 744 Registered: January 2007 Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Hi all!
My customer claimed that he has an error - Object error with Oracle DB error : ORA-03127.
Search in Oracle error
Quote: |
ORA-03127: 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.
|
I really do not understand that error. Would you like to explain to me?
OS: Solaris
DB: 10.2.0
Application: OAS 10.2
Thank you very much.
|
|
|
|
Re: ORA-03127 error? [message #288680 is a reply to message #288651] |
Tue, 18 December 2007 05:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
trantuananh24hg
Messages: 744 Registered: January 2007 Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Thank you, Michel!
Of course, before I wrote the topic at here, I searched in Google, however, nothing can help me. In this forum which I alway log in, is the last one.
I found that the problem caused this error, it was due to one customer inserted into the CLOB column, and transaction did not rollback.
Anyway, thank you!
P/s: Would you like to explain these statement in the ADDM snap
Quote: |
Wait class "Application" was not consuming significant database time.
CPU was not a bottleneck for the instance.
Wait class "Network" was not consuming significant database time
|
|
|
|
Re: ORA-03127 error? [message #288683 is a reply to message #288680] |
Tue, 18 December 2007 05:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | Of course, before I wrote the topic at here, I searched in Google
|
This is so rare and as you didn't say it, I assumed you didn't make it. Sorry.
Thanks for the feedback.
Your ADDM seems to tell there is no problem in your database or it is doing nothing.
Regards
Michel
|
|
|