Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Can not open the DB after disk's fulling

513756Sep 28 2007 — edited Oct 19 2007

Hi,

I have an Oracle 10g release 1 (10.1.0.2) DB running on a Linux Redhat9 server.

Last week, the DB could not be started.

SQL> Connected to an idle instance

SQL> ORA-29701: unable to connect to Cluster Manager

SQL> Disconnected

SQL> Connected to an idle instance

SQL> ORA-09817: Write to audit file failed.

Linux Error: 28: NO space left on device

SQL> Disconnected

So the log files under /opt/oracle/admin/orcl10g/ were moved to another place, and the oracle DB could be started up, but the database could not be opened. The only way is to perform recovery, right?

Any hints are highly appreciated!

Qian

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 16 2007

Added on Sep 28 2007

#general-database-discussions

39 comments

3,935 views