磁碟滿了sys無法連線寫入audit檔案

早上開啟伺服器發現119的資料庫又意外關閉了，啟動資料庫，但是居然無法連線到oracle，報的一個audit fle failed，寫入審計檔案報錯。磁碟沒有空間了，不過審計預設是沒有開啟的。那麼應該不會寫入audit日誌到資料檔案中啊。但是sys連線資料庫，啟動關閉資料庫是會被記錄到日誌檔案中的，預設的在$ORACLE_BASE/admin/benguo/adump下。

SQL> show parameter audit_trail;

NAME TYPE VALUE

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

audit_trail string NONE

audit_trail引數的設定，預設為none不做審計，db將audit trail記錄在資料庫的審計相關表中，如aud$，透過dba_audit_trail可以檢視。Os將audit trail記錄在作業系統中，檔名由audit_file_dest引數指定。

[oracle@server119 ~]$ ipcs -sa

------ Shared Memory Segments --------

key shmid owner perms bytes nattch status

------ Semaphore Arrays --------

key semid owner perms nsems

------ Message Queues --------

key msqid owner perms used-bytes messages

[oracle@server119 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jun 12 09:00:28 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:

ORA-09817: Write to audit file failed.

Linux-x86_64 Error: 28: No space left on device

ORA-09945: Unable to initialize the audit trail file

Linux-x86_64 Error: 28: No space left on device

Enter user-name:

[2]+ Stopped rlwrap sqlplus / as sysdba

刪除oracle所在的目錄騰出部分空間，然後可以連線啟動資料庫後續都正常了。

追蹤以下alert日誌，發現出現了一個07445然後導致了pmon程式中斷，然後pmon程式導致了instance中斷了。

檢視alert日誌發現了

Mon Jun 11 17:41:13 2012

Errors in file /db/oracle10g/admin/benguo/udump/benguo_ora_24229.trc:

ORA-07445: exception encountered: core dump [xtyqbcb()+336] [SIGSEGV] [Address not mapped to object] [0x00000000A] [] []

Mon Jun 11 17:42:42 2012

Errors in file /db/oracle10g/admin/benguo/bdump/benguo_pmon_21622.trc:

ORA-00600: internal error code, arguments: [17147], [0x673B31000], [], [], [], [], [], []

Mon Jun 11 17:42:45 2012

Errors in file /db/oracle10g/admin/benguo/bdump/benguo_pmon_21622.trc:

ORA-00600: internal error code, arguments: [17147], [0x673B31000], [], [], [], [], [], []

Mon Jun 11 17:42:45 2012

PMON: terminating instance due to error 472

Mon Jun 11 17:42:46 2012

Errors in file /db/oracle10g/admin/benguo/udump/benguo_ora_25911.trc:

ORA-00472: PMON process terminated with error

ORA-00472: PMON process terminated with error

[@more@]