Release Notes › Known Issues › Tracking ID 674-50: Oracle Data Warehousing Job Fails with ORA-07445 Error

Tracking ID 674-50: Oracle Data Warehousing Job Fails with ORA-07445 Error

A data warehousing job may fail on Oracle 10GR2 (any 10.2 variant) with Oracle error:

ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [qessoCanNewSort+554] 

This is Oracle Bug 5854471. If you see this error, ask Oracle Support if a patch is available for your version of the Oracle database server. Apply the patch if available. Alternatively, consider upgrading your Oracle database to 11G.

Apply the workaround

If neither of these options is possible, you can manually apply workaround suggested by Oracle Support in Bug 5854471. For this workaround, you must edit the data warehousing job command:

1. Use Oracle Enterprise Manager to locate scheduler job named DLP_AGGREGATION_<dbname>.
2. Edit the command as shown in the following example:

   Before editing the command

   BEGIN dlp_agg.rut_dlp_aggregation_process( BDEBUG => 1 ); 
   COMMIT; 
   END; 
   

   After editing the command

   BEGIN EXECUTE IMMEDIATE 'alter session set "_newsort_enabled"=false'; 
   dlp_agg.rut_dlp_aggregation_process( BDEBUG => 1 ); 
   COMMIT; 
   END; 
   

   Important! Do not change the BDEBUG argument value!

3. Save the change.

Important! You must undo this change if you later upgrade your Oracle database to version 11 or later.