Home » RDBMS Server » Server Utilities » How start LogMnr
How start LogMnr [message #70189] Fri, 26 April 2002 19:42 Go to next message
RachyKing
Messages: 1
Registered: April 2002
Junior Member
My Oracle8.1.6 is runing on Win2K Server,I want to start LogMiner as follow:
1.Create a dir e:oracleadminrachylogs as the initialization parameter UTL_FILE_DIR
2.Edit initrachy.ora and set the UTL_FILE_DIR=e:oracleadminrachylogs
3.Start instance and Open database
4.Create dictionary:
SQL>EXECUTE DBMS_LOGMNR_D.BUILD( DICTIONARY_FILENAME=>'dictionary.ora',DICTIONARY_LOCATION => 'E:oracleadminrachylogs');
5.Add archived log to analyze
SQL>EXECUTE DBMS_LOGMNR.ADD_LOGFILE( LOGFILENAME => 'E:/oracle/oradata/rachy/archive/RACHYT001S01018.ARC', OPTIONS => dbms_logmnr.NEW);
6.Start LogMiner:
SQL>EXECUTE DBMS_LOGMNR.START_LOGMNR( DICTFILENAME =>' E:oracleadminrachylogsdictionary.ora');

Here I got a Error Messeage:
ORA_01843:invaild month

Tanks for any help!

Report message to a moderator

Re: How start LogMnr [message #70193 is a reply to message #70189] Mon, 29 April 2002 17:51 Go to previous message
seng
Messages: 191
Registered: February 2002
Senior Member
I think that yopu need to specify other option in DBMS_START_LOGMNR, eg date,scn. Hope this is helping

Report message to a moderator

Previous Topic: ORA-05901 error message
Next Topic: HELP for control file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 06:23:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.