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.
Other related posts:
- » After 11.2.0.4 upgradge getting ORA-12012, ORA-04021, ORA-06512 errors on ETL job - Sandra Becker
- » Re: After 11.2.0.4 upgradge getting ORA-12012, ORA-04021, ORA-06512 errors on ETL job- Mark Bobak
- » Re: After 11.2.0.4 upgradge getting ORA-12012, ORA-04021, ORA-06512 errors on ETL job- Sandra Becker
- » Re: After 11.2.0.4 upgradge getting ORA-12012, ORA-04021, ORA-06512 errors on ETL job- Mark Burgess
- » Re: After 11.2.0.4 upgradge getting ORA-12012, ORA-04021, ORA-06512 errors on ETL job- Mark Bobak
- » Re: After 11.2.0.4 upgradge getting ORA-12012, ORA-04021, ORA-06512 errors on ETL job- Sandra Becker
- » Re: After 11.2.0.4 upgradge getting ORA-12012, ORA-04021, ORA-06512 errors on ETL job- Sandra Becker
- » Re: After 11.2.0.4 upgradge getting ORA-12012, ORA-04021, ORA-06512 errors on ETL job- Mark Bobak
- » Re: After 11.2.0.4 upgradge getting ORA-12012, ORA-04021, ORA-06512 errors on ETL job- Hemant K Chitale
- » Re: After 11.2.0.4 upgradge getting ORA-12012, ORA-04021, ORA-06512 errors on ETL job- Hans Forbrich
- » Re: After 11.2.0.4 upgradge getting ORA-12012, ORA-04021, ORA-06512 errors on ETL job- Sandra Becker