Go Back   TechArena Community > Software > Operating Systems
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 25-09-2009
Member
 
Join Date: Jul 2009
Posts: 87
Unable to initialize the audit trail file Linux Error: 28: No space left on device

Sql started giving me errors recently, Whenever i start sql on my ubuntu 9.04 i get this error :
Quote:
ERROR:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space left on device
Can anyone help me what it is regarding? Thanks!
Reply With Quote
  #2  
Old 25-09-2009
Member
 
Join Date: Mar 2009
Posts: 599
Re: Unable to initialize the audit trail file Linux Error: 28: No space left on device

Sql is not able to access the database due to low disk space on your partition. You need to increase the partition size or delete unnecessary data from the root partition, this might help you free up space and this error may vanish. Although this would be a temporary fix only. You need to get a larger capacity hard disk if you want to continue the use of the sql data base which is going to keep on increasing.
Reply With Quote
  #3  
Old 25-09-2009
Member
 
Join Date: Jul 2009
Posts: 87
Re: Unable to initialize the audit trail file Linux Error: 28: No space left on device

And how could increase the partition? I don't want to loose my data. So is there a way to increase the partition size without loose data? Please help guys. Also is it possible to delete some other partition and use that space to increase this partition. Is it possible? If any help, do post.
Reply With Quote
  #4  
Old 25-09-2009
Member
 
Join Date: Jan 2009
Posts: 1,738
Re: Unable to initialize the audit trail file Linux Error: 28: No space left on device

Yeah, its possible, Boot from Ubuntu live CD and go to System Menu > administration > gparted partition editor. Edit the partition as you want to and save changes. Make sure you don't delete the root partition. These changes are not reversible and if you mess the root partition your system will be screwed. So be very careful. All the best!
Reply With Quote
Reply

  TechArena Community > Software > Operating Systems
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Unable to initialize the audit trail file Linux Error: 28: No space left on device"
Thread Thread Starter Forum Replies Last Post
No Strawberries Left in The Pioneer Trail The Vedas Video Games 5 31-08-2011 07:23 AM
Multipath/device mapper error caused read-only root file system in Red hat enterprise Linux ROcHANn Operating Systems 4 27-05-2011 10:25 AM
Dead space 2 error while installation "Source file not found: (file destination)...Verify that file exists Ucchal Video Games 3 28-01-2011 06:26 AM
Find used and left space on Mac Wafeeq Operating Systems 6 27-07-2010 06:27 AM
hdd no space left in 3 months how is possible HyperCity Hardware Peripherals 3 03-10-2008 02:27 PM


All times are GMT +5.5. The time now is 12:22 AM.