The installed components and their status,
Oracle Database Catalog Views 126.96.36.199.0 Valid Oracle Database Packages and Types 188.8.131.52.0 Valid Oracle XML Database 184.108.40.206.0 Loaded
The XML Database component states as loaded, as there are invalid objects.
–> Tried to recompile invalid objects by running utlrp.sql but no use, still the invalid objects exist.
–> Unable to expdp/impdp due to sys objs being invalid with the below error,
ORA-04063: package body “SYS.DBMS_METADATA” has errors 04063. 00000 – “%s has errors” *Cause: Attempt to execute a stored procedure or use a view that has errors. For stored procedures, the problem could be syntax errors or references to other, non-existent procedures. For views, the problem could be a reference in the view’s defining query to a non-existent table. Can also be a table which has references to non-existent or inaccessible types. *Action: Fix the errors and/or create referenced objects as necessary