ORA-09817: Write to audit file failed 解決方法 |
發(fā)布時(shí)間: 2012/9/17 17:01:10 |
連接Oracle 報(bào)錯(cuò):ORA-09817: Write to audit file failed.
[Oracle@qs-dmm-rh1 dave]$ sqlplus sys/oracle as sysdba; SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 17 16:35:02 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR: ORA-09817: Write to audit file failed. --這種錯(cuò)誤基本是磁盤空間滿了 Enter user-name: ERROR: ORA-01017: invalid username/password; logon denied
Enter user-name: ERROR: ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to Oracle after 3 attempts, exiting SQL*Plus [Oracle@qs-dmm-rh1 dave]$ oerr ora 9817 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. [Oracle@qs-dmm-rh1 dave]$ df -lh Filesystem Size Used Avail Use% Mounted on /dev/sda3 13G 12G 136K 100% / /dev/sda1 99M 12M 83M 12% /boot tmpfs 506M 0 506M 0% /dev/shm [Oracle@qs-dmm-rh1 dave]$
刪除部分文件后:
[Oracle@qs-dmm-rh1 u01]$ df -lh Filesystem Size Used Avail Use% Mounted on /dev/sda3 13G 9.1G 2.8G 77% / /dev/sda1 99M 12M 83M 12% /boot tmpfs 506M 0 506M 0% /dev/shm
再次連接正常:
[Oracle@qs-dmm-rh1 u01]$ sqlplus / as sysdba; SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 17 17:06:43 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select open_mode from v$database;
OPEN_MODE ---------- MOUNTED
本文出自:億恩科技【mszdt.com】 服務(wù)器租用/服務(wù)器托管中國五強(qiáng)!虛擬主機(jī)域名注冊頂級提供商!15年品質(zhì)保障!--億恩科技[ENKJ.COM] |