Sponsored Content
Full Discussion: filesystem is full
Top Forums UNIX for Dummies Questions & Answers filesystem is full Post 302110558 by sb008 on Tuesday 13th of March 2007 06:21:59 PM
Old 03-13-2007
Quote:
Originally Posted by BOFH
Sounds like Oracle is probably still holding on to the files. You'd have to stop and start Oracle (assuming that's what's holding it) which would clear it.

Carl
Correct

If some kind of process has opened a file, it still possible for you to delete the file at the command line.

Visually it will look as if the file has been removed.

However, underneath the file is still there. Only when the process, which opened the file, closes the file, the file will be really removed and the data blocks which made up the file will be free'd.

As BOFH already mentioned the most likely candidate for who has the files opened is one of the Oracle processes.

So you indeed have to shut down Oracle to get the space back which was taken by the file.

Furthermore, I hope for you you don't end up with a totally damaged and corrupt database.

It is not smart to remove files like that. There is a good chance you removed part if not all of the database.
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Filesystem Full

I noticed that whenever something is printed from my workstation, the available disk space in the /dev/dsk/c0t0d0s0 decreases considerably. Hence, after using my workstation for sometime, I encounter an error message: "Filesystem Full" that prevents me from printing any further. Is there a way to... (16 Replies)
Discussion started by: ilak1008
16 Replies

2. UNIX for Dummies Questions & Answers

/tmp filesystem full

I am running AIX 3 4. When I do a df I get: Filesystem 512-blocks Free %Used Iused %Iused Mounted on /dev/hd4 32768 10232 69% 1309 16% / /dev/hd2 917504 86360 91% 19744 18% /usr /dev/hd9var 131072 67712 49% 617 ... (11 Replies)
Discussion started by: szodiac
11 Replies

3. HP-UX

vxfs filesystem full!

Dear all, What should I do with the following error message: vxfs: mesg 001: vx_nospace - /dev/root file system full (1 block extent) Thanks for your advises, (1 Reply)
Discussion started by: hungevntelecom
1 Replies

4. Solaris

The filesystem is still full - Solaris 10!

Good morning, sir! I've a problem with FileSystem, the problem is FileSystem is full First time, I've already read carefully the sticky thread FileSystem full - What to lock for https://www.unix.com/sun-solaris/25840-filesystem-full-what-look.html And then, I will post some information of... (4 Replies)
Discussion started by: trantuananh24hg
4 Replies

5. UNIX for Dummies Questions & Answers

filesystem full

my root filesystem is eventually full "/dev/rdsk/c1d0s0" as a result i cannot boot to the operating system, i booted into the fail safe mode to check the space using df -h command i discover that it is eventually full. Also to my amazement i found that i cannot see the filesystem which mounted on... (1 Reply)
Discussion started by: seyiisq
1 Replies

6. Red Hat

/ filesystem getting full

Hi All, How do I increase the root filesystem? It's getting full. / 90% Here's the break down, below 232 dev 5624 tmp *6764 bin 16860 root *19680 sbin *20436 lib64 28329 boot *47992 etc 150012 var *254540 lib 651708 home *2445044 usr (5 Replies)
Discussion started by: itik
5 Replies

7. AIX

What is the cause of USR filesystem full

we are using aix 5.3 and we notice that the filesystem /usr is almost full. we have an oracle database running on the server.what are the cause why this filesystem is almost full.what should we do to free some space on this filesystem beside increase the size?thanks (4 Replies)
Discussion started by: paulexis
4 Replies

8. Solaris

Filesystem Full

In our shop we have to run a batch cycle. Every so often while we are running batch we get a filesystem full situation that causes batch to stop or slow down. Anyway, the practiced procedure is to look for large files and zip them. This takes a lot of time. We are in a sun solaris environment. What... (1 Reply)
Discussion started by: Harleyrci
1 Replies

9. AIX

Livedump filesystem almost full

Guy's I'm getting this message Livedump filesystem almost full in errpt logs and its meanning this file system /var/adm/ras/livedump /var has more than 1.5 GB free space .. why I'm getting that message and .. Pls advice to to avoide it ---------- Post updated 03-21-11 at 01:39 AM... (1 Reply)
Discussion started by: Mr.AIX
1 Replies
SQL::ReservedWords::Oracle(3pm) 			User Contributed Perl Documentation			   SQL::ReservedWords::Oracle(3pm)

NAME
SQL::ReservedWords::Oracle - Reserved SQL words by Oracle SYNOPSIS
if ( SQL::ReservedWords::Oracle->is_reserved( $word ) ) { print "$word is a reserved Oracle word!"; } DESCRIPTION
Determine if words are reserved by Oracle Database. METHODS
is_reserved( $word ) Returns a boolean indicating if $word is reserved by either Oracle7, Oracle8i, Oracle9i or Oracle10g. is_reserved_by_oracle7( $word ) Returns a boolean indicating if $word is reserved by Oracle7. is_reserved_by_oracle8( $word ) Returns a boolean indicating if $word is reserved by Oracle8i. is_reserved_by_oracle9( $word ) Returns a boolean indicating if $word is reserved by Oracle9i. is_reserved_by_oracle10( $word ) Returns a boolean indicating if $word is reserved by Oracle10g. reserved_by( $word ) Returns a list with Oracle versions that reserves $word. words Returns a list with all reserved words. EXPORTS
Nothing by default. Following subroutines can be exported: is_reserved is_reserved_by_oracle7 is_reserved_by_oracle8 is_reserved_by_oracle9 is_reserved_by_oracle10 reserved_by words SEE ALSO
SQL::ReservedWords <http://www.oracle.com/technology/documentation/> AUTHOR
Christian Hansen "chansen@cpan.org" COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.8.8 2008-03-28 SQL::ReservedWords::Oracle(3pm)
All times are GMT -4. The time now is 01:43 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy