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

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