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

Thread: Can't start LogMiner .... Please Help!!!

  1. #1
    Join Date
    Apr 2003
    Location
    New York City
    Posts
    5

    Angry Can't start LogMiner .... Please Help!!!

    I have been trying to analyze my redolog files by using LogMiner but have been hitting the wall when it comes to starting logminer using the dictionay file.

    I did the following:

    >connect sys/password@db1;

    >execute dbms_logmnr_d.build ('db01dict.ora','c:\oracle\oradata\db1\LM');
    Procedure successfully completed.

    >execute dbms_logmnr.add_logfile('c:\oracle\oradata\db1\redo01a.log',dbms_logmnr.new);
    Procedure successfully completed.

    --step with errors
    >execute dbms_logmnr.start_logmnr('c:\oracle\oradata\db1\LM\'db01dict.ora');

    ERROR at line 1:
    ORA-06502: PL/SQL: numeric or value error: character to number conversion error
    ORA-06512: at line 1

    When I try to enter time or scn parameters; I get the 'wrong number or types of arguments' error.

    I am running db @ windows 2000. Any input will be appreciated.
    Thank you!!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

  3. #3
    Join Date
    Apr 2003
    Location
    New York City
    Posts
    5

    doesn't help

    Thank you for the link but that doesn't resolve the problem. I have already taken all the steps upto the point where I attempt to start the logminer with dictionay file and get the same error.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    My guess is you didn't follow everything in the link as I have used that link over 20 times to run logminer.

    If I were you, I would check to make sure my utl_file_dir is setup correctly and I can write files to it.
    Jeff Hunter

  5. #5
    Join Date
    Apr 2003
    Location
    New York City
    Posts
    5
    Thanks again!!

    utl_file_dir is set properly and that is how I know:

    SQL> show parameter utl_

    NAME TYPE VALUE
    ------------------ -------- ---------
    utl_file_dir string c:\oracle\oradata\db1\LM


    I think problem is manifested by the following error:

    ERROR at line 1:
    ORA-06502: PL/SQL: numeric or value error: character to number conversion error

    I just don't know how to fix it. :(

    regards,
    ash

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ah metalink says read Note:117108.1

  7. #7
    Join Date
    Apr 2003
    Location
    New York City
    Posts
    5

    Angry ??

    Pando..what metalink and note??

  8. #8
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Re: Can't start LogMiner .... Please Help!!!

    Originally posted by gibran
    --step with errors
    >execute dbms_logmnr.start_logmnr('c:\oracle\oradata\db1\LM\'db01dict.ora');

    ERROR at line 1:
    ORA-06502: PL/SQL: numeric or value error: character to number conversion error
    ORA-06512: at line 1
    Try this..
    Code:
    execute dbms_logmnr.start_logmnr(DICTFILENAME =>'c:\oracle\oradata\db1\LM\db01dict.ora');
    Originally posted by gibran
    Pando..what metalink and note??
    http://metalink.oracle.com
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  9. #9
    Join Date
    Mar 2002
    Posts
    24
    Hi,

    Check the Syntax:

    >execute dbms_logmnr.start_logmnr('c:\oracle\oradata\db1LM\'db01dict.ora');



    the Above line should be
    >execute dbms_logmnr.start_logmnr('c:\oracle\oradata\db1LM\db01dict.ora');

    it works.......
    Laxman

  10. #10
    Join Date
    Apr 2003
    Location
    New York City
    Posts
    5

    Smile Thank You all!!!!

    It worked with 'dictfilename =>' clause. I was trying to run it with only:
    > execute dbms_logmnr.start_logmnr('c:\oracle\oradata\db1\LM\db01dict.ora');

    as it did work with previous steps.
    Well, in any case I am a happy man now, thanks to you, candor folks!!

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