Oracle - 'HP-UX error 27: file too large'

[Timothy Czarnik]

Hey all,

We got this output on our Oracle server that we were looking to put into production tomorrow, and I'm wondering if anyone out there could help me determine where this is coming from:

Mon Jun 10 07:38:09 2002
KCF: write/open error block=0x5215a online=1
file=13 /u02/oradata/prd1/WIT_CARE_DATA06_01.DBF
error=27072 txt: 'HP-UX Error: 27: File too large
Additional information: 336218'
Automatic datafile offline due to write error on
file 13: /u02/oradata/prd1/WIT_CARE_DATA06_01.DBF
KCF: write/open error block=0x792a9 online=1
file=12 /u02/oradata/prd1/WIT_CARE_DATA05_01.DBF
error=27072 txt: 'HP-UX Error: 27: File too large
Additional information: 496297'
Automatic datafile offline due to write error on
file 12: /u02/oradata/prd1/WIT_CARE_DATA05_01.DBF
KCF: write/open error block=0x54721 online=1
file=10 /u02/oradata/prd1/WIT_CARE_DATA03_01.DBF
error=27072 txt: 'HP-UX Error: 27: File too large
Additional information: 345889'
Automatic datafile offline due to write error on
file 10: /u02/oradata/prd1/WIT_CARE_DATA03_01.DBF
KCF: write/open error block=0x738c7 online=1
file=9 /u02/oradata/prd1/WIT_CARE_DATA02_01.DBF
error=27072 txt: 'HP-UX Error: 27: File too large
Additional information: 473287'
Automatic datafile offline due to write error on
file 9: /u02/oradata/prd1/WIT_CARE_DATA02_01.DBF

Any help will be appreciated greatly!

Tim

[Tom Geudens]

Hi,
Does your filesystem allow for largefiles (> 2Gb)? You can check this with
#fstyp -v
If f_flag is not 0, your filesystem supports largefiles. If not ... that's probably what the problem is. Activate largefiles on your filesystem.

Regards,
Tom

[harry d brown jr]

Tim,

What OS level are you running?

And like Tom mentioned, check to make sure you have largefiles turned on.

live free or die
harry

[Timothy Czarnik]

Tom,

I have verified that the filesystem supports largefiles:

/var/adm/cron # fsadm /u02
fsadm: /etc/default/fs is used for determining the file system type
largefiles

Thanks though!

TIm

[Timothy Czarnik]

Harry,

Sorry, I should have mentioned this.


We are running Oracle 8i on HP-UX 11i. We experienced this issue a week or 2 ago, and after that I went through the patches with a fine toothed comb, so I don't believe its going to be patch related (as Oracle and HP have both looked at our installed patches and have agreed that they looked ok).

I found a response in the forums when doing a lookup of 'error 27' that seems interesting. It brings up the idea that the /var/adm/cron/.proto file may be playing a part in this because Oracle is stopped and started via OmniBack. I don't know what this .proto file does, and am looking into this now. Anyone have any info on this?

As always, thanks a ton for your help!

Tim

[Tom Geudens]

Hi,
Well, if the problem is Omniback related I'll have to pass ... but just on the off-change that you did overlook this (probably not :-). Do the tablespaces auto-extend ? And is there room in the filesystems left ?

Like I said, probably not something you overlooked, but I thought I'd mention it.

Regards,
Tom

[Timothy Czarnik]

Tom,

The table spaces do not auto extend, and there is plenty of room in the filesystems.

Tim

[Kawah Cheung]

Hi,

Have you checked the ulimit? See attached file.

Regards,
Kawah

[Jeff Schussele]

Hi Timothy,

Kawah may be on to the problem here. Definitely check the ulimit for the user in question & remember that ulimit is in 512-byte blocks...so a 4Mb ulimit is only 2Gb size. May want to set an 8Mb ulimit size.

Rgds,
Jeff

[Jeff Schussele]

Hi (again) Timothy,

Another thing to consider is Oracle version...if this is 8.0.5 or earlier, they may support >2Gb DB filesizes but do NOT support exports > 2Gb. You have to compress.

Rgds,
Jeff