首页 > 代码库 > expdp 导出用户报错ORA-07445: exception encountered:

expdp 导出用户报错ORA-07445: exception encountered:

 

数据库版本 11.2.0.3.0 oracle的bug导致的错误

 

expdp ORA-07445: exception encountered: core dump [kokemisz()+34] [SIGSEGV] [ADDR:0x18] [PC:0x143F5C6] [Address not mapped to object] []

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x18] [PC:0x143F5C6, kokemisz()+34] [flags: 0x0, count: 1]

 

在导出用户环境时候报错:

alter日志:
Tue Jan 13 16:24:41 2015
DM00 started with pid=52, OS id=20074, job LTEPOC_V1.SYS_EXPORT_SCHEMA_13
Tue Jan 13 16:24:42 2015
DW00 started with pid=55, OS id=20076, wid=1, job LTEPOC_V1.SYS_EXPORT_SCHEMA_13
Tue Jan 13 16:25:46 2015
Thread 1 advanced to log sequence 4259 (LGWR switch)
Current log# 2 seq# 4259 mem# 0: +DGDATA01/telecom/onlinelog/group_2.258.866548865
Tue Jan 13 16:25:48 2015
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x18] [PC:0x143F5C6, kokemisz()+34] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/telecom/telecom/trace/telecom_dw00_20076.trc (incident=13241):
ORA-07445: exception encountered: core dump [kokemisz()+34] [SIGSEGV] [ADDR:0x18] [PC:0x143F5C6] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/telecom/telecom/incident/incdir_13241/telecom_dw00_20076_i13241.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Jan 13 16:25:51 2015
Sweep [inc][13241]: completed
Sweep [inc2][13241]: completed
Tue Jan 13 16:25:51 2015
Dumping diagnostic data in directory=[cdmp_20150113162551], requested by (instance=1, osid=20076 (DW00)), summary=[incident=13241].

trc 文件
*** 2015-01-13 16:25:48.924
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x18] [PC:0x143F5C6, kokemisz()+34] [flags: 0x0, count: 1]
Incident 13241 created, dump file: /u01/app/oracle/diag/rdbms/telecom/telecom/incident/incdir_13241/telecom_dw00_20076_i13241.trc
ORA-07445: exception encountered: core dump [kokemisz()+34] [SIGSEGV] [ADDR:0x18] [PC:0x143F5C6] [Address not mapped to object] []

ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL
ksdbgcra: writing core file to directory ‘/u01/app/oracle/diag/rdbms/telecom/telecom/cdump‘

问题语句在:

expdp USERNAME/PASSWORD directory=ORA_DIRECTORY dumpfile=FILENAME.dmp logfile=FILENAME.log parfile=ORA_PATH_DUMPFILES/expdp_profile.par

 

该问题是oracle的一个bug,所以在expdp语句中需要添加一个参数:EXCLUDE=STATISTICS

 

expdp USERNAME/PASSWORD directory=ORA_DIRECTORY EXCLUDE=STATISTICS dumpfile=FILENAME.dmp logfile=FILENAME.log parfile=ORA_PATH_DUMPFILES/expdp_profile.par

再次去执行就没得问题了

expdp 导出用户报错ORA-07445: exception encountered: