After upgradge getting ORA-12012, ORA-04021, ORA-06512 errors on ETL job

From: Sandra Becker <>
Date: Fri, 7 Mar 2014 08:30:18 -0700
Message-ID: <>

OS - Solaris Sparc 10
Oracle - EE

We upgraded a dev database from to One of our ETL jobs started failing with errors ORA-12012, ORA-04021, ORA-06512. We have identified the object it is waiting to lock, but have no idea why this is occurring. The object is a partitioned table. The code did not change. I was told it creates a new table and does a partition exchange. I am not familiar with partition exchanges, but wonder if this might be where the issue lies. It also does some of it's work over a dblink to another database.

 I've opened a ticket with oracle, but I've been give only until noon Monday to resolve or I have to downgrade the database. Can anyone point me in the right direction. My searches so far have told me only how to find the object in question.

Thank you.


GHX, Inc.

-- Received on Fri Mar 07 2014 - 16:30:18 CET

Original text of this message