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.
cancel
Showing results for 
Search instead for 
Did you mean: 

oracle error 27 HP-UX

FOREST Michel
Frequent Advisor

oracle error 27 HP-UX

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.
A rookie in the HP Forum :)
5 REPLIES
Sukant Naik
Trusted Contributor

Re: oracle error 27 HP-UX

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
Who dares he wins
Steve Steel
Honored Contributor

Re: oracle error 27 HP-UX

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
If you want truly to understand something, try to change it. (Kurt Lewin)
FOREST Michel
Frequent Advisor

Re: oracle error 27 HP-UX

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

"
nomultifsets
largefiles
"

Thanks for all the current help.
A rookie in the HP Forum :)
FOREST Michel
Frequent Advisor

Re: oracle error 27 HP-UX

oracle is stop/start by Maestro.

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

the ulimit in sh :

"ulimeted"

and in ksh :
"4194303"

Thanks.
A rookie in the HP Forum :)
Kawah Cheung
Advisor

Re: oracle error 27 HP-UX

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
If in doubt, ask!