7 Replies Latest reply: Mar 26, 2013 8:39 PM by moslee RSS

    datapump expdp not working after XDB is uninstalled using catnoqm.sql

    789546
      I have 11.2.0.3 database server, We are in the processes of hardeneing database that needs to XDB to be removed if not needed.
      I went ahead and removed XDB using %ORACLE_HOME%/rdbms/admin/catnoqm.sql

      I tried to use export datapump utility after that step. It gives me following errors.

      Export: Release 11.2.0.3.0 - Production on Thu Feb 9 15:02:34 2012

      Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

      Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      ORA-39006: internal error
      ORA-39065: unexpected master process exception in DISPATCH
      ORA-04063: package body "SYS.DBMS_METADATA_UTIL" has errors
      ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_METADATA_UTIL"

      ORA-39097: Data Pump job encountered unexpected error -6508


      Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      How do I fix it back. Please guide me as we need the datapump utility working. I am not sure what to do to restore it

      Thanks