Skip to Main Content

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-04021 timeout occurred while waiting to lock object error

allboryAug 9 2011 — edited Aug 10 2011
Hi.

Now I'm using oracle 9i on windows 2003 server.
I have a lot of packages and procedures and they run to conduct transaction job.

Few days ago I found some bugs in this packages and fixed completely.
But after fixing bugs, I couldn't compile some packages.
There are 2 packages that I faced problem.
A and B.
B is just a package. A is package that call B with parameters.

When I tried to compile those 2 packages, I see error MSG 'ORA-04021 timeout occurred while waiting to lock object'.
But another packages or procedure doesn't have problem at all.
I tried to restart server several times. But it couldn't be fixed.

I googled to solve this problem. someone said that it could have invalid code.
But once I compiled to see that what's going on.
It takes so long time.

Basically what things should I check and what's the main reason of this error?

Thanks in advance.
Dan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2011
Added on Aug 9 2011
3 comments
4,637 views