cancel
Showing results for 
Search instead for 
Did you mean: 

help need regarding disk space

Rajkumar_3
Regular Advisor

help need regarding disk space

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
Oracle DBA
9 REPLIES
Justo Exposito
Esteemed Contributor

Re: help need regarding disk space

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.
Help is a Beatiful word
Michael Tully
Honored Contributor

Re: help need regarding disk space

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
Anyone for a Mutiny ?
Steven Sim Kok Leong
Honored Contributor

Re: help need regarding disk space

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
Email: steven@beepz.com. Homepage: https://www.beepz.com
Printaporn_1
Esteemed Contributor

Re: help need regarding disk space

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.


enjoy any little thing in my life
Ravi_8
Honored Contributor

Re: help need regarding disk space

Hi,

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

just a thought.
never give up
Rajkumar_3
Regular Advisor

Re: help need regarding disk space

THank you all for the shift responses.

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

Thank you very much.

Raj
Oracle DBA
Dennis J Robinson
Frequent Advisor

Re: help need regarding disk space

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.

You know the drill
Rita C Workman
Honored Contributor

Re: help need regarding disk space

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
Jon_7
Occasional Advisor

Re: help need regarding disk space

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.
They don't have a certifications for being a creator, and just having the bigest IT magic wand, ccie is close, but not till they drop token ring and add, PoS, I designed asics/systems/code, implementation and training, from hw/ to sw, just do it.