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

From: Sandra Becker <sbecker6925@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 7 Mar 2014 08:30:18 -0700

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.

Follow-Ups:
- Re: After 11.2.0.4 upgradge getting ORA-12012, ORA-04021, ORA-06512 errors on ETL job
  - From: Mark Bobak

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

Other related posts: