Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Remote Systems Support
Occasional Advisor

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

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.
testing is for wimps.....
6 REPLIES
Jeff Schussele
Honored Contributor

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

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
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
Remote Systems Support
Occasional Advisor

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

largfiles are enabled for the filesystem.

fsadm -F vxfs /ora05/gpo/gpot3
largefiles

Thanks.
testing is for wimps.....
Jeff Schussele
Honored Contributor

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

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


PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
Remote Systems Support
Occasional Advisor

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

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.
testing is for wimps.....
T G Manikandan
Honored Contributor

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

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
Honored Contributor

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

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