impdp -->ORA-600 [kpotcgah-9]

最新推荐文章于 2021-04-10 11:09:07 发布

转载最新推荐文章于 2021-04-10 11:09:07 发布 · 247 阅读

文章标签：

#数据库

在使用impdp导入数据时遇到ORA-600内部错误，通过去除并行设置（parallel=1）解决了问题。此错误可能与共享池资源不足有关，增大SGA_TARGET或将并行数设为1可以避免该问题。

impdp 遭遇 ORA-600 错误，

解决方法：去掉并行，parallel=1

Mon Jun 20 14:49:44 2011
DM00 started with pid=58, OS id=19464672, job HLDBA.SYS_IMPORT_SCHEMA_08
Mon Jun 20 14:49:48 2011
DW00 started with pid=59, OS id=2752626, wid=1, job HLDBA.SYS_IMPORT_SCHEMA_08
Mon Jun 20 14:50:06 2011
DW01 started with pid=60, OS id=5046318, wid=2, job HLDBA.SYS_IMPORT_SCHEMA_08
Mon Jun 20 14:50:06 2011
DW02 started with pid=63, OS id=13631978, wid=3, job HLDBA.SYS_IMPORT_SCHEMA_08
Mon Jun 20 14:50:06 2011
DW03 started with pid=64, OS id=12910848, wid=4, job HLDBA.SYS_IMPORT_SCHEMA_08
Mon Jun 20 15:01:58 2011
DM00 started with pid=63, OS id=5177400, job HLDBA.SYS_IMPORT_TABLE_01
Mon Jun 20 15:02:00 2011
DW00 started with pid=64, OS id=20775338, wid=1, job HLDBA.SYS_IMPORT_TABLE_01
Mon Jun 20 15:02:20 2011
DM00 started with pid=64, OS id=17236312, job HLDBA.SYS_IMPORT_TABLE_01
Mon Jun 20 15:02:22 2011
DW00 started with pid=66, OS id=7667988, wid=1, job HLDBA.SYS_IMPORT_TABLE_01
Mon Jun 20 15:02:25 2011
Errors in file /opt/oracle/diag/rdbms/homelink/Homelink/trace/Homelink_p002_13762670.trc (incident=136736):
ORA-00600: internal error code, arguments: [kpotcgah-9], [0], [ORA-00600: internal error code, arguments: [], [], [], [], [], [], []
, [], [], [], [], []
], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/homelink/Homelink/incident/incdir_136736/Homelink_p002_13762670_i136736.trc
Mon Jun 20 15:04:35 2011
Trace dumping is performing id=[cdmp_20110620150435]
Mon Jun 20 15:04:40 2011
Sweep [inc][136736]: completed
Sweep [inc2][136736]: completed

---------------------------REFERENCE:

http://pingshx.itpub.net/post/39434/495074

碰到这个错误的情形:用expdp导一张表，除了参数directory,dumpfile,logfile,tables之外，加上了parallel=4参数，得到的具体错误如下：

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-31693: Table data object "BASELDWH"."AUX_FACT_EREC_DETL" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-00600: internal error code, arguments: [kpotcgah-9], [0], [ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
], [], [], [], [], []
ORA-06512: at "SYS.ORACLE_DATAPUMP", line 19
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

一开始怀疑要导的这个表出现了什么问题，用传统的exp去导，没问题，这样推断，表本身不存问题，那很有可能是expdp出现了问题，metalink文档781326.1提到，这是一个没有公布的bug:
Bug 6155249 was closed as not reproducible. The underlying problem seems to be a shortage in Shared Pool, even if no ORA-4031 occurs.

Solution
1) Increasing SGA_TARGET has a good chance to solve the problem.
2) Using noparallel export can avoid the problem.

把parallel参数去了，expdp就没问题了。

[@more@]

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

转载于:http://blog.itpub.net/350519/viewspace-1051385/