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