ORA-01294 : STARTING LOG MINER Fails While Processing Information in Dictionary File

(Doc ID 444624.1)

Last updated on OCTOBER 05, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 9.2 to 9.2
Information in this document applies to any platform.


Starting the Log Miner using DBMS_LOGMNR.START_LOGMNR fails with error ORA-01294

Following is the Test case :

SQL > show parameter utl_file_dir

------------------------------------ ----------- ------------------------------
utl_file_dir string /t01/temp/oraprod, /tmp, /u11/
app/ilprodcomn/temp, *

SQL > exec dbms_logmnr_d.build('dictionary.ora','/t01/temp/oraprod/');

PL/SQL procedure successfully completed.

SQL > exec dbms_logmnr.add_logfile(logfilename=>'/u01/oradata/ILPROD_0000065317.arc',options=>dbms_logmnr.new);

PL/SQL procedure successfully completed.

SQL > exec

ERROR at line 1:
ORA-01294: error occurred while processing information in dictionary file ,
possible corruption
ORA-06512: at "SYS.DBMS_LOGMNR", line 53
ORA-06512: at line 1


Created Dictionary file twice. Creation completes succesfully, but starting logminer using the dictionary file still fails.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms