ORA-4063 when Executing DBMS_LOGMNR_D.SET_TABLESPACE (Doc ID 577426.1)
— Problem Statement:
Setiting logminer to a specific tablespace reports the following error
SQL> BEGIN dbms_logmnr_d.set_tablespace(‘logmnr_tbs’); end;
2 BEGIN dbms_logmnr_d.set_tablespace(‘logmnr_tbs’); end;
ERROR at line 1:
ORA-04063: package body “SYS.DBMS_LOGMNR_INTERNAL” has errors
ORA-06508: PL/SQL: could not find program unit being called:
ORA-06512: at “SYS.DBMS_LOGMNR_D”, line 131
ORA-06512: at line 1
Dba_Registry shows an invalid component and there are invalid objects in the sys and system schema
related to logminer.
from the following queries show that Oracle Database Packages and Types
are INVALID and that logminer objects are invalid.
select object_name, owner, object_type from dba_objects where status = ‘INVALID’ and owner in
— To implement the solution, please execute the following steps::
1. Run this query as sys. It should come back with NO rows.
2. To validate the packages and types by running catupgrd.sql (part of the 10.2.0.3 patch installation)
–start the db
–spool to a file
–run the upgrade script
–turn off spooling (review file for errors)
–shutdown and restart.
3. Confirm that all SYS and SYTEM owned objects are valid.
Check that Oracle Database Packages and Types is VALID in dba_registry.
4. Run dbms_logmnr_d.set_tablespace to set the logminer tablespace.