ORA-07360/ HP-UX Error: 72: Value too large to be stored in data type

[Denys van Kempen]

When renaming datafiles in the control file Oracle exits with on the only file that is larger then 2 Gb. with the errors
ORA-07360: sfifi: stat error, unable to obtain information about file.
HP-UX Error: 72: Value too large to be stored in data type

The file system support large files (checked with SAM).

Maybe a shell limit ?

Data is limited to 2 Gb

# ulimit -aS
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 2015464
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 512

# ulimit -d 3145728
sh: ulimit: The specified value exceeds the user's allowable limit.

# /etc/sysdef|grep maxdsiz
maxdsiz 503866 - 0-655360 Pages -
maxdsiz_64bit 1048576 - 256-1048576 Pages -

maxdsiz = 503866 4K pages = 2 GB.

Does data segment limits matter here ?
Any idea on the origin of the error ?

Thank you.

Denys van Kempen

[Steve Steel · Accepted solution]

Hi

OS and Oracle version please

This is known


Oracle 7.3.4.1 has a problem that prevents
it from working with >2GB files on 11.00. I
I believe that 7.3.4.5 fixes this problem .

Steve Steel

[Massimo Bianchi]

Hi,
looks like a know shell limitation. If using ksh, you have to switch to sh or csh.
ksh is hard limited to 2G.

If already using csh or sh, then set
"ulimit unlimited".

Massimo

[T G Manikandan]

This is a known problem with 7.3.4.1
UPgrading to 7.3.4.5 should solve it

Thanks

[Denys van Kempen]

Thank you very much. Problem solved. It concerned Oracle7 r 7.3.4.1 for HP-UX 11.00 indeed.