HP-UX

DB export시에 에러인데 os쪽 같아서요..

 
김시종
비정기 조언자

DB export시에 에러인데 os쪽 같아서요..

.....................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

./export.sh: 2283 Bus error(coredump)





이런에러가 발생하여서 문의를 드립니다..os쪽 에러 같은데요..잘은 모르겠습니다..아시는 분은 답변좀...
2 응답 2
이태곤
중학생

DB export시에 에러인데 os쪽 같아서요..

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.



-----------------------------------------------------------------

What release version of 9i are you running.

there are lot of bug fixed with 9.2.0.1



Please revert



Also revert on your machine configuration as how much memory you have?



What kernel parameter values you have for shared memory(shmmax) dbc_max_pct.



-----------------------------------------------------------------

bug라는데.....



혹시 다음도 점검해 보시기를.....

export하고자 하는 Data가 2G가 넘는 경우 해당 파일시스템이 largefile로 등록되어 있는지...

# fsadm /opt

largefiles





그럼....
김시종
비정기 조언자

DB export시에 에러인데 os쪽 같아서요..

이태곤님 정말 감사드립니다.