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

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Fri, 7 Mar 2014 08:30:18 -0700
Message-ID: <CAJzM94CBLBBJju0kXo-aMqc4BFEOZR4qaAgkJ8knmojo=fn4=w_at_mail.gmail.com>



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.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 07 2014 - 16:30:18 CET

Original text of this message