skgfofi: size of file exceeds file size limit of the process

[Remote Systems Support]

Getting errors:
ORA-01116: error in opening database file 26
ORA-01110: data file 26: '/ora05/gpo/gpot3/md_misc02_x.dbf'
ORA-27092: skgfofi: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 307201

ORACLE rel: 9.2.0.2.0
HP-UX 11.11
largfiles
ksh
ulimit is 4194303 which I understand to be unlimited.

2516590592 /ora05/gpo/gpot3/mdmisc02_x.dbf


gp03:/opt/gp03/bin$grep max /stand/system
dbc_max_pct 5
maxfiles 120
maxswapchunks 2024
maxuprc 3687
maxusers 400
msgmax 65536
shmmax 1073741824
maxdsiz 1073741842
maxssiz 134217728
maxtsiz 0x8000000
maxtsiz_64bit 0x40000000
ksi_alloc_max 32768
maxdsiz_64bit 2147483648
maxssiz_64bit 1073741824
max_thread_proc 256

Things I found so far all point to ulimit. Is there anything else that could be causing the ORA-27092 error?

Thanks.

[Jeff Schussele]

Hi,

Does the
/ora05/gpo/gpot3
filesystem have largefiles enabled?
run
fsadm /ora05/gpo/gpot3
& if it does *not* return largefiles
Then there's your problem.
Then run
fsadm -o largefiles /ora05/gpo/gpot3
to set the largefiles flag.

HTH,
Jeff

[Remote Systems Support]

largfiles are enabled for the filesystem.

fsadm -F vxfs /ora05/gpo/gpot3
largefiles

Thanks.

[Jeff Schussele]

OK, as the owning user - oracle - I assume, run this command

ulimit -a

You're looking for the following outputs
file(blocks)
data(kbytes)

HTH,
Jeff

[Remote Systems Support]

As the oracle user:
/home/oracle$ulimit -a
ksh: ulimit: bad option(s)
/home/oracle$ulimit
4194303
Thanks.

Switched to posix shell
/home/oracle$sh $ ulimit -a
time(seconds)unlimited
file(blocks)unlimited
data(kbytes)1048576
stack(kbytes)131072
memory(kbytes)unlimited
coredump(blocks)4194303
nofiles(descriptors) 120

Thanks.

[T G Manikandan]

The problem should be with the oraenv script in $ORACLE_HOME/bin,/usr/bin

Is this a fresh installation or upgrade

check the attache

[T G Manikandan]

check the below two options

1.I would first suggest to update this patch and then try starting Oracle.

This patch is for ksh which does not report ulimit as unlimited.
This might prevent Oracle startup.

http://www1.itrc.hp.com/service/patch/patchDetail.do?patchid=PHCO_27019&context=hpux:800:11:11

2.Try changing the shell

$/usr/bin/sh
Then do a startup of the database from here

3.Also,revert with the values of ulimit -aH from the posix-sh.
$ulimit -aH

This would give the hard limit values

Revert