ORA-12838 while profiling data
I'm following OWB course "Examining Source Data Using Data Profiling" for 11g R2 here:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/bidw/owb/dp/less1_data_profiling.htm
In section "Profiling the Source Data" at step 5, my profiling operation never completes. I get the following errors:
ORA-12838: cannot read/modify an object after modifying it in parallel
ORA-06512: at "OWBSYS.WB_RT_PROFILE_SERVICE", line 1814
ORA-06512: at "OWBSYS.WB_RT_PROFILE_SERVICE", line 1243
ORA-06512: at line 1
Referential analysis for objects.
ORA-29532: Java call terminated by uncaught Java exception: java.lang.Exception: oracle.jdbc.driver.OracleSQLException: ORA-01578: ORACLE data block corrupted (file # 4, block # 112034)
ORA-01110: data file 4: '/home/oracle/app/oracle/oradata/orcl/users01.dbf'
oracle.jdbc.driver.T2SConnection.check_error(T2SConnection.java)
oracle.jdbc.driver.T2SPreparedStatement.checkError(T2SPreparedStatement.java:108)
oracle.jdbc.driver.T2SPreparedStatement.executeForRows(T2SPreparedStatement.java)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java)
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java)
oracle.wh.service.impl.dataProfile.analysis.storedprocs.ForeignKey.execute(ForeignKey.java:36)
oracle.wh.service.impl.dataProfile.analysis.storedprocs.ForeignKey.execute(ForeignKey.java:20)
oracle.wh.service.impl.
ORA-06512: at "OWBSYS.WB_RT_DP_CREATE_FKPARTITION", line 1
ORA-06512: at "OWBSYS.WB_RT_PROFILE_SERVICE", line 1532
ORA-06512: at "OWBSYS.WB_RT_PROFILE_SERVICE", line 1179
ORA-06512: at line 1
I have double-checking everything - but I'm stuck with this error.
Does anybody encountered this?
I know parallel DML has limitations and requires inserts to be committed before to read - but it's not my code running...
I have a Virtualbox Linux machine with 3 CPUs running a 11.2.0.3 database.
I have tried using a database trigger to do " alter session disable parallel ddl" after logon - that didn't work.
I have tried with only 1 CPU - nope...
I'm out of ideas on this.
Thanks for suggestions...