Is my filesize related to Oracle exp failure

[Steven Chen_1]

Hi,

I would appreciate it if someone look at my /stand/system file (on hpux10.20) to find anything related to my exp oracle failure (I only exp to about 500M, then stop)?

---------------
STRMSGSZ 65535
dbc_max_pct 15
maxdsiz 1073741824
maxfiles 512
maxswapchunks 4096
maxtsiz 1073741824
maxuprc (NPROC-4)
maxusers 450
ndilbuffers 512
nfile (16*(NPROC+16+MAXUSERS)/10+32+2*NPTY)
npty 100
nstrpty 60
num_clients 10
semmni 1364
semmns 2048
semmnu 683
semume 292
shmmax 1073741824
shmmni 1024
shmseg 200
-----------------------

Thank you very much,

Steven

[Victor BERRIDGE]

Hi Steven,
Whats the value of nproc?

I would suggest you have maxfiles at 2048, but it more nproc Im interessetd since you gave params with formulas..
But I wonder if you are not having problems elsewhere, what is the expected size of the export? how much free space do you have? what else is running on the machine at the same time... what type of machine with how much RAM /swap...

Best regards
Victor

[Steven Chen_1]

Thanks for the help. The nproc=3620.

While I use cron to export on weekend early morning, the processes running should not be more than 50.

I am trying to find if there is file size limitation?

Any thought is greatly appreciated.

[James A. Donovan]

Here's a thought; does the export stop at the same point each time? If it does, try using the $ORACLE_HOME/bin/dbv utility on each datafile that contains the object being exported when the failure occurs. You may have a corrupted datafile.

[Joseph C. Denman]

I have had exports of well over a gb. 500mb should cause no problems. As stated earlier, you may have a corrupt datafile. I would shut down the instance and bring it back up and see if there are any problems. If not, try again.

...jcd...

[Victor BERRIDGE]

Hi again,
nproc=3620?

So I see nothing wrong with your kernel params..
I agree with Jim and Joseph, looks like a corrupted datafile or filesystem, for the file system its easy to check, write a little script that will fill up the file system or try to create a file somewhere else that exeeds 500 MB and copy it where the export should go, run fsck...
For the datatfile look at oracle logs, you should find in it the reason why it aborts...

Good luck