Problems starting logminer
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Problems starting logminer

  1. #1
    Join Date
    Sep 2007
    Posts
    15

    Problems starting logminer

    Hi,

    I've recently started, stopped and started again logminer without any problems, but today this happens:

    Code:
    SQL> execute dbms_logmnr.START_LOGMNR(dictfilename => dbms_logmnr.dict_from_online_catalog);
    BEGIN dbms_logmnr.START_LOGMNR(dictfilename => dbms_logmnr.dict_from_online_catalog); END;
    
    *
    ERROR at line 1:
    ORA-01284: file 16 cannot be opened
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 1
    Only relevant content of the alert_xxx.log:
    Code:
    Ma Sep 17 12:26:17 2007
    logminer Bld: Build started
    Ma Sep 17 12:26:17 2007
    logminer Bld: Catalog lockdown FAILED, status -258
    I've checked the docs, and it seems the logminer package cannot open the dictionary.

    How can I fix this?

    Config: Oracle 10g on Windows. Test installation on Windows XP.

    Any help appreciated.

    Regards,
    Rolf Barbakken

  2. #2
    Join Date
    Sep 2007
    Posts
    36
    Pathname exceeds 256 characters??

  3. #3
    Join Date
    Sep 2007
    Posts
    15
    Quote Originally Posted by jay_l_a
    Pathname exceeds 256 characters??
    No the path does not exceed 256 chars. As I said, the logminer has worked fine for a while, then suddenly refuses to start, so the path has not changed.

  4. #4
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    IS file 16 in backup or readonly?

  5. #5
    Join Date
    Sep 2007
    Posts
    15
    Quote Originally Posted by dbtoo
    IS file 16 in backup or readonly?
    As I don't even know what "file 16" is, I don't know if it is in backup or readonly.

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    i am not very sure but whats the output of

    select * from dba_data_files where file_id = 16

    regards
    Hrishy

  7. #7
    Join Date
    Sep 2007
    Posts
    15
    Quote Originally Posted by hrishy
    Hi

    i am not very sure but whats the output of

    select * from dba_data_files where file_id = 16

    regards
    Hrishy
    The results from this query is
    Code:
    no rows selected
    I still get the same error.

  8. #8
    Join Date
    Sep 2007
    Posts
    15
    I changed from "dictfilename" to "options" and now it runs again. Don't know why this was the solution or why "dictfilename" was working before.

    Thank you all, though.

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