Home » RDBMS Server » Server Administration » need help starting LogMiner utility
need help starting LogMiner utility [message #56819] Mon, 28 April 2003 07:48 Go to next message
Gibran
Messages: 3
Registered: April 2003
Junior Member
I am constantly having a problem in starting oracle lonminer. Please help as it is getting late with my project due date.

I did the following steps towards starting logminer in oracle 8i and recieved an error.
>connect sys/password@db1;

>execute dbms_logmnr_d.build ('db01dict.ora','c:oracleoradatadb1LM');
Procedure successfully completed.

>execute dbms_logmnr.add_logfile('c:oracleoradatadb1redo01a.log',dbms_logmnr.new);
Procedure successfully completed.

--step with errors
>execute dbms_logmnr.start_logmnr('c:oracleoradatadb1LM'db01dict.ora');
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1

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

Report message to a moderator

Re: need help starting LogMiner utility [message #56830 is a reply to message #56819] Tue, 29 April 2003 12:51 Go to previous messageGo to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
Try the following ( some times I feel overloading
doesn't work well in PL/SQL procedure calls ):

execute dbms_logmnr.start_logmnr
(DictFileName=>'c:oracleoradatadb1LMdb01dict.ora');

Report message to a moderator

Re: need help starting LogMiner utility [message #56831 is a reply to message #56830] Tue, 29 April 2003 12:56 Go to previous message
krishna
Messages: 141
Registered: October 1998
Senior Member
Also I noticed an extra quote in your file input.
'c:oracleoradatadb1LM'db01dict.ora'
(between db1LM and db01dict )

That may cause problem.

Report message to a moderator

Previous Topic: How to know the corresponding .dbf file to my database?
Next Topic: how to import data with no Rows? Thanks
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 30 16:00:30 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.