ORA-04021: timeout occurred while waiting to lock object
HI DBAs
OS = RHEL AS4
DB = 10.2.0.4
2 node RAC
Im receiving this err continuously..
ORA-12012: error on auto execute of job 2174019
ORA-04021: timeout occurred while waiting to lock object ORA-04021: timeout occurred while waiting to lock object METRICS_OWNER.METRICS_LIB
ORA-06508: PL/SQL: could not find program unit being called: "METRICS_OWNER.METRICS_LIB"
ORA-06512: at "METRICS_OWNER.NRP_TRIP_REPORTS_ETL", line 837
ORA-01407: cannot update ("METRICS_OWNER"."NRP_TRIP_DETAIL"."WAGNAME") to NULL
ORA-06512: at line 1
This ETL job was executed till yesterday and started throwing this err. I found that there are no locked objects.
How can I get out of this?
OS = RHEL AS4
DB = 10.2.0.4
2 node RAC
Im receiving this err continuously..
ORA-12012: error on auto execute of job 2174019
ORA-04021: timeout occurred while waiting to lock object ORA-04021: timeout occurred while waiting to lock object METRICS_OWNER.METRICS_LIB
ORA-06508: PL/SQL: could not find program unit being called: "METRICS_OWNER.METRICS_LIB"
ORA-06512: at "METRICS_OWNER.NRP_TRIP_REPORTS_ETL", line 837
ORA-01407: cannot update ("METRICS_OWNER"."NRP_TRIP_DETAIL"."WAGNAME") to NULL
ORA-06512: at line 1
This ETL job was executed till yesterday and started throwing this err. I found that there are no locked objects.
How can I get out of this?
0