| the error during using logminer to analyze logfile [message #115435] |
Mon, 11 April 2005 11:19 |
waxle
Messages: 5
Registered: March 2005
Location: Beijing China
|
Junior Member |
|
|
Today i want to test the logminer tool
This is my step
1.creat DBMS_LOGMNR package
SQL>@ F:/ORACLE/ORA90/rdbms/admin/dbmslm.sql
2.create relative dictionary
SQL>@ F:/ORACLE/ORA90/rdbms/admin/dbmslmd.sql
3.edit the init.ora file and add the parameter UTL_FILE_DIR to specify the directory
SQL>alter system set UTL_FILE_DIR='F:/ORACLE/ora90/logminer' scope=spfile;
4.shutdown and startup again to enable the parameter
SQL>shutdown immediate
SQL>startup
5.create dictionary file
SQL>execute dbms_logmnr_d.build(dictionary_filename =>'sqltrace.ora',dictionary_location =>'F:/ORACLE/ORA90/LOGMINER');
6.create logminer files
SQL> execute dbms_logmnr.add_logfile(options =>dbms_logmnr.new,logfilename =>'F:/ORACLE/ORADATA/THRIVER/REDO01.LOG');
8.start the logminer to analyze the logfile
SQL> execute dbms_logmnr.start_logmnr(dictfilename =>'F:/ORACLE/ORA90/LOGMINER/sqltrace.ora',starttime =>to_date('20050325 09:00:00','yyyymmdd hh24:mi:ss'),endtime =>to_date('20050411 17:00:00','yyyymmdd hh24:mi:ss'));
But in this step there are some errors
Tehe below part is the errors and operation
SQL> execute dbms_logmnr.start_logmnr(dictfilename =>'F:/ORACLE/ORA90/LOGMINER/sqltrace.ora',starttime =>to_date('20050325 09:00:00','yyyymmdd hh24:mi:ss'),endtime =>to_date('20050411 17:00:00','yyyymmdd hh24:mi:ss'));
BEGIN dbms_logmnr.start_logmnr(dictfilename =>'F:/ORACLE/ORA90/LOGMINER/sqltrace.ora',starttime =>to_date('20050325 09:00:00','yyyymmdd hh24:mi:ss'),endtime =>to_date('20050411 17:00:00','yyyymmdd hh24:mi:ss')); END;
*
ERROR 位于第 1 行:
ORA-01323: 状态无效
ORA-06512: 在"SYS.DBMS_LOGMNR", line 53
ORA-06512: 在line 1
i am sorry it is in chinese but the error number is right and the second error is in english
i am very desired to get some suggestion or hints
thank you all for viewing my question.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
