ORA-04067: not executed, package body "SYSTEM.DBMS_LOGMNR" does not exist
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Feb 2010
    Posts
    1

    Question 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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by Srikanth.ka View Post
    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';
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Feb 2010
    Posts
    1

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

    Dear PAVB

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

    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
  •  


Click Here to Expand Forum to Full Width