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

From: Sandra Becker <>
Date: Fri, 7 Mar 2014 10:17:50 -0700
Message-ID: <>

As I recall, it was waiting on a library cache lock. I'll have them run it again and verify.


On Fri, Mar 7, 2014 at 9:03 AM, Mark Bobak <> wrote:

> ORA-04021 is timeout occurred while waiting to lock object. Before that
> occurs, the session in question will be waiting. Is it waiting on 'library
> cache lock'? 'library cache pin'? Some type of mutex wait? Something
> else?
> -Mark
> From: Sandra Becker <>
> Reply-To: "" <>
> Date: Friday, March 7, 2014 at 10:30 AM
> To: oracle-l <>
> Subject: After upgradge getting ORA-12012, ORA-04021, ORA-06512
> errors on ETL job
> 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.
> --
> Sandy
> GHX, Inc.

Transzap, Inc.

Received on Fri Mar 07 2014 - 18:17:50 CET

Original text of this message