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

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

SOLVED
Go to solution

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

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
4 REPLIES
Steve Steel
Honored Contributor
Solution

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

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
If you want truly to understand something, try to change it. (Kurt Lewin)
Massimo Bianchi
Honored Contributor

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

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

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

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

Thanks

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

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