topic Re: Error with Oracle UNIX in Operating System - HP-UX

Error with Oracle UNIX

Chartier Jerome — Thu, 20 Mar 2003 16:00:16 GMT

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

Re: Error with Oracle UNIX

Keely Jackson — Thu, 20 Mar 2003 16:07:28 GMT

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

Re: Error with Oracle UNIX

Patrick Wallek — Thu, 20 Mar 2003 16:08:02 GMT

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.

Re: Error with Oracle UNIX

Keely Jackson — Thu, 20 Mar 2003 16:08:07 GMT

sorry typo

should be largefiles not largerfiles

Re: Error with Oracle UNIX

Steven E. Protter — Thu, 20 Mar 2003 18:57:02 GMT

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

Re: Error with Oracle UNIX

Sunil Sharma_1 — Fri, 21 Mar 2003 06:32:18 GMT

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

Re: Error with Oracle UNIX

Sunil Sharma_1 — Fri, 21 Mar 2003 06:34:33 GMT

Re: Error with Oracle UNIX

Sunil Sharma_1 — Fri, 21 Mar 2003 06:43:22 GMT

Re: Error with Oracle UNIX

Francis_12 — Fri, 21 Mar 2003 08:29:08 GMT

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.