[ERROR] ORA-09945, ORA-09817 disk space is insufficient
I. Problem Description
When you use client software to connect to the database, a ORA-09945, such as, is reported as there is no space as prompted. When using sqlplus to connect, an error message is ORA-09817, prompting that the error message is still empty. The system df-h check shows that the directory does not have space. Solution: Expand or clear space. [Oracle @ tora01 ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.4.0 Production on Mon May 25 11:47:57 2015 Copyright (c) 1982,201 3, Oracle. all rights reserved. ERROR: ORA-09817: Write to audit file failed. linux-x86_64 Error: 28: No space left on deviceAdditional information: 12ORA-01075: you are currently logged on Enter user-name: ERROR: ORA-01017: invalid username/password; logon denied Enter user-name: ERROR: ORA-0 1017: invalid username/password; logon denied SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL * Plus [oracle @ tora01 ~] $ II. troubleshooting 1. Check the system space status [oracle @ tora01 ~] $ Df-H file system capacity in use % available mount point/dev/sda3 287G 272G 0 100%/dev/sda1 190 M 12 M 169 M 7%/boottmpfs 7.9G 0 7.9G 0%/dev/shm/dev/sdb1 30G 173 M 28G 1%/oratest/dev/sdc1 296G 527 M 280G 1%/dbtest [oracle @ tora01 ~] $2. Clear disks [oracle @ tora01 ~] $ Df-H file system capacity in use % available mount point/dev/sda3 287G 267G 5.7G 98% G 190/dev/sda1 169 M 12 M 7% M 7.9/boottmpfs G 0 7.9G 0%/dev/shm/dev/sdb1 30G 173 M 28G 1%/oratest/dev/sdc1 296G 2.5G 278G 1%/dbtest 3. the connection is normal. troubleshooting [oracle @ tora01 diag] $ sqlplus/as sysdba SQL * Plus: Release 11.2.0.4.0 Production on Mon May 25 13:17:57 2015 Copyright (c) 1982,201 3, Oracle. all rights reserved. connected to: Oracle Database 11g Ent Erprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> 3. Summary of this problem is not easy to see in large companies with relatively fine scores, because there will be dedicated System Engineers for monitoring, it is not easy to generate. However, in some small companies, when the technical staff are always multi-valued, various small problems may occur. Suggestion: even in small companies, when there are insufficient employees, we need to monitor the production environment, so the requirements for our group of DBAs are getting higher and higher, try to write a monitoring script or find some open source monitoring software.