-
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|