8 Replies Latest reply: Jul 31, 2012 2:12 PM by 656218 RSS

    Errors importing TTS using impdp

    656218
      Hello All,

      I am seeing following errors when importing TTS using impdp. Please let me know if you know any work around.

      Thanks,
      Sunny boy

      Corp_DEODWPRD$ impdp parfile=impdp_tts.par

      Import: Release 11.2.0.3.0 - Production on Mon Jul 30 13:23:50 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, Automatic Storage Management, OLAP, Data Mining
      and Real Application Testing options
      Master table "SYS"."SYS_IMPORT_TRANSPORTABLE_02" successfully loaded/unloaded
      Starting "SYS"."SYS_IMPORT_TRANSPORTABLE_02": /******** AS SYSDBA parfile=impdp_tts.par
      Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
      Processing object type TRANSPORTABLE_EXPORT/TABLE
      Processing object type TRANSPORTABLE_EXPORT/GRANT/OWNER_GRANT/OBJECT_GRANT
      ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYS"."SYS_IMPORT_TRANSPORTABLE_02" WHERE process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order]
      ORA-39183: internal error -19 ocurred during decompression phase 2

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
      ORA-06512: at "SYS.KUPW$WORKER", line 9001

      ----- PL/SQL Call Stack -----
      object line object
      handle number name
      0x5d9562370 20462 package body SYS.KUPW$WORKER
      0x5d9562370 9028 package body SYS.KUPW$WORKER
      0x5d9562370 4185 package body SYS.KUPW$WORKER
      0x5d9562370 9725 package body SYS.KUPW$WORKER
      0x5d9562370 1775 package body SYS.KUPW$WORKER
      0x59c4fbb90 2 anonymous block

      Job "SYS"."SYS_IMPORT_TRANSPORTABLE_02" stopped due to fatal error at 13:52:57

      *************************************************************************************************

      PAR file:

      USERID='/ as sysdba'
      directory=ODW_MIG_DIR
      dumpfile=exp_full_ODW_tts_20120719_01.dmp
      logfile=imp_FULL_ODW_TTS_20120730.log
      exclude=PROCACT_INSTANCE
      TRANSPORT_DATAFILES=(
      '+DEODW_DATA_GRP/deodwprd/data/ts_appsds_d_01.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/ts_appsds_i_01.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_aud_d_01.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_capone_d01_02.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_capone_d01_03.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_capone_d01_01.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_capone_d_p2012_01.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_capone_i01_01.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_ts_ccr_d01_3.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_ts_ccr_d01_2.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_ts_ccr_d01_1.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_cst_stage_d_01.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_cst_stage_i_01.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_dsdw_doc_stg_d01_01.dbf',
      .
      .
      .
      '+DEODW_DATA_GRP/deodwprd/data/deodw_x_etl_d01_02.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_x_report_work_d01_01.dbf',
      '+DEODW_DATA_GRP/deodwprd/data/deodw_x_sas_d01_01.dbf')
        • 1. Re: Errors importing TTS using impdp
          Srini Chavali-Oracle
          >
          ...
          Starting "SYS"."SYS_IMPORT_TRANSPORTABLE_02": /******** AS SYSDBA parfile=impdp_tts.par
          ...
          >

          Do not invoke expdp or impdp using "/ as sysdba" - pl see the first Note section here - http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm#i1012504

          Can you retry with the SYSTEM account instead ? If the error persists, pl open an SR as it might be a bug

          HTH
          Srini
          • 2. Re: Errors importing TTS using impdp
            656218
            Thank you Srini for your reply. I will try with the system account and let you know how it goes. I already raised a SR with oracle.

            Wondering if there is a way to resume this job? There is no entry in dba_datapump_job view for this job.

            Thanks,
            • 3. Re: Errors importing TTS using impdp
              Srini Chavali-Oracle
              I would not resume this job - start all over again

              HTH
              Srini
              • 4. Re: Errors importing TTS using impdp
                656218
                Still the same error with system account. Working with oracle about this iissue.

                Corp_DEODWPRD$ impdp parfile=impdp_tts.par

                Import: Release 11.2.0.3.0 - Production on Tue Jul 31 11:47:32 2012

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

                UDI-28002: operation generated ORACLE error 28002
                ORA-28002: the password will expire within 6 days

                Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
                With the Partitioning, Automatic Storage Management, OLAP, Data Mining
                and Real Application Testing options
                Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
                Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/******** parfile=impdp_tts.par
                Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
                Processing object type TRANSPORTABLE_EXPORT/TABLE
                Processing object type TRANSPORTABLE_EXPORT/GRANT/OWNER_GRANT/OBJECT_GRANT
                ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name, subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property, size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" WHERE  process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order]
                ORA-39183: internal error -19 ocurred during decompression phase 2

                ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
                ORA-06512: at "SYS.KUPW$WORKER", line 9001

                ----- PL/SQL Call Stack -----
                object line object
                handle number name
                0x5dac10b98 20462 package body SYS.KUPW$WORKER
                0x5dac10b98 9028 package body SYS.KUPW$WORKER
                0x5dac10b98 4185 package body SYS.KUPW$WORKER
                0x5dac10b98 9725 package body SYS.KUPW$WORKER
                0x5dac10b98 1775 package body SYS.KUPW$WORKER
                0x59c554178 2 anonymous block

                Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at 12:13:04

                Edited by: Sunny boy on Jul 31, 2012 12:16 PM
                • 5. Re: Errors importing TTS using impdp
                  Srini Chavali-Oracle
                  Pl also confirm that the expdp command did not use "/ as sysdba" when it was executed

                  HTH
                  Srini
                  • 6. Re: Errors importing TTS using impdp
                    656218
                    Here it is, starred out password.

                    Corp_DEODWPRD$ head -30 impdp_tts.par
                    USERID=system/*******
                    directory=ODW_MIG_DIR
                    dumpfile=exp_full_ODW_tts_20120719_01.dmp
                    logfile=imp_FULL_ODW_TTS_20120730.log
                    exclude=PROCACT_INSTANCE
                    TRANSPORT_DATAFILES=(
                    '+DEODW_DATA_GRP/deodwprd/data/ts_appsds_d_01.dbf',
                    '+DEODW_DATA_GRP/deodwprd/data/ts_appsds_i_01.dbf',
                    '+DEODW_DATA_GRP/deodwprd/data/deodw_aud_d_01.dbf',
                    '+DEODW_DATA_GRP/deodwprd/data/deodw_capone_d01_02.dbf',
                    '+DEODW_DATA_GRP/deodwprd/data/deodw_capone_d01_03.dbf',
                    '+DEODW_DATA_GRP/deodwprd/data/deodw_capone_d01_01.dbf',
                    '+DEODW_DATA_GRP/deodwprd/data/deodw_capone_d_p2012_01.dbf',
                    '+DEODW_DATA_GRP/deodwprd/data/deodw_capone_i01_01.dbf',
                    '+DEODW_DATA_GRP/deodwprd/data/deodw_ts_ccr_d01_3.dbf',
                    '+DEODW_DATA_GRP/deodwprd/data/deodw_ts_ccr_d01_2.dbf',
                    '+DEODW_DATA_GRP/deodwprd/data/deodw_ts_ccr_d01_1.dbf',
                    '+DEODW_DATA_GRP/deodwprd/data/deodw_cst_stage_d_01.dbf',
                    '+DEODW_DATA_GRP/deodwprd/data/deodw_cst_stage_i__01.dbf',

                    Edited by: Sunny boy on Jul 31, 2012 1:41 PM
                    • 7. Re: Errors importing TTS using impdp
                      Srini Chavali-Oracle
                      Yes - I know for impdp you used SYSTEM - I was asking about expdp :-)

                      HTH
                      Srini
                      • 8. Re: Errors importing TTS using impdp
                        656218
                        Oops, for expdp I was still using using SYS.

                        Anyway I have identified the issue. There is a global temporary table owned by one of the users. I excluded it from the export and the import ran fine after that.

                        Sunny boy