今天登陆测试库时报ORA-09817错误,查了下原来是操作系统没空间了..囧
过程记录如下:
oracle@wimngNB_test:~ $ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 23 09:55:22 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
ERROR:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
Additional information: 12
ORA-01075: you are currently logged on
SQL> show user
USER is ""
SQL> exit
bash-2.05$ 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.
bash-2.05$
oracle@wimngNB_test:~ $df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sdc1 15G 15G 0 100% /
/dev/sda1 99M 14M 80M 15% /boot
/dev/sdb1 60G 53G 4.5G 93% /data
none 7.0G 1.4G 5.7G 19% /dev/shm
到闪回区,删除部分归档日志,让系统暂时可用
oracle@wimngNB_test:/orasys/flash_recovery_area/WIMNG2/archivelog $ ls
2012_01_20 2012_01_24 2012_01_28 2012_02_09 2012_02_13 2012_02_17 2012_02_21
2012_01_21 2012_01_25 2012_01_29 2012_02_10 2012_02_14 2012_02_18 2012_02_22
2012_01_22 2012_01_26 2012_01_30 2012_02_11 2012_02_15 2012_02_19 2012_02_23
2012_01_23 2012_01_27 2012_02_08 2012_02_12 2012_02_16 2012_02_20
oracle@wimngNB_test:/orasys/flash_recovery_area/WIMNG2/archivelog $rm -rf 2012_01_20
oracle@wimngNB_test:/orasys/flash_recovery_area/WIMNG2/archivelog $rm -rf 2012_01_24
oracle@wimngNB_test:/orasys/flash_recovery_area/WIMNG2/archivelog $ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sdc1 15G 14G 191M 99% /
/dev/sda1 99M 14M 80M 15% /boot
/dev/sdb1 60G 53G 4.5G 93% /data
none 7.0G 1.4G 5.7G 19% /dev/shm
oracle@wimngNB_test:/orasys/flash_recovery_area/WIMNG2/archivelog $ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 23 10:01:17 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL>