ORA-09817: Write to audit file failed.解决方法

ORA-09817: Write to audit file failed.解决方法

 

遇到的问题：

连接oracle报错：ORA-09817: Write to audit file failed.

# su - oracle

$ sqlplus /nolog

 

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jun 28 22:48:22 2011

 

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

idle> conn /as sysdba

ERROR:

ORA-09817: Write to audit file failed.

--我的第一反应是磁盘空间可能满了，磁盘空间问题引起的故障

IBM AIX RISC System/6000 Error: 28: No space left on device

ORA-01075: you are currently logged on

 

 

idle>

 

使用oerr查看Oracle错误信息

$ cd $ORACLE_HOME/bin

$ pwd

/u01/app/oracle/product/10.2.0/db_1/bin

$ oerr ora 09817

09817, 00000, "Write to audit file failed."

// *Cause:  ORACLE was unable to write an entry to the file used as the

//          audit trail.

// *Action: Check the UNIX error number for a possible operating system error.

//          If there is no error, contact Oracle Support Services.

$

 

验证磁盘空间使用情况

$ df -k

Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on

/dev/hd4           524288    239128   55%     4667     8% /

/dev/hd2          2097152    182820   92%    41604    48% /usr

/dev/hd9var        262144    233696   11%      651     2% /var

/dev/hd3          1048576   1012372    4%       44     1% /tmp

/dev/hd1           262144    221192   16%       73     1% /home

/proc                   -         -    -         -     -  /proc

/dev/hd10opt       524288    203384   62%    11458    20% /opt

/dev/fslv00      25165824         0  100%    57115    97% /u01

--证实了我的猜想

/dev/fslv01       8388608   4271648   50%       53     1% /u02

 

删除部分trace文件，我这里是实验系统，生成系统请注意操作

$ cd /u01/app/oracle/admin/orcl/udump

$ ls

orcl1_fal_299262.trc  orcl1_ora_397396.trc  orcl1_ora_577598.trc  orcl1_ora_655516.trc  orcl1_ora_761908.trc

orcl1_fal_323790.trc  orcl1_ora_401410.trc  orcl1_ora_577702.trc  orcl1_ora_659514.trc  orcl1_ora_761936.trc

orcl1_fal_323812.trc  orcl1_ora_426068.trc  orcl1_ora_581744.trc  orcl1_ora_659530.trc  orcl1_ora_761990.trc

orcl1_fal_385054.trc  orcl1_ora_438308.trc  orcl1_ora_581844.trc  orcl1_ora_663798.trc  orcl1_ora_774154.trc

orcl1_fal_467164.trc  orcl1_ora_446676.trc  orcl1_ora_594060.trc  orcl1_ora_667692.trc  orcl1_ora_774234.trc

orcl1_fal_626746.trc  orcl1_ora_475226.trc  orcl1_ora_598182.trc  orcl1_ora_671880.trc  orcl1_ora_774312.trc

orcl1_fal_626778.trc  orcl1_ora_479338.trc  orcl1_ora_606292.trc  orcl1_ora_675868.trc  orcl1_ora_774382.trc

orcl1_fal_626796.trc  orcl1_ora_487544.trc  orcl1_ora_610350.trc  orcl1_ora_675922.trc  orcl1_ora_774396.trc

orcl1_fal_626816.trc  orcl1_ora_487550.trc  orcl1_ora_614452.trc  orcl1_ora_679940.trc  orcl1_ora_778284.trc

orcl1_fal_626838.trc  orcl1_ora_491724.trc  orcl1_ora_614534.trc  orcl1_ora_680026.trc  orcl1_ora_782370.trc

orcl1_fal_700588.trc  orcl1_ora_495754.trc  orcl1_ora_618554.trc  orcl1_ora_680034.trc  orcl1_ora_790774.trc

orcl1_fal_778300.trc  orcl1_ora_495770.trc  orcl1_ora_618620.trc  orcl1_ora_684080.trc  orcl1_ora_794666.trc

orcl1_fal_819206.trc  orcl1_ora_499714.trc  orcl1_ora_618632.trc  orcl1_ora_684248.trc  orcl1_ora_811190.trc

orcl1_fal_819436.trc  orcl1_ora_512022.trc  orcl1_ora_618694.trc  orcl1_ora_688360.trc  orcl1_ora_823412.trc

orcl1_fal_819450.trc  orcl1_ora_512126.trc  orcl1_ora_618704.trc  orcl1_ora_696478.trc  orcl1_ora_839728.trc

orcl1_fal_827456.trc  orcl1_ora_520222.trc  orcl1_ora_622726.trc  orcl1_ora_700422.trc  orcl1_ora_839834.trc

orcl1_fal_827466.trc  orcl1_ora_536584.trc  orcl1_ora_626780.trc  orcl1_ora_704632.trc  orcl1_ora_847872.trc

orcl1_fal_856128.trc  orcl1_ora_544848.trc  orcl1_ora_626844.trc  orcl1_ora_704688.trc  orcl1_ora_847912.trc

orcl1_ora_291004.trc  orcl1_ora_548914.trc  orcl1_ora_634960.trc  orcl1_ora_708644.trc  orcl1_ora_860392.trc

orcl1_ora_299108.trc  orcl1_ora_561172.trc  orcl1_ora_643190.trc  orcl1_ora_721016.trc  orcl1_ora_864262.trc

orcl1_ora_327766.trc  orcl1_ora_561178.trc  orcl1_ora_651356.trc  orcl1_ora_729162.trc  orcl1_ora_864282.trc

orcl1_ora_327848.trc  orcl1_ora_561198.trc  orcl1_ora_655362.trc  orcl1_ora_729168.trc  orcl1_ora_864490.trc

orcl1_ora_327852.trc  orcl1_ora_561252.trc  orcl1_ora_655438.trc  orcl1_ora_729176.trc  orcl1_ora_880694.trc

orcl1_ora_331954.trc  orcl1_ora_569464.trc  orcl1_ora_655442.trc  orcl1_ora_745484.trc  orcl1_ora_892978.trc

orcl1_ora_340126.trc  orcl1_ora_569474.trc  orcl1_ora_655446.trc  orcl1_ora_749730.trc  orcl1_ora_901136.trc

$ rm -rf *.trc

 

查看空间利用情况

$ df -k

Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on

/dev/hd4           524288    239120   55%     4667     8% /

/dev/hd2          2097152    182820   92%    41604    48% /usr

/dev/hd9var        262144    233696   11%      651     2% /var

/dev/hd3          1048576   1012372    4%       44     1% /tmp

/dev/hd1           262144    221192   16%       73     1% /home

/proc                   -         -    -         -     -  /proc

/dev/hd10opt       524288    203384   62%    11458    20% /opt

/dev/fslv00      25165824      6968  100%    56993    94% /u01

/dev/fslv01       8388608   4271648   50%       53     1% /u02

 

此时连接恢复正常

idle> conn /as sysdba

Connected.

sys@ORCL> select open_mode from v$database;

 

OPEN_MODE

----------

READ WRITE

sys@ORCL> show parameter user_dump_dest

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

user_dump_dest                       string      /u01/app/oracle/admin/orcl/udu

                                                 mp

sys@ORCL>

 

--The End--