Re: Using Logminer

In article <9h8r426254_at_enews1.newsguy.com>, 64.14.6.99 says...
>
>
>Hello,
>
>I am trying to run logminer on my oracle database 8.1.6, but am getting some
>errors. Am following following steps -
>
>1. Add a variable in D:\Oracle\Admin\<database>\pfile\init.ora for UTL_FILE_DIR
>
>2. Execute D:\Oracle\Ora81\RDBMS\Admin\dbmslm.sql - runs successfully.
>
>3. Execute D:\Oracle\Ora81\RDBMS\Admin\dbmslmd.sql - gives following error -
>

these scripts are to be run when connected as SYS or INTERNAL using SVRMGRL

You appear to be trying to run them as some other user.

><<<<<<<<<<<<<<<<<<<Error Begin>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>Package created.
>
>
>Warning: Package Body created with compilation errors.
>
>Errors for PACKAGE BODY DBMS_LOGMNR_D:
>
>LINE/COL ERROR
>-------- -----------------------------------------------------------------
>173/7 PL/SQL: SQL Statement ignored
>175/15 PLS-00201: identifier 'SYS.V$COMPATIBILITY' must be declared
>178/7 PL/SQL: SQL Statement ignored
>184/16 PLS-00201: identifier 'SYS.V$DATABASE' must be declared
>193/7 PL/SQL: SQL Statement ignored
>193/42 PLS-00201: identifier 'SYS.OBJ$' must be declared
>268/3 PL/SQL: SQL Statement ignored
>268/14 PLS-00320: the declaration of the type of this expression is
> incomplete or malformed
>
>287/8 PLS-00201: identifier 'SYS.COL$' must be declared
>
>LINE/COL ERROR
>-------- -----------------------------------------------------------------
>303/5 PL/SQL: SQL Statement ignored
>693/1 PL/SQL: SQL Statement ignored
>693/38 PLS-00201: identifier 'SYS.V_$PARAMETER' must be declared
>
>Grant succeeded.
><<<<<<<<<<<<<<<<<<<Error End>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>
>Any idea why is this happenning? Thanks for your help.
>
>Regards,
>Sumitabh
>
>==================================
>Poster's IP address: 64.14.6.99
>Posted via http://nodevice.com
>Linux Programmer's Site

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp