ORA-04063: package body "SYS.DBMS_LOGMNR_INTERNAL" has errors
Dear All,
I have to start this thread again, since the situation on the second machine is somewhat different.
On my standby database server that is RAC of 2 node with 11gR2 and Linux is the OS.
Last month I created a new tablespace and set it as a logminer tablespace using command :
EXECUTE DBMS_LOGMNR_D.SET_TABLESPACE('TBS_LOGMINER');
Today morning I accidentally dropped tablespace TBS_LOGMINER and don't have any backup of this tablespace.
Now when i create this tablespace again and run the command:
EXECUTE DBMS_LOGMNR_D.SET_TABLESPACE('TBS_LOGMINER');
It returns the following error:
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:
*"SYS.DBMS_LOGMNR_INTERNAL"*
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 135
ORA-06512: at line 1
Even when I tun exp and expdp
For exp ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
For expdp
ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_INTERNAL_LOGSTDBY"
ORA-06512: at "SYS.KUPV$FT", line 991
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
As I did on the production I run the script files catalog.sql , catproc.sql and utlrp.sql in the same order but unfortunately more objects got invalid that were even valid before running the script files.
When I query
SQL> select comp_name, status from dba_registry;
Oracle Enterprise Manager VALID
OWB VALID
Oracle Application Express VALID
OLAP Catalog VALID
Spatial INVALID
Oracle Multimedia INVALID
Oracle XML Database INVALID
Oracle Text VALID
Oracle Expression Filter INVALID
Oracle Rules Manager INVALID
Oracle Workspace Manager INVALID
Oracle Database Catalog Views VALID
Oracle Database Packages and Types INVALID
JServer JAVA Virtual Machine VALID
Oracle XDK VALID
Oracle Database Java Packages VALID
OLAP Analytic Workspace VALID
Oracle OLAP API VALID
Oracle Real Application Clusters VALID
Before running the script only Oracle XML Database and Oracle Database Packages and Types were invalid.
Similarly more then *150* objects are invalid in sys while before running script there were around *50*, when i query dba_objects for SYS.
Did I made any mistake or there is any other script file to be run?
Thank you so much.
Regards, Imran