- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Problem with Oracle
Operating System - HP-UX
1752579
Members
3071
Online
108788
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Go to solution
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2004 06:52 AM
тАО04-22-2004 06:52 AM
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
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
Solved! Go to Solution.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2004 07:08 AM
тАО04-22-2004 07:08 AM
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.
I am an HPE Employee
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.
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2004 06:00 AM
тАО04-23-2004 06:00 AM
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
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP