Re: File System question

Hi Jay, you said...
> I have 480 blocks of space left on a File System. On this file system
> is an installation of Oracle DB. I have been running out of space on
> this particular file system. I have removed some log files to free up
> space, but this hasn't helped much at all. I know I can
> unmount/remount this file system to allocate more space, but I think I
> will have to reinstall Oracle DB, which is not the ideal choice. I
> will most likely reduce the size of database files (dbf files) to free
> up additional space. Other than error messages indicating that the
> file system has no free space, what other issues will I encounter if
> significant amount of space is not freed up?
>
> On a side note, I do have significant amount of space on other file
> systems on this Uniware 2.X box.
>

It's pretty tough to run Oracle with only 480 blocks of free space available. Hopefully none of your tablespaces are set for autoextend. I have cron jobs that periodically go in and clean out old stuff from the bdump, cdump, and udump directories.

You should consider moving your database files to another disk, but at the very least outside your ORACLE_BASE hierarchy.

Well, if you're desperate, there are a couple of directories that contain stuff that you don't need to keep online all the time or that you can find elsewhere. I haven't looked thru these directories to verify there's noting in them you need, so I'd back them up (maybe to tape) before you delete them:

$ORACLE_BASE/doc and its subdirectories
$ORACLE_HOME/demo and its subdirectories
$ORACLE_HOME/doc and its subdirectories

You can access the docs from the CD or from OTN.

If you're not using these features, you can get rid of all the Apache, java (maybe), soap, and xdk (xml) stuff in ORACLE_HOME.

-- 
[:%s/Karsten Farrell/Oracle DBA/g]