Re: Oracle impdp parallel issues

_at_Oscar : Table is still there in the database . I just continued this old thread as the error message generated was same and replated to expdp , anyways from next time new thread :)

_at_Orion : RAC or not ? not sure will check once i get back to office.

_at_Edwin : No xml type or lob column in table.

SR with oracle is in progress for last few days as per them :

Trace of dw :

 SQL> alter system set events 'sql_trace {process : pname = dw | pname = dm} level=8';

WAIT #47001882895456: nam='wait for unread message on broadcast channel' ela= 1001658 channel context=14216224800 channel handle=14137260376 p3=0 obj#=12756289 tim=1416782389247019
EXEC
#47001882895456:c=1000,e=5006933,p=0,cr=4,cu=0,mis=0,r=0,dep=2,og=1,plh=0,tim=1416782389247328 ERROR #47001882895456:err=25228 tim=1416782389247359 CLOSE #47001882895456:c=0,e=24,dep=2,type=0,tim=1416782389247485

ksedmp: internal or fatal error
ORA-25228: timeout or end-of-fetch during message dequeue from sys.kupc$que_int.transceive_int

*This may be a problem at the AQ$ layer causing master process to signal object doesn't exist. *

On Mon, Nov 24, 2014 at 10:37 AM, edwin devadanam <edwin_kodamala_at_yahoo.com> wrote:

> check this out
>
> Data Pump Export Of An XML Table Fails With ORA-600 [qmcxeGetPfxId2] (Doc
> ID 1921325.1)
>
> APPLIES TO:
>
> *Oracle Database - Enterprise Edition - Version 11.2.0.4 and later*
> Information in this document applies to any platform.
> SYMPTOMS
>
> ORA-600 [QMCXEGETPFXID2] is raised from DataPump Export EXPDP of XMLType
> table.
>
> Errors ora-31693, ora-29913, ora-600 are seen in export log
>
> ORA-31693: Table data object "EVT"."DOSYA" failed to load/unload and is
> being skipped due to error:
> ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
> ORA-00600: internal error code, arguments: [qmcxeGetPfxId2], [], [], [],
> [], [], [], [], [], [], [], []
>
>
> CAUSE
>
> Bug 19051460: ORA-600 [QMCXEGETPFXID2] from EXPDP of TABLE with XMLTYPE
> column and database character set is not UTF8
>
>
> SOLUTION
>
> Apply Patch 19051460 to resolve the ora-600 from table export failure.
>
>
> REFERENCES
>
> BUG:19051460 - ORA-600 [QMCXEGETPFXID2] ON EXPDP OF TABLE WITH XMLTYPE
>
>
> thanks,
> Edwin.K
>
>
> On Monday, November 24, 2014 10:03 AM, sumit Tyagi <
> dba.tyagisumit_at_gmail.com> wrote:
>
>
> HI Guys,
>
> Same issue with expdp . Please help . Any recommendations .
>
> Starting "SYS"."SYS_EXPORT_TABLE_01": AS SYSDBA directory=EXPDP_21NOV14
> dumpfile=expdp_23Nov14_LISTING_%U logfile=expdp_23Nov14_LISTING.log
> tables=IME.BLS_MLSBLUE_LIST
> exclude=constraint,ref_constraint,index,statistics parallel=4
>
> Estimate in progress using BLOCKS method...
> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
> Total estimation using BLOCKS method: 89.94 GB
> Processing object type TABLE_EXPORT/TABLE/TABLE
> Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
> Processing object type TABLE_EXPORT/TABLE/TRIGGER
> ORA-31693: Table data object "IME.BLS_MLSBLUE_LIST" failed to load/unload
> and is being skipped due to error:
> ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
> ORA-08103: object no longer exists
> Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
>
> ******************************************************************************
>
>
> BR
> Sumit
>
> On Sun, Jun 1, 2014 at 4:41 PM, Jack van Zanen <jack_at_vanzanen.com> wrote:
>
> Unfortunately not,
>
> Another member of the list pointd to a bug in impdp with parallel that as
> of yet is unresolved..
> Oracle has confirmed the bug, lets see if they come back with something.
>
> We are using this because of a bug we were hitting when moving database
> from tru64 to AIX and 9i to 10g (11g not supported). All clustered tables
> got messed up during the process so after migration we have to export,
> drop, recreate and import many TB of data.
> Oracle have been very ordinary in their support, even though we are paying
> for extended support.
>
> Thanks
>
> Jack
>
>
> On Sunday, June 1, 2014, David Barbour <david.barbour1_at_gmail.com> wrote:
>
> Is this a RAC database? I've seen this on a RAC when the dump directory
> isn't shared across the nodes.
>
>
> On Thu, May 29, 2014 at 5:13 PM, Jack van Zanen <jack_at_vanzanen.com> wrote:
>
> Hi All,
>
> My co-worker is doing a reorg/rebuild of cluster tables which involves
> expdp and impdp
> He exports the table into multiple files using the %U parameter drops the
> clustered table and imports it again.
> During the import he gets below error.
> The files are there, permissions are proper and when not running in
> parallel it finishes without issues.
> We just need the parallel to make it go faster and fit withing the go-live
> cutover window.
>
>
> ORA-31693: Table data object "XYZ"."METER_READING_S11Y10M08" failed to
> load/unload and is being skipped due to error:
> ORA-29913: error in executing ODCIEXTTABLEFETCH callout
> ORA-31640: unable to open dump file
> "/oraarchive101/exp/expdp_meter_y10_04.dmp" for read
> ORA-19505: failed to identify file
> "/oraarchive101/exp/expdp_meter_y10_04.dmp"
> ORA-27041: unable to open file
> IBM AIX RISC System/6000 Error: 22: Invalid argument
> Additional information: 2
> ORA-31693: Table data object "XYZ"."METER_READING_S11Y10M01" failed to
> load/unload and is being skipped due to error:
> ORA-29913: error in executing ODCIEXTTABLEFETCH callout
> ORA-31640: unable to open dump file
> "/oraarchive101/exp/expdp_meter_y10_05.dmp" for read
> ORA-19505: failed to identify file
> "/oraarchive101/exp/expdp_meter_y10_05.dmp"
> ORA-27041: unable to open file
>
> Parameter File :
>
> userid=/
> schemas=xyz
> directory=meter_exp_arch
> dumpfile=expdp_meter_y11_%U.dmp
> EXCLUDE=STATISTICS
> logfile=impdp_meter_y11.log
> parallel=24
>
>
> This is Oracle 10.2.0.4 on AIX.
>
> Has anyone seen this before and know of a solution?
>
> Jack van Zanen
>
> -------------------------
> This e-mail and any attachments may contain confidential material for the
> sole use of the intended recipient. If you are not the intended recipient,
> please be aware that any disclosure, copying, distribution or use of this
> e-mail or any attachment is prohibited. If you have received this e-mail in
> error, please contact the sender and delete all copies.
> Thank you for your cooperation
>
>
>
>
> --
> Jack van Zanen
>
> -------------------------
> This e-mail and any attachments may contain confidential material for the
> sole use of the intended recipient. If you are not the intended recipient,
> please be aware that any disclosure, copying, distribution or use of this
> e-mail or any attachment is prohibited. If you have received this e-mail in
> error, please contact the sender and delete all copies.
> Thank you for your cooperation
>
>
>
>
> --
>
> *--*
> *BR*
> *Sumit Tyagi*
> *+91-7829543355*
>
>
>

-- 

*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*

--
http://www.freelists.org/webpage/oracle-l