My Oracle Support Banner

Expdp Segmentation Fault (Core Dumped) for more than 14 Schemas (Doc ID 1389763.1)

Last updated on AUGUST 01, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Expdp fails with Segmentation Fault (core dump), if trying to export more than 14 Schemas like below:

expdp userid=system directory=data_pump_dir dumpfile=<dump_name>.dmp logfile=<log_name>.log schemas=<schema1>,<schema2>,<schema3>,<schema4>,<schema5>,<schema6>,<schema7>,<schema8>,<schema9>,<schema10>,<schema11>,<schema12>,<schema13>,<schema14>,...

Export: Release - Production on Mon Nov 14 20:42:44 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Segmentation Fault (core dumped)

If the last three schema names are removed, the export works fine.

Extracting the stack trace from the core dump with adb, we get:

flounder-ng2{oracle}: /bin/adb $ORACLE_HOME/bin/expdp core
core file = core -- program ``<$ORACLE_HOME>/bin/expdp'' on platform i86pc
SIGSEGV: Segmentation Fault
$c`_lwp_kill+0xa()`raise+0x19()`skgesigOSCrash+0x1dd()`kpeDbgSignalHandler+0x7a()`skgesig_sigactionHandler+0x3c2()`__sighndlr+6()`call_user_handler+0x252()`sigacthandler+0xee(b, fffffd7fffdf7a10, fffffd7fffdf76b0)`lxCmpStr+0x18f()`lxoCmpStr+0x15f()`lxsCmpStr+0x7c()

The relevant functions of the call stack seem to be:

... lxCmpStr lxoCmpStr lxsCmpStr ...

Most of the call stack above that is Oracle generic code for catching the segmentation fault signal and trying to handle that cleanly, i.e.:

_lwp_kill skgesigOSCrash kpeDbgSignalHandler skgesig_sigactionHandler sighndlr

Settings for swap and ulimit were checked, but nothing relevant was found.

The alert.log shows no entry referring to the issue.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.