topic Re: help need regarding disk space in Operating System - HP-UX

help need regarding disk space

Rajkumar_3 — Wed, 23 Jan 2002 08:19:42 GMT

Hai All ,

I got the error while creating the tablespaces.

Error details:
#########
CREATE TABLESPACE usersdata
*
ORA-01119: error in creating database file '/testing/PROD/users_data.dbf'
ORA-27044: unable to write the header block of file
HP-UX Error: 27: File too large
Additional information: 2
#######################
But for /testing directory the size was assigned 50 GB and it was in the seperate slice.
I think that the error causes insufficient diskspace.when i observer only 4 GB was occupied by /testing directory.

IS there any thing quota that we have to assigned to that /testing/PROD directory.At this situation how can i avoid that insufficient disk space.Is that is not the case what might be the error ??.

Ra

Re: help need regarding disk space

Justo Exposito — Wed, 23 Jan 2002 08:34:23 GMT

Hi Rajkumar,

The database file that you want to create is more than 2GB?

If this, then probably you don't declare the lvol with the largefiles option.

You can look for in the /etc/lvmtab.

Regards,

Justo.

Re: help need regarding disk space

Michael Tully — Wed, 23 Jan 2002 08:37:13 GMT

Hi,

Has the filesystem been created with the -o largefiles option? If not you will not be able to create a file that is greater than 2Gb.

HTH
-Michael

Re: help need regarding disk space

Steven Sim Kok Leong — Wed, 23 Jan 2002 08:39:00 GMT

Hi,

Check that the filesystem that your file resides in supports large files (> 2 GB). To verify, do this:

# fsadm -F hfs /dev/vgXX/lvolYY

(replace hfs with vxfs if your filesystem is a journal filesystem)

where this is the logical volume containing the file system your file resides.

To enable large files in your current runtime environment, do this,

# fsadm -F hfs -o largefiles /dev/vgXX/lvolYY

(replace hfs with vxfs if your filesystem is a journal filesystem)

To enable large files during system reboot, modify your /etc/fstab and add largefiles as an option:

rw,suid,largefiles,delaylog,nodatainlog

Hope this helps. Regards.

Steven Sim Kok Leong

Re: help need regarding disk space

Printaporn_1 — Wed, 23 Jan 2002 08:41:54 GMT

Hi,

use fsadm to check whether it was create with largefile option or not

#fsadm /dev/vgXX/rlvolXX

if not then you have to
1. re-create using newfs with -o largefiles
or
2. convert using fsadm.

Re: help need regarding disk space

Ravi_8 — Wed, 23 Jan 2002 08:43:38 GMT

Hi,

create tablespace userdata datafile '/testing/PROD/user_data.dbf' size
xmb;

just a thought.

Re: help need regarding disk space

Rajkumar_3 — Wed, 23 Jan 2002 09:32:23 GMT

THank you all for the shift responses.

I am trying to recreate the file system with -o option.

Thank you very much.

Raj

Re: help need regarding disk space

Dennis J Robinson — Wed, 23 Jan 2002 13:07:35 GMT

While all the comments are correct ( need to recreate filesystem with largefiles option, need to mount it with largefiles option )

One must consider other products they are going to run against the datafiles being created.

For example some versions of gzip don't like large files, some backup products don't.

Most of us simply create datafiles right under the 2GB mark, and use multiple datafiles for a large tablespace.

Ideally heavy activity tablespace would be partitioned, and each partition could fit within a datafile. You could take a portion of the tablespace offline without blocking access to the rest of it.

Re: help need regarding disk space

Rita C Workman — Wed, 23 Jan 2002 13:19:18 GMT

Rajkumar,

Just as one very obvious thought...in addition to the recommendations for -o largefiles option.

ORA-01119 is telling you there isn't enough disk space to extend as far as you want.

It is also possible you need to check on how much disk space you have and see if the there is enough physical space to accomodate how far you want to 'extend' the tablespace, first.

Just a thought,
Rita

Re: help need regarding disk space

Jon_7 — Fri, 25 Jan 2002 21:18:40 GMT

I hate to repeat some of what has already been stated, but file size to large message was from OS, here being HP/UX all the large file options should be checked as above respondants said, and, disk space shoud not be a problem UNLESS you are creating too many files, if you are not, then it is an OS file size issue not disk space, and of course Oracle will not be able to do what the OS will not allow it too, be it too large a file for current settings in OS or, too many files that add up to too large for partition. Good luck. Switches commands and everything else is all above.