No,

It because I have only 2GB free on oracle11i. The solution how can I delete some file at least to manage situation.
When I run rm arch_1

[oracle@ebs3 dbs]$ rm arch1_700500_824307445.dbf
rm: cannot remove `arch1_700500_824307445.dbf': Read-only file system
[oracle@ebs3 dbs]$

Do you know haw can I delete ?

probably you need to remount the filesystem as rw. I don't suggest you to remove that file, probably you will destroy your database. From the other hand the filesystem was mounted as read only because of a critical error. You must fix it before continue.

1 members found this post helpful.

**AGAIN**
Ask your DBA...removing a .dbf file will DELETE PART OF YOUR DATABASE
READ the Oracle links you were given about managing disk space. Until you actually take some action, it won't work. AGAIN: Restart your system without starting up Oracle.
You are STILL getting these messages because Oracle is using disk space, and you have to go in through the Oracle utilities to reclaim/manage it. That's it....Linux can't do much here, you're in Oracle territory.

AGAIN: Call Oracle support; ask your DBA. Why are you ignoring all of this advice??? You keep asking/restating the question over and over, and are ignoring the answer.

Hi,

I try to delete file but does not accept. It change all database directory file to read only. How can I execute rm?
[oracle@ebs3 audit]$ rm -f prod_ora_8725_1.aud
rm: cannot remove `prod_ora_8725_1.aud': Read-only file system
[oracle@ebs3 audit]$ chmod 777 prod_ora_8725_1.aud
chmod: changing permissions of `prod_ora_8725_1.aud': Read-only file system

It happen after shutdown at lunch time according with last posted.

Regards

Sorry, but why are you ignoring what you're told??? If you're not going to listen and take advice, there is no point in posting.

• You were told VERY PLAINLY that in order to delete those files, you were going to have to remount the filesystem in read/write mode.
• You were ALSO told very plainly that deleting those files is a VERY BAD IDEA, since you will then delete part of your database
• You were told to ask your DBA for help
• You were given a link to Oracle disk space management utilities/tips/hints to read, and (apparently) haven't read it
• You were told to call Oracle support, and apparently haven't
• You were told that just restating the questions over and over isn't a good thing, and won't get you help. But you're still doing it.

Are you not paying attention?

Well, the PID is part of the lsof output. But if you start killing Oracle processes, your database will stop working. And if you start deleting files without knowing what they contain, I hope you have good backups and enough time to restore them.

Follow TB0ne's advice, speak to someone who knows how to deal with Oracle. I don't.

1 members found this post helpful.

Indeed.

Oracle does handle disk usage in its own way. But as I told the OP, if you stop the Oracle service and put it in a manual-start state and just REBOOT...it won't start at boot time. Your disk usage may vary...but maybe not. Depending on how you have your extents and other things set up, Oracle may have reserved another xxx amount of disk, period. So unless you go in and prune data from the database, adjust running parameters, etc. And ALL of this depends on the database itself.

And any DBA that even halfway knows what they're doing, can easily figure out a problem like this. Oracle support can walk you through MANY things to do. I know enough about Oracle to be dangerous, but on a production database, I'd be very hesitant to touch it without the DBA being on board.

if you did not recognize it: your filesystem is read only now, you cannot delete any file from it. You need to boot into single user mode, remount that partition rw and fix the error which caused this situation. But first you need to understand the problem. You can get some ideas from /var/log. (no, it is not the disk full, but most probably that filesystem is already corrupted, or there is a hardware related error - or something else...)