6 Replies Latest reply: Nov 5, 2012 6:24 AM by 968655 RSS

    Export failed with error ORA-04063: package body "SYS.DBMS_CUBE_EXP" has er

    968655
      Hi

      We are having 11.2.0.2 database on Linux 5. From last two days the export backup is getting failed with the below error.

      . exporting post-schema procedural objects and actions
      EXP-00008: ORACLE error 4063 encountered
      ORA-04063: package body "SYS.DBMS_CUBE_EXP" has errors
      ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CUBE_EXP"
      ORA-06512: at line 1
      EXP-00083: The previous problem occurred when calling SYS.DBMS_CUBE_EXP.schema_i
      . exporting statistics
      Export terminated successfully with warnings.

      When I checked the status of this package DBMS_CUBE_EXP its showing invalid. I tried to compile the body of the package. But it was throwing below error.

      SQL> show errors
      Errors for PACKAGE BODY DBMS_CUBE_EXP:

      LINE/COL ERROR
      -------- ----------------------------------------------------------------
      53/5 PL/SQL: SQL Statement ignored
      54/10 PL/SQL: ORA-04045: errors during recompilation/revalidation of
      SYS.DBA_XDS_INSTANCE_SETS
      ORA-01422: exact fetch returns more than requested number of rows

      I tried to query this view or describe the above view. But it was throwing the same error.

      ERROR at line 1:
      ORA-04045: errors during recompilation/revalidation of
      SYS.DBA_XDS_INSTANCE_SETS
      ORA-01422: exact fetch returns more than requested number of rows

      I couldnt get a proper solution from google regarding this view or to compile the above package.

      Now we are stcuked without the backups. It would be great if you guys look into it.

      Thanks
      SHIYAS M
        • 1. Re: Export failed with error ORA-04063: package body "SYS.DBMS_CUBE_EXP" has er
          Sunny kichloo
          Are you using SYS User for taking export Backup
          • 2. Re: Export failed with error ORA-04063: package body "SYS.DBMS_CUBE_EXP" has er
            968655
            Yes I tried with take the export with SYS user. This time it thrown the error in the first and last too same as before.

            About to export specified users ...
            . exporting pre-schema procedural objects and actions
            EXP-00008: ORACLE error 4063 encountered
            ORA-04063: package body "SYS.DBMS_CUBE_EXP" has errors
            ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CUBE_EXP"
            ORA-06512: at line 1
            EXP-00083: The previous problem occurred when calling SYS.DBMS_CUBE_EXP.schema_info_exp
            . exporting foreign function library names for user U_20102
            . exporting PUBLIC type synonyms
            . exporting private type synonyms
            . exporting object type definitions for user U_20102
            About to export U_20102's objects ...


            I ran below scripts as per u provided the link

            @$ORACLE_HOME/rdbms/admin/catdpb.sql and utlrp.sql

            Still it didnt get compiled.

            One more thing I tried running expdp. It totally got failed by throwing the similar error. It didnt even export the tables too.

            ===============================================================================

            Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
            ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
            ORA-31642: the following SQL statement fails:
            BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,'11.02.00.00.00'); END;
            ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
            ORA-06512: at "SYS.DBMS_METADATA", line 1245
            ORA-04063: package body "SYS.DBMS_CUBE_EXP" has errors
            ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CUBE_EXP"

            ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
            ORA-06512: at "SYS.KUPW$WORKER", line 8353

            ----- PL/SQL Call Stack -----
            object line object
            handle number name
            0x1a3257060 19208 package body SYS.KUPW$WORKER
            0x1a3257060 8385 package body SYS.KUPW$WORKER
            0x1a3257060 12748 package body SYS.KUPW$WORKER
            0x1a3257060 2546 package body SYS.KUPW$WORKER
            0x1a3257060 9054 package body SYS.KUPW$WORKER
            0x1a3257060 1688 package body SYS.KUPW$WORKER
            0x1a8bc1630 2 anonymous block

            Estimate in progress using BLOCKS method...
            Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
            ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
            ORA-31642: the following SQL statement fails:
            BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,'11.02.00.00.00'); END;
            ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
            ORA-06512: at "SYS.DBMS_METADATA", line 1245
            ORA-04063: package body "SYS.DBMS_CUBE_EXP" has errors
            ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CUBE_EXP"

            ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
            ORA-06512: at "SYS.KUPW$WORKER", line 8353

            ----- PL/SQL Call Stack -----
            object line object
            handle number name
            0x1a3257060 19208 package body SYS.KUPW$WORKER
            0x1a3257060 8385 package body SYS.KUPW$WORKER
            0x1a3257060 12748 package body SYS.KUPW$WORKER
            0x1a3257060 2546 package body SYS.KUPW$WORKER
            0x1a3257060 9054 package body SYS.KUPW$WORKER
            0x1a3257060 1688 package body SYS.KUPW$WORKER
            0x1a8bc1630 2 anonymous block

            Job "SYS"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 17:58:34

            =========================================================================
            • 3. Re: Export failed with error ORA-04063: package body "SYS.DBMS_CUBE_EXP" has er
              Helios-GunesEROL
              Hi;

              Similar error mention at      Ora-39127: Unexpected Error From Call To Export_string :=Sys.Dbms_cube_exp [ID 811934.1]. Please review

              Regard
              Helios
              • 4. Re: Export failed with error ORA-04063: package body "SYS.DBMS_CUBE_EXP" has er
                Osama_Mustafa
                also check
                Full Database Export Fails With Errors ORA-1031 EXP-83 On Resource Manager Objects [ID 105955.1]
                • 5. Re: Export failed with error ORA-04063: package body "SYS.DBMS_CUBE_EXP" has er
                  968655
                  The link provided has helped me. It was due to workspace package from export. DBMS_CUBE_EXP was deleted from the workspace. After that export is working fine.

                  Thanks a lot.