ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Bug4383811 - OERI:qerxtAgentOpen_911 during datapump import

Bug4383811 - OERI:qerxtAgentOpen_911 during datapump import

原创 Linux操作系统 作者:ginni_hua 时间:2009-02-24 16:24:00 0 删除 编辑

今天在在用datapump import時,遇到了ora-600了.

問題描述:

impdp content=data_only tables=ems.ems_tbr directory=dump dumpfile=sgerpdb_2009_02_21.dmp

logfile=12.log
Import: Release 10.2.0.1.0 - Production on Tuesday, 24 February, 2009 12:41:01
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "SYSTEM"."SYS_IMPORT_TABLE_03" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TABLE_03":  system/******** content=data_only tables=ems.ems_tbr

directory=dump dumpfile=s
gerpdb_2009_02_20.dmp logfile=123.log
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-00600: internal error code, arguments: [qerxtAgentOpen_911], [22], [21], [], [], [], [], []
ORA-06512: at "SYS.KUPW$WORKER", line 1345
ORA-06512: at line 2
Job "SYSTEM"."SYS_IMPORT_TABLE_03" stopped due to fatal error at 12:41:41
ORA-39014: One or more workers have prematurely exited.

奇怪啊,重復幾次都同樣的Error。於是drop掉table再導:

impdp content=all tables=ems.ems_tbr directory=dump dumpfile=sgerpdb_2009_02_21.dmp logfile=12.log

呵呵,成功了。最後發現相應的表結構有變化,原來少了一字段呵,讓我第一次碰到了它4383811.

Bug 4383811 - OERI:qerxtAgentOpen_911 during datapump import
Doc ID: Note:4383811.8 Type: PATCH
This note gives a brief overview of bug 4383811.
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions >= 10.1.0.2 but < 11
Versions confirmed as being affected 10.1.0.5
10.2.0.2

Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in 10.2.0.3 (Server Patch Set)
11g (Future version)

Symptoms: Related To:
Internal Error May Occur (ORA-600)
ORA-600 [qerxtAgentOpen_911]

Description
ORA-600[qerxtAgentOpen_911] can occur during datapump import
with a QUERY parameter if a column has been added to the table
after exporting the data using expdp.
Workaround:
There are a few workarounds for this issue.
1. Delete unwanted rows after importing all data without a QUERY parameter
2. Import all data into temporary table and then insert some of them
into the original table using WHERE clause. This may require that
the existing table be renamed before the export begins and after
the export completes

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7836221/viewspace-557600/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 又做夢了
请登录后发表评论 登录
全部评论

注册时间:2008-03-20

  • 博文量
    174
  • 访问量
    364245