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/