EXPDP Export user Error ora-07445:exception encountered:

Source: Internet
Author: User

Database version 11.2.0.3.0 errors caused by Oracle bugs

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]

Error when exporting user environment:

Alter LOG:
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 t o 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 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 file
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 OB Ject] []

Ssexhd:crashing the process ...
Shadow_core_dump = PARTIAL
ksdbgcra:writing core file to directory '/u01/app/oracle/diag/rdbms/telecom/telecom/cdump '

The problem statement is in:

EXPDP username/password directory=ora_directory dumpfile=filename.dmp logfile=filename.log parfile=ORA_PATH_ Dumpfiles/expdp_profile.par

This problem is a bug for Oracle, so you need to add a parameter in the EXPDP statement: Exclude=statistics

EXPDP username/password directory=ora_directory exclude=statistics dumpfile=filename.dmp logfile= FILENAME.log Parfile=ora_path_dumpfiles/expdp_profile.par

It's not a problem to go back to execution.

EXPDP Export user Error ora-07445:exception encountered:

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.