ORA-00600 [qerrmOFBu1] Raised by Full Import Using IMPDP over Network Link (Doc ID 1949680.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Full import from Oracle 10.2.0.5 to 12.1.0.2 via DataPump using a network link fails with ORA-600 [qerrmOFBu1] like below:

04-NOV-14 17:14:18.768: ORA-39014: One or more workers have prematurely exited.
04-NOV-14 17:14:18.770: ORA-39029: worker 1 with process name "DW00" prematurely terminated
04-NOV-14 17:14:18.770: ORA-31671: Worker process DW00 had an unhandled exception.
ORA-00600: internal error code, arguments: [qerrmOFBu1], [3148], [ORA-03148: OCI_ATTR_ROW_COUNT cannot return a row count exceeding UB4MAXVAL. The actual row count is [4295000059]], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SQL", line 1707
ORA-06512: at "SYS.KUPD$DATA", line 2495
ORA-06512: at "SYS.KUPD$DATA", line 3398
ORA-06512: at "SYS.KUPD$DATA", line 3911
ORA-06512: at "SYS.KUPW$WORKER", line 19307
ORA-06512: at "SYS.KUPW$WORKER", line 3651
ORA-06512: at "SYS.KUPW$WORKER", line 12049
ORA-06512: at "SYS.KUPW$WORKER", line 2081
ORA-06512: at line 2


Note that the ORA-600 [qerrmOFBu1] shows also below argument

ORA-03148: OCI_ATTR_ROW_COUNT cannot return a row count exceeding UB4MAXVAL


The trace file shows characteristics like below showing the remote access:

----- Current SQL Statement for this session (sql_id=12cd2w2za62xp) -----
INSERT /*+  APPEND  NESTED_TABLE_SET_REFS   PARALLEL(KUT$,1)   */ INTO
 "DEDB"."TT_IMG"  KUT$ ("IMG_ID", "DETN_EVNT_ID", "IMG_TYPE", "ORIG_IMG_TYPE", "IMG_STAT", "IMG_VERF", "FILE_NAME", "CAMERA_DEV_NUM", "CRET_TIME", "LAST_UPD")
 SELECT /*+ NESTED_TABLE_GET_REFS  PARALLEL(KU$,1)  */
 "IMG_ID", "DETN_EVNT_ID", "IMG_TYPE", "ORIG_IMG_TYPE", "IMG_STAT", "IMG_VERF", "FILE_NAME", "CAMERA_DEV_NUM", "CRET_TIME", "LAST_UPD" FROM "DEDB"."TT_IMG"@IRISPRD_PPC KU$


----- Call Stack Trace -----
... OCIKSIN qerrmOFBu qerrmFBu qerrmFetch rwsfcd qerltFetch insdlexe insExecStmtExecIniE ngine insexe ngine opiexe opiall0 opikpr opiodr rpidrus skgmstack rpiswu2 kprball kkxspdbswitch_cbk kkxsexr kkxsexe pevm_icd_call_commo pfrinstr_ICAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr kpoodr upirtrc kpurcsc kpuexec OCIStmtExecute kupprwp ksvrdp opirip opidrv sou2o opimai_real ssthrdmain main

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms