ORA-04067: not executed, package body "SYSTEM.DBMS_LOGMNR" does not exist

Hi,

I am working on LOGMNR concepts..

I have login to sql as a Sys and i run below script to install the LOGMNR package

SQL>@$ORACLE_HOME/rdbms/admin/dbmslm.sql;

Proceeds this below sql staements

Sql>Grant the EXECUTE_CATALOG_ROLE role;

SQL>GRANT EXECUTE_CATALOG_ROLE TO Srikanth;

SQL> CREATE PUBLIC SYNONYM DBMS_LOGMNR FOR SYS.DBMS_LOGMNR;

until this all are sccussfully ecexcuted.

SQL> BEGIN
2 DBMS_LOGMNR.ADD_LOGFILE
3 ('/usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/onlinel/o1_mf_2_5nt8lv29_.log');
4 END;
5 /
BEGIN
*
ERROR at line 1:
ORA-04067: not executed, package body "SYSTEM.DBMS_LOGMNR" does not exist
ORA-06508: PL/SQL: could not find program unit being called:
"SYSTEM.DBMS_LOGMNR"
ORA-06512: at line 2


Can any one help me to resolve this problem.


Thanks
Srikanth

Quote:

---

Originally Posted by Srikanth.ka

ORA-04067: not executed, package body "SYSTEM.DBMS_LOGMNR" does not exist

---

SYSTEM? Shouldn't DBMS_LOGMNR be owned by SYS?

Please check...

Code:

---

select owner, object_name, object_type
from  dba_objects
where  object_name = 'DBMS_LOGMNR';

---

Dear PAVB

Thanks for the clue...i will get back to you the results...

Thanks
Srikanth