Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle File System is full. How to come out of it?

Srinivas Dutt
Occasional Contributor

Oracle File System is full. How to come out of it?

We have our Application runing on HP-UX with Oracle9i. The space alloted for Oracle File system is 15GB. When our application was running, it was observed that the File System %usage increased by 1% every day and now reached 100% now. Due to some reasons, we had to reboot the server and now we are unable to start 'dbstart' and 'sqlplus'.
With dbstart the following message is observed:

SQL*Plus: Release 9.2.0.2.0 - Production on Wed Jun 27 13:44:14 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> ERROR: ORA-09817: Write to audit file failed.
HPUX-ia64 Error: 28: No space left on device
ORA-09945: Unable to initialize the audit trail file
HPUX-ia64 Error: 28: No space left on device

SQL> ORA-09945: Unable to initialize the audit trail file
HPUX-ia64 Error: 28: No space left on device
SQL>
Database "ECDBAZE" warm started.

And with 'sqlplus' the following message is observed:

$ sqlplus ecscada/scada
SQL*Plus: Release 9.2.0.2.0 - Production on Wed Jun 27 13:42:55 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HPUX-ia64 Error: 2: No such file or directory.

Can any one help to come out of this problem as it is very urgent? Is it any thing to do with the audit files created in the '$ORACLE_HOME/rdbms/audit' folder or with the files created in the '$ORACLE_HOME/rdbms/log' folder. And if any log files are being created, how to disable the creation of log files and how to delete the existing log files so as to free the file system logical volume.

Later the Global Database by which we are identifying our database was deleted using 'dbca' - the Database Configuration Assistant. We could delete the database but I am not able to create a new database as it is mentioned that the space on the logical volume is less than what is required.
3 REPLIES
Svetoslav Gyurov
Valued Contributor

Re: Oracle File System is full. How to come out of it?

Hi,

It seems that your dump destination directory is full. Observe the spfile and find the parameter .audit_file_dest, this is where the audit files are written or just type bdf and paste it. It is possible that some core dump are eating you space, usually they are big.
Oviwan
Honored Contributor

Re: Oracle File System is full. How to come out of it?

Hey

check for large file in your oracle home. maybe there are some core files

#find $ORACLE_HOME -name core

if you have deleted your database so you can also delete the log- and auditfiles.

are you sure you have deleted your database because generally when you delete the whole database (datafiles, archivelogs,...) there should be enough space...

check with "bdf" the available space for your oracle mount point.

Regards

don't forget to assign points, also in your other threads
Yogeeraj_1
Honored Contributor

Re: Oracle File System is full. How to come out of it?

hi Srinivas,

The problem that you are having is related to the file system when Oracle is trying to create the log files.

Verify your cdump, udump and bdump directories. You may have to do some purging over there.

Also review the file system where you keep your oracle data files.


As someone also mentioned, search for the core dumps and delete them to free up space.

You must also analyse the growth is it data or just log/trace files that are linked to errors being reported by the database (check your alert.log)


hope this helps!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)