Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have about 429GB Diskspace allocated to this VM.

I see that only 179GB is being used.

Now when I try to add a 128GB file I get an I/O error saying I do not have any space left.

I need to be able to use all of the space. I do not see any disk quota issue.

Here are some statistics. I know its probably something rudimentary; however, I am unable to find the right google search either.

Could somebody help me?

[root@Accelerant-EBS /]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_accelerantebs-lv_root
                       50G   45G  2.6G  95% /
tmpfs                 2.8G  420K  2.8G   1% /dev/shm
/dev/sda1             485M  108M  352M  24% /boot
/dev/mapper/vg_accelerantebs-lv_home
                      339G  127G  195G  40% /home
[root@Accelerant-EBS /]# fdisk -l

Disk /dev/sda: 429.5 GB, 429496729600 bytes
255 heads, 63 sectors/track, 52216 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000d6093

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          64      512000   83  Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2              64       52217   418917376   8e  Linux LVM

Disk /dev/mapper/vg_accelerantebs-lv_root: 53.7 GB, 53687091200 bytes
255 heads, 63 sectors/track, 6527 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000


Disk /dev/mapper/vg_accelerantebs-lv_swap: 6123 MB, 6123683840 bytes
255 heads, 63 sectors/track, 744 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000


Disk /dev/mapper/vg_accelerantebs-lv_home: 369.2 GB, 369157472256 bytes
255 heads, 63 sectors/track, 44880 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000

[root@Accelerant-EBS /]# cat /etc/fstab

#
# /etc/fstab
# Created by anaconda on Wed Aug 28 15:00:33 2013
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/vg_accelerantebs-lv_root /                       ext4    defaults        1 1
UUID=f5bb9829-567a-4d7f-8f7b-9dbb3297636e /boot                   ext4    defaults        1 2
/dev/mapper/vg_accelerantebs-lv_home /home                   ext4    defaults        1 2
/dev/mapper/vg_accelerantebs-lv_swap swap                    swap    defaults        0 0
tmpfs                   /dev/shm                tmpfs   defaults        0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
share|improve this question

migrated from stackoverflow.com Oct 4 '13 at 14:09

This question came from our site for professional and enthusiast programmers.

    
Where are you trying to create the file? Only /home has enough space? It might be helpful to show the exact command you're issuing and the error you get. (The Oracle tag is for database questions, not for other Oralce products; this is the wrong site for this question anyway). –  Alex Poole Oct 3 '13 at 21:51
    
It is an Oracle Tablespace Command which creates a file on the Linux File System. Also sorry for posting it in the wrong site –  vlukereddy Oct 3 '13 at 22:01
    
create bigfile tablespace OLAP12_TS datafile '/oradata/orcl/pdborcl/OLAP12_TS.dbf' size 128G extent management local uniform size 512k segment space management auto; –  vlukereddy Oct 3 '13 at 22:02
    
SQL Error: ORA-19502: write error on file "/oradata/orcl/pdborcl/OLAP12_TS.dbf", block number 135936 (block size=8192) ORA-27072: File I/O error –  vlukereddy Oct 3 '13 at 22:03
1  
OK, you don't have a /oradata partition, so it's trying to put it under /, which only has 2.6G free. You can check which partition you're working with and it's size with df -h /oradata/orcl/pdborcl. You could create the file somewhere under /home, or increase the size of /, or add a new partition. –  Alex Poole Oct 3 '13 at 22:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.