| ORA-00604 in connection with ORA-04021 [message #118845] |
Mon, 09 May 2005 05:06  |
dzeljko
Messages: 19
Registered: April 2005
|
Junior Member |
|
|
Hello!
I got next errors multiple times and after that database fails
ORA-00604: error occurred at recursive SQL level 1
ORA-04021: timeout occurred while waiting to lock object select u1.user#, u2.user#, u3.user#, failures,
flag, interval#, what, nlsenv, env, field1 from sys.job$ j, sys.user$ u1, sys.user$ u2,
sys.user$ u3 where job=:1 and (next_date < sysdate or :2 != 0) and lowner = u1.name and
powner = u2.name and cowner = u3.name^@
Is that system error or something is wrong with my java program?
(or something else)
Thanks!
|
|
|
|
 Re: ORA-00604 in connection with ORA-04021 [message #119054 is a reply to message #118845] |
Tue, 10 May 2005 08:09  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
what oracle corporation say about your error ...
ORA-00604 error occurred at recursive SQL level string
Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).
Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support Services.
sunil
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
