Error with Oracle UNIX

[Chartier Jerome]

Hello,

I've got a problem when I launch some processes on a HP 9000 server with oracle 8.1.7.
See log below:
.
Alloc server h
ORA-01114: IO error writing block to file 8 (block # 317021)
ORA-27072: skgfdisp: I/O error
HP-UX Error: 27: File too large
Additional information: 317021
ORA-01114: IO error writing block to file 8 (block # 317021)
ORA-27072: skgfdisp: I/O error
HP-UX Error: 27: File too large
Additional information: 317021

Could you help
Thanks in advance
Regards

Jerome

[Keely Jackson]

Hi

Are you trying to write a file larger than 2Gb. If so you need largerfiles set on the file system.

The fsadm command will tell you.

Cheers
Keely

[Patrick Wallek]

Is Oracle trying to create a file that is larger than 2GB on a filesystem that doesn't support largefiles?

Is one of your Oracle datafiles full?

Check the filesystem you are getting this error on with 'fsadm /file_system_mount_point'. If it returns 'nolargefiles' then this may be your problem. You can enable largefiles by doing an 'fsadm -o largefiles /file_system_mount_point' if you hae OnlineJFS installed.

[Keely Jackson]

sorry typo

should be largefiles not largerfiles

[Steven E. Protter]

Your database is sitting on a filesystem not set for largefiles.

It's trying to cut an extent.

Back it up, lay down the fs with the following command.

Make sure the logical volume is at least 50% bigger than the current size of the databases.

lvextend ...

newfs -F vxfs -o largefiles /dev/vg##/rlvol###

Fill in real info for the ## signs.

Restore the database, and recovery it.

SEP

[Sunil Sharma_1]

Hi,

as error messages is indicating 2 possiblities.
1.File system is created without largefile option. or
2. File system may be full

in case of File system created without largefile option you have to take backup first and recreate file system with largefiles option.

in second case you have to just increase the size of File system with LVM commands.

Sunil

[Sunil Sharma_1]

Hi,

as error messages is indicating 2 possiblities.
1.File system is created without largefile option. or
2. File system may be full

in case of File system created without largefile option you have to take backup first and recreate file system with largefiles option.

in second case you have to just increase the size of File system with LVM commands.

Sunil

[Sunil Sharma_1]

Hi,

as error messages is indicating 2 possiblities.
1.File system is created without largefile option. or
2. File system may be full

in case of File system created without largefile option you have to take backup first and recreate file system with largefiles option.

in second case you have to just increase the size of File system with LVM commands.

Sunil

[Francis_12]

Hello,

Such error is a typical file >2Go error :

# grep 27 errno.h
#define EFBIG 27 /* File too large */

*IF* you have OnlineJFS installed, you just need to do :

# fsadm -F vxfs -o largefiles /mount_point

From the fsadm_vxfs man page :

largefiles
Set the largefiles flag for the file system.
When this flag is set, large files (greater than
two gigabytes) can be created on the file
system.

Bye.
F.