oracle error 27 HP-UX

[FOREST Michel]

I get an error message this morning referencing this one file. Here is the error from a trace file created by oracle:

"
Fri May 24 05:23:10 2002
KCF: write/open error block=0x40004 online=1
file=2 /busdata/rsme/eur0/_lgi/oracle/vol2/rbs01_01.dbf
error=27072 txt: 'HP-UX Error: 27: File too large
Additional information: 262148'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 1476
"

We are running HPUX and Oracle 8.1.6. Result of ulimit by Oracle user :

"
$ ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 307200
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 2048
"

result of fsadm :

"
nomultifsets
largefiles
"

Any help would be useful.
Thanks in advance.

[Sukant Naik]

Hi,

What is the size of the database file ?

Does the filesystem which you have used to create this db file use the largefiles option? I presume it to be vxfs.

Just my two cents
-Sukant

[Steve Steel]

Hi


If not a largefile problem then

Is the oracle started by a cron script such as
OMNIBACK with the at command

If so it may be

/var/adm/cron/.proto

file should temporarily work around this problem:

Change ulimit line From:

# @(#) $Revision: 27.1 $
cd $d
ulimit $l <--------- as indicated
umask $m
$<

To:
ulimit unlimited


Remeber what you changed and put it back if needed.

steve steel

[FOREST Michel]

the file is 2181046272 and large files is enable.
$ fsdam -v vxfs /dev/... :

"
nomultifsets
largefiles
"

Thanks for all the current help.

[FOREST Michel]

oracle is stop/start by Maestro.

the .jobmanrc for root :
"#!/usr/bin/ksh "

the ulimit in sh :

"ulimeted"

and in ksh :
"4194303"

Thanks.

[Kawah Cheung]

Hi,

Check out oracle Note:1067314.6 if you can. Something very, very similar to what you are getting. I have pasted the solution below.

Solution Description:
=====================
You need to ensure that the ulimit is set to "unlimited for filesize".

Check the ulimit all users that start oracle. If there are scripts used for automatic startup and shutdown , check the scripts for limit commands that may set the ulimit.

To check the ulimit :

(in c-shel)
[tchp1]/u02/home/usupport> limit
cputime unlimited
filesize unlimited
datasize 262144 kbytes
stacksize 32768 kbytes
coredumpsize 2097151 kbytes
descriptors 2048 files
memoryuse unlimited

ksh - will not show the detail
$ ulimit
4194303
from this you can not see what the filesize is set to.

Explanation:
============

The error occurs because the database is started with a ulimit less than the
datafile size. The limit filesize is greater than the size of the system
datafiles, however the size other datafiles in the database exceeds the ulimit.
When the data beyond the ulimit threshold is accessed in the datafiles, the
error occurs.


Hope this helps.

Kind Regards,
Kawah