当尝试连接Oracle ASM单实例数据库时，遇到了ORA-09817和ORA-09945错误，原因是磁盘空间不足。错误日志显示Linux错误28，表明无可用空间。解决方案包括清理磁盘空间和重启ASM及数据库实例。首先通过`df -h`检查磁盘使用情况，发现根分区已满。然后杀掉阻塞进程，如rman进程，并释放磁盘空间。接着启动ASM实例，再启动数据库实例，最后启动监听器，问题得以解决。
bug: 进入asm 单实例数据库时报错：
SQL> conn /as sysdba;
ERROR:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space left on device
查看alter日志：
Thu Jul 22 07:10:44 2010
Unexpected communication failure with ASM instance:
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space left on device
Unexpected communication failure with ASM instance:
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space left on device
Thu Jul 22 07:10:45 2010
Errors in file /u01/app/oracle/admin/jestoo/bdump/jestoo_rvwr_21145.trc:
ORA-38701: Flashback database log 67 seq 67 thread 1: "+DATA1/jestoo/flashback/log_67.341.724898901"
ORA-17503: ksfdopn:2 Failed to open file +DATA1/jestoo/flashback/log_67.341.724898901
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space left on device
*************************************
RVWR encountered an error when writing flashback database logs.
See error stack in alert log. To avoid crashing the instance,
this instance has turned off flashback database.
*************************************
Thu Jul 22 08:30:57 2010
Process m000 died, see its trace file
出现的原因是
(1)：
[oracle@oracle9i ~]$ df -h
Filesystem Size
最低0.47元/天 解锁文章
扫一扫
2112
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
