LOGMINER--ROOCKIE QUESTION.......

[xuduro]

I was trying to Run my LOGMINER.... and This is what i wrote(code);
execute dbms_logmnr.build(dictionary_filename=>'sptc0538.ora',
dictionary_location=>'$HOME/SPTC0538/logminer');

To be more clear the dictionary_location PATH is the same as the one in the INIT.ORA file .utl_file_dir=$HOME/SPTC0538/logminer
I was also login as SYS user with SYSDBA previlege.........

AND I HAVE GOT THIS ERROR MESSAGE.........

BEGIN dbms_logmnr_d.build(dictionary_filename=>'sptc0538.ora', dictionary_location=> '$HOME/DATAS/DISK8/logminer'); END;

*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 777
ORA-06512: at line 1


PLEASE HELP.........
THANKS

[clio_usa]

xuduro,

In both cases, do not use $HOME but the absolute path. It has been many known bugs with that. That might be the case here too.

Also how came that :

utl_file_dir=$HOME/SPTC0538/logminer

is different from:

dictionary_location=> '$HOME/DATAS/DISK8/logminer' in the error message.

Any clues ???


Check the latest Oracle DBA forums:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi


Hope that helps,

--clio_usa
Senior Oracle DBA

[gnagesh]

Set the set serveroutput on, and execute the dbms_logmnr_d.build, you will come to know the problem. I think your utl_file_dir is creating problem.

Hope it helps you.