Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with Oracle

SOLVED
Go to solution
Carlos Vanegas
Occasional Advisor

Problem with Oracle

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
2 REPLIES
Duncan Edmonstone
Honored Contributor
Solution

Re: Problem with Oracle

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.

HTH

Duncan
Rory R Hammond
Trusted Contributor

Re: Problem with Oracle


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
There are a 100 ways to do things and 97 of them are right