Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

segmentation fault with oracle import

segmentation fault with oracle import

We have a problem here with the oracle import utility. As soon as we start an oracle import we get a segmentation fault after 2 or 3 seconds.
Our Versions:
HP-UX 11.11
Oracle 9.2.0.4
Any hints will be appreciated!
5 REPLIES
RAC_1
Honored Contributor

Re: segmentation fault with oracle import

What are your ulimit values?
ulimit -Sa (Soft limits)
ulimit -Ha (Hard limits)

Try increasing those and post.
There is no substitute to HARDWORK

Re: segmentation fault with oracle import

Here are my ulimit- values:
ulimit -Sa

time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 966852
stack(kbytes) 303104
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 2048

ulimit -Ha

time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 966852
stack(kbytes) 303104
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 2048
RAC_1
Honored Contributor

Re: segmentation fault with oracle import

What are you maxdsiz and maxssiz values?
What are your maxdsiz_64bit and maxssiz_64bit values?

Try setting ulimit s "value_of_maxssiz"

Anil
There is no substitute to HARDWORK

Re: segmentation fault with oracle import

here the requested values:

maxdsiz 990056448 maxdsiz_64bit 4294967296 maxssiz 310378496 maxssiz_64bit 310378496
RAC_1
Honored Contributor

Re: segmentation fault with oracle import

did you try as follows

Set ulimit value

ulimit s "valu_of_maxssiz"

If that does not work, get tusc tool and install it on your system.
http://hpux.connect.org.uk/hppd/hpux/Sysadmin/tusc-7.5/
and try tusc -vfp "import_command"

It will give you, where the import is failing.

Anil
There is no substitute to HARDWORK