| ORA-03127 error? [message #288646] |
Tue, 18 December 2007 04:25  |
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  |
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 |
 |
Michel Cadot
Messages: 68665
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
