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

  • From: Mark Bobak <Mark.Bobak@xxxxxxxxxxxx>
  • To: "sbecker6925@xxxxxxxxx" <sbecker6925@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 7 Mar 2014 16:03:40 +0000

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@xxxxxxxxx<mailto:sbecker6925@xxxxxxxxx>>
Reply-To: "sbecker6925@xxxxxxxxx<mailto:sbecker6925@xxxxxxxxx>" 
<sbecker6925@xxxxxxxxx<mailto:sbecker6925@xxxxxxxxx>>
Date: Friday, March 7, 2014 at 10:30 AM
To: oracle-l <oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>>
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.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2014