Problem with Oracle

[Carlos Vanegas]

Hi, I'm running in a partition of superdome with 8GB of memory, hpux 11.11, and Oracle 8.1.7.4.0 64bits Enterprise Edition. when I made a export file and it's 3GB size, received the next error:
continuing export into file /ora1/temporary_dmps/ismlglog2.dmp
kgefec:fatal error 0
*** Internal heap ERROR 17113 addr=0x0

********
HEAP DUMP heap name="" desc=0x0
extent sz=0x0 alt=0 het=0 rec=0 flg=0 opc=0
parent=0 owner=0 nex=0 xsz=0x0
Hla: 0
**** Recursive heap error: 17113 addr=0x0, ds=0

[Duncan Edmonstone · Accepted solution]

From metalink:

Symptom(s)
~~~~~~~~~~

Export Fails with

kgefec: fatal error 0
********** Internal heap ERROR 17113 addr=0x0 *********
******************************************************
HEAP DUMP heap name="" desc=0x0
extent sz=0x0 alt=0 het=0 rec=0 flg=0 opc=0
parent=0 owner=0 nex=0 xsz=0x0
Hla: 0
**** Recursive heap error: 17113 addr=0x0, ds=0
Bus error

Symptoms
~~~~~~~~
No log is generated or may be of size zero bytes.


Change(s)
~~~~~~~~~~

The only difference between this export and previous exports is size.

Cause
~~~~~~~

The operating system was not able to keep up with the Oracle Process.

Fix
~~~~

Check system logs for errors. There may be an issue with physical memory.
Try decreasing the buffer size in the export to prevent Oracle from sending
so much data at once.

In some environments, increasing the buffer will allow Oracle to hold more
data in the buffer before sending it to the OS allowing the OS to catch up.

Try running the export with DIRECT = TRUE. This will bypass the heap and heap
and all possibility of this issue.

If you are running the export from a client and the database is not the same
wordsize, ie one is 32bit and the other is 64bit, you could be experiencing
bug#2298968. This bug is not available externally for customer view.

One-off patches are available for 8.1.7.4 and 9.0.1.3 in Metalink. The bug
fix is in 9.2.0.1.

[Rory R Hammond]

FYI

IF you have a 2 gig limit on file size and a 3 gig export file you can do a export to multple files with the folloing command:

exp username/password@SID buffer=1000000 file=/dbexp/SID_0.dmp,/dbex/$SID_1.dmp filesize=1950M full=y log=SID.log