"SYSTEM.DBMS_LOGMNR_D" 不存在

Question

SQL> @E:\oracle\product\10.1.0\db_1\RDBMS\ADMIN\dbmslmd.sql 
 
Session altered
 
DECLARE/***************************************************************************
 *
 *    NAME
 *      This is the main block.  It is unnamed.
 *
 *    DESCRIPTION
 *      Creates/Replaces or Upgrades all Logminer meta data.
 *
 *    PARAMETERS
 *
 *    TRANSACTION
 *
 *    ERRORS
 *       All errors are signalled.
 *
 */  LOGMNR_UPGRADE_DUPNAME EXCEPTION;
  PRAGMA EXCEPTION_INIT(LOGMNR_UPGRADE_DUPNAME, -955);  LOGMNR_UPGRADE_ALREADYLIST EXCEPTION;
  PRAGMA EXCEPTION_INIT(LOGMNR_UPGRADE_ALREADYLIST, -1408);  LOGMNR_UPGRADE_DUPCOL EXCEPTION;
  PRAGMA EXCEPTION_INIT(LOGMNR_UPGRADE_DUPCOL, -1430);  LOGMNR_UPGRADE_ALREADYNOT EXCEPTION;
  PRAGMA EXCEPTION_INIT(LOGMNR_UPGRADE_ALREADYNOT, -1442);  LOGMNR_UPGRADE_NOTAPART EXCEPTION;
  PRAGMA EXCEPTION_INIT(LOGMNR_UPGRADE_NOTAPART, -2149);  LOGMNR_UPGRADE_LIMITOF1 EXCEPTION;
  PRAGMA EXCEPTION_INIT(LOGMNR_UPGRADE_LIMITOF1, -2260);  LOGMNR_UPGRADE_DUPPK EXCEPTION;
  PRAGMA EXCEPTION_INIT(LOGMNR_UPGRADE_DUPPK, -2261);  LOGMNR_UPGRADE_NOSUCHPK EXCEPTION;
  PRAGMA EXCEPTION_INIT(LOGMNR_UPGRADE_NOSUCHPK, -2441);
  DumpDebugMsgs    CONSTANT BOOLEAN        := FALSE;
  output_warning   CONSTANT BOOLEAN        := FALSE;
  tablespacename   VARCHAR2(32)            := 'SYSAUX';  /***************************************************************************
   *
   *    NAME
   *      logmnrRunSQL
   *
   *    DESCRIPTION
   *       Dynamically execute a SQL command.
   *
   *    PARAMETERS
   *       command       IN: The SQL command to be executed.
   *       ignoreErrors  IN: FALSE (defualt) causes errors to be raised
   *                         TRUE causes errors to be ignored
   *    TRANSACTION
   *
   *    ERRORS
   *       Error conditions are raised or ignored dependent on ignoreErrors
   *       input parameter.
   */
  PROCEDURE logmnrRunSQL( command   IN VARCHAR2,
                          ignoreErrors IN BOOLEAN DEFAULT FALSE )
  IS
 
ORA-06550: 第 1864 行, 第 18 列: 
PL/SQL: ORA-00942: 表或视图不存在
ORA-06550: 第 1863 行, 第 5 列: 
PL/SQL: SQL Statement ignored
ORA-06550: 第 2654 行, 第 26 列: 
PL/SQL: ORA-00942: 表或视图不存在
ORA-06550: 第 2653 行, 第 5 列: 
PL/SQL: SQL Statement ignored
ORA-06550: 第 2674 行, 第 38 列: 
PL/SQL: ORA-00942: 表或视图不存在
ORA-06550: 第 2673 行, 第 9 列: 
PL/SQL: SQL Statement ignored
 
Session altered
 
Package created
 
这边就创建不成功 后面就老提示这个错误
这个要怎么解决呢

Answer 1

安装包时注意
1、使用sys用户
2、要注意安装包体(对应prvtXXX.plb)

Answer 2

SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE ('E:\oracle\product\logs\ARC00106_0715020654.001',DBMS_LOGMNR.NEW);
 
PL/SQL procedure successfully completed
 
SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
 
PL/SQL procedure successfully completed
 
SQL> select username,SESSION_INFO,SQL_REDO from V$LOGMNR_CONTENTS where rownum < 5;
 
USERNAME                       SESSION_INFO                                                                     SQL_REDO
------------------------------ -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
                                                                                                                delete from "WISUN"."DATATEMP" where "SCN" = '21291' and "TIMESTAMP" = TO_DATE('
                                                                                                                delete from "WISUN"."DATATEMP" where "SCN" = '21292' and "TIMESTAMP" = TO_DATE('
                                                                                                                set transaction read write;
                                                                                                                insert into "WISUN"."DATATEMP"("SCN","TIMESTAMP","SRCIP","SRCPORT","SRCMAC","DST
为什么前面两个字段没值呢 这个怎么回事呢