Logminer
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Logminer

  1. #1
    Join Date
    Feb 2002
    Posts
    267



    Hi folks,
    When i am trying to use log miner i am getting the followin error

    SVRMGR> execute dbms_logmnr_d.build('dict.ora','/ora/data/prod/logm');

    ORA-01309: specified dictionary file cannot be opened
    ORA-06510: PL/SQL: unhandled user-defined exception
    ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793
    ORA-06512: at line 2

    could anybody help me

  2. #2
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Make sure the value you have specified for the second parameter of BUILD procedure is same as the value of UTL_FILE_DIR of init.ora.
    Agasimani
    OCP(10g/9i/8i/8)

  3. #3
    Join Date
    Feb 2002
    Posts
    267
    ofcourse same....

  4. #4
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Are you using 8i or 9i?

    If it is 8i then make sure it is as follows:

    init.ora(example)
    --------------------
    UTL_FILE_DIR=/oracle816/logminer/

    execute
    ---------
    SQL> execute DBMS_LOGMNR_D.BUILD('dictionary.ora','/oracle816/logminer/');


    Agasimani
    OCP(10g/9i/8i/8)

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    oracle has permission to write in that directory ?

    Sanjay

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width