Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-30006: resource busy - No locking in database

tessdesMar 4 2013 — edited Mar 8 2013

Hi all, hope somebody has come across this before.

I'm getting a lot of ORA-30006 errors in a tomcat application log (retail-Java) but on checking all the usual views/tables for locking problems I don't see anything. In fact I rarely see a blocking lock or user, yet the number of ORA-30006 errors would suggest I should be seeing something. It could be timing issues I suppose.

My question is rather tomcat/oracle specific - could ORA-30006 be as a result of running out of threads? i.e. if tomcat can't get a free thread while attempting a lookup or connection could this error be thrown?

I'm getting no locking or ORA errors in alert log either, which is why I'm wondering if this is a 'real' oracle error.

Any help appreciated. Many thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2013

Added on Mar 4 2013

#general-database-discussions, #java

9 comments

5,524 views