ORA-04020: deadlock detected while trying to lock object - Oracle Package
1
vote
1
answer
2727
views
I have an Oracle Package (Schema1) that is calling another Oracle Package (Schema2) over a DB link. There are no recent code changes.
When I try to compile the package in (Schema1) it throws the following errors.
(replaced the actual schema names with 1 and 2 for clarity)
> ORA-04052: error occurred when looking up remote object
> SCHEMA2.PKG_NAMEHERE@SCHEMA2.LINKNAME.INT@SCHEMA1
>
> ORA-04020: deadlock detected while trying to lock object
> SCHEMA2.PKG_NAMEHERE@SCHEMA2.LINKNAME.INT@SCHEMA1
What we have tried
1. Killed all user sessions
2. Recompiled the package in SCHEMA2 even so SCHEMA1 that calls it over the DBLINK failes with "ORA-04020: deadlock detected"
We have 4 Database regions, and this is only happening in two of the regions.
**Notes:**
SCHEMA1: Oracle 11g
SCHEMA2: Oracle 12c (on ExaData)
Asked by Elim Garak
(61 rep)
Apr 13, 2018, 06:01 PM
Last activity: Nov 16, 2018, 07:00 PM
Last activity: Nov 16, 2018, 07:00 PM