1.创建DBMS_LOGMNR包
2.修改初始化参数UTL_FILE_DIR,指定分析数据的存放处
3.重启数据库
做完以上步骤后,我就进行创建数据字典文件,可以下语句不能执行。
SQL>EXECUTE dbms_logmnr_d.build(
dictionary_filename => 'sqltrace.ora',
dictionary_location => 'd:/oracle/oracle/logminer/log');
报错如下:
ERROR 位于第 1 行:
ORA-06550: 第 1 行, 第 27 列:
PLS-00103: 出现符号 ";"在需要下列之一时:
( ) - + case mod new not null
others <an identifier> <a double-quoted delimited-identifi
<a bind variable> table avg count current exists max min
prior sql stddev sum variance execute multiset the both
leading trailing forall merge year month DAY_ hour minute
second timezone_hour timezone_minute timezone_region
timezone_abbr time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL s
SQL> dictionary_filename => 'sqltrace.ora',
SP2-0734: 未知的命令开头 "dictionary..." - 忽略了剩余的行。
SQL> dictionary_location => 'd:/oracle/oracle/logminer/log
SP2-0734: 未知的命令开头 "dictionary..." - 忽略了剩余的行。在线等候给予指点,谢谢!
2.修改初始化参数UTL_FILE_DIR,指定分析数据的存放处
3.重启数据库
做完以上步骤后,我就进行创建数据字典文件,可以下语句不能执行。
SQL>EXECUTE dbms_logmnr_d.build(
dictionary_filename => 'sqltrace.ora',
dictionary_location => 'd:/oracle/oracle/logminer/log');
报错如下:
ERROR 位于第 1 行:
ORA-06550: 第 1 行, 第 27 列:
PLS-00103: 出现符号 ";"在需要下列之一时:
( ) - + case mod new not null
others <an identifier> <a double-quoted delimited-identifi
<a bind variable> table avg count current exists max min
prior sql stddev sum variance execute multiset the both
leading trailing forall merge year month DAY_ hour minute
second timezone_hour timezone_minute timezone_region
timezone_abbr time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL s
SQL> dictionary_filename => 'sqltrace.ora',
SP2-0734: 未知的命令开头 "dictionary..." - 忽略了剩余的行。
SQL> dictionary_location => 'd:/oracle/oracle/logminer/log
SP2-0734: 未知的命令开头 "dictionary..." - 忽略了剩余的行。在线等候给予指点,谢谢!
dictionary_filename => 'sqltrace.ora', \
dictionary_location => 'd:/oracle/oracle/logminer/log');
dictionary_filename => 'sqltrace.ora',
dictionary_location => 'd:\oracle\oracle\logminer\log');
ERROR 位于第 1 行:
ORA-01336: 无法打开指定的字典文件
ORA-29280: 目录路径无效
ORA-06512: 在"SYS.DBMS_LOGMNR_D", line 920
ORA-06512: 在"SYS.DBMS_LOGMNR_D", line 1938
ORA-06512: 在line 1
d:/oracle/logminer
我把脚本改成这样,也不行!^^^^^
SQL> @d:/oracle/ora92/rdbms/admin/dbmslms.sql
SQL>@d:/oracle/ora92/rdbms/admin/dbmslm.sql
SQL>@d:/oracle/ora92/rdbms/admin/dbmslmd.sql
SQL>@d:/oracle/ora92/rdbms/admin/prvtlm.plb
2.修改初始化参数UTL_FILE_DIR,指定分析数据的存放处
SQL>alter system set UTL_FILE_DIR='d:/oracle/logminer' scope=spfile;
3.重启数据库
SQL>shutdown immediate
SQL>startup
4.创建数据字典文件
SQL>EXECUTE dbms_logmnr_d.build(dictionary_filename => 'sqltrace.ora',dictionary_location => 'd:/oracle/logminer/log');
改成
dictionary_location => 'd:/oracle/logminer'
SQL> conn /as sysdba;
ERROR:
ORA-01041: 内部错误,hostdef 扩展名不存在