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

[gibran]

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!!

[marist89]

http://www.oracle-base.com/Articles/8i/LogMiner.asp

[gibran]

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.

[marist89]

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.

[gibran]

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

[pando]

ah metalink says read Note:117108.1

[gibran]

Pando..what metalink and note??

[SANJAY_G]

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..

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

[laxman]

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

[gibran]

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!!