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

Sandy

On Fri, Mar 7, 2014 at 9:03 AM, Mark Bobak <Mark.Bobak_at_proquest.com> 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 <sbecker6925_at_gmail.com>
> Reply-To: "sbecker6925_at_gmail.com" <sbecker6925_at_gmail.com>
> Date: Friday, March 7, 2014 at 10:30 AM
> To: oracle-l <oracle-l_at_freelists.org>
>
> Subject: After 11.2.0.4 upgradge getting ORA-12012, ORA-04021, ORA-06512
> errors on ETL job
>
> OS - Solaris Sparc 10
> Oracle - EE 11.2.0.4
>
> We upgraded a dev database from 11.2.0.2 to 11.2.0.4. 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.
>

-- 
Sandy
Transzap, Inc.

--
http://www.freelists.org/webpage/oracle-l