Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

logminer

11g.DBAAug 20 2012 — edited Aug 20 2012

I am trying to setup logminer.While setting parameters i successfully created and granted read write on logmnr_output(NO DIRECTORY IS VISIBLW BUT COMMAND SHOWS DIRECTORY SUCCESSFULLY CREATED).But while building the logminer dictionary by executing the following command

EXECUTE sys.DBMS_LOGMNR_D.BUILD( -
DICTIONARY_FILENAME =>'LogMiner_Dictionary.ora', -
DICTIONARY_LOCATION => 'C:\oracle\admin\orcl\lgmnr');

I am getting the following errors

ERROR at line 1:
ORA-01336: specified dictionary file cannot be opened
ORA-29280: invalid directory path
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 6003
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 6093
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 12
ORA-06512: at line 1

This post has been answered by Balazs Papp on Aug 20 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2012

Added on Aug 20 2012

#general-database-discussions

6 comments

469 views