cancel
Showing results for 
Search instead for 
Did you mean: 

Error with Oracle UNIX

Chartier Jerome
Frequent Advisor

Error with Oracle UNIX

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
J@Y
8 REPLIES
Keely Jackson
Trusted Contributor

Re: Error with Oracle UNIX

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
Live long and prosper
Patrick Wallek
Honored Contributor

Re: Error with Oracle UNIX

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

Re: Error with Oracle UNIX

sorry typo

should be largefiles not largerfiles
Live long and prosper
Steven E. Protter
Exalted Contributor

Re: Error with Oracle UNIX

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

Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Sunil Sharma_1
Honored Contributor

Re: Error with Oracle UNIX

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
*** Dream as if you'll live forever. Live as if you'll die today ***
Sunil Sharma_1
Honored Contributor

Re: Error with Oracle UNIX

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
*** Dream as if you'll live forever. Live as if you'll die today ***
Sunil Sharma_1
Honored Contributor

Re: Error with Oracle UNIX

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
*** Dream as if you'll live forever. Live as if you'll die today ***
Francis_12
Trusted Contributor

Re: Error with Oracle UNIX

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.