ORA-09817/Linux-x86_64 Error: 28: No space left on device/ORA-01075

2019独角兽企业重金招聘Python工程师标准>>>

1、通过sqlplus / as sysdba在服务器上无法登录oracle，并提示一下错误
ERROR:
ORA-09817: Write to audit file failed.
Linux-x86_64 Error: 28: No space left on device
Additional information: 12
ORA-01075: you are currently logged on
 
 
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

2、分析：
    提示此错误一般是oracle所在的服务器的磁盘空间已经被占用满了，需要清理不必要的磁盘文件，重启数据库即可。
#查看磁盘使用情况
df -h
#查找oracle的trace文件目录
find / -name   trace  -type d
eg:/u01/app/oracle/diag/rdbms/ipems/ipems/trace
#进入trace目录，查寻、删除指定天数以前的文件
find -ctime +10 | more
#查看当前目录下文件个数
find ./  -type f | wc -l
find  -type f | wc -l
#查看目录下各文件的大小，并按顺序显示（从小到大）
du -sh * | sort -n
#查看告警日志文件的大小
du -sh alert_ipems.log
#告警日志可以直接删除（如无特殊查看需要的化），删除后系统会自动创建（记录启动，关闭，连接错误信息）
#查看监听日志（通过如下命令可以查看到监听告警日志的目录，监听日志的目录在trace目录下，alter和trace目录下都得清理）
lsnrctl status
[oracle@db trace]$ ll
total 3754948
-rw-r-----  1 oracle oinstall 3843788210 Nov  6 09:00 listener.log
-rw-r-----  1 oracle oinstall          0 Feb 27  2017 ora_11364_139845928687360.trc
-rw-r-----. 1 oracle oinstall          0 May 13  2014 ora_31962_139886341228288.trc
-rw-r-----  1 oracle oinstall          0 Aug  8  2015 ora_3456_140354969544448.trc
[oracle@db trace]$ lsnrctl set log_status off

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-NOV-2017 09:02:36

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
LISTENER parameter "log_status" set to OFF
The command completed successfully
[oracle@db trace]$ mv listener.log  listener.log.bak
[oracle@db trace]$ ls
listener.log.bak  ora_11364_139845928687360.trc  ora_31962_139886341228288.trc  ora_3456_140354969544448.trc
[oracle@db trace]$ ll
total 3754948
-rw-r-----  1 oracle oinstall 3843788210 Nov  6 09:00 listener.log.bak
-rw-r-----  1 oracle oinstall          0 Feb 27  2017 ora_11364_139845928687360.trc
-rw-r-----. 1 oracle oinstall          0 May 13  2014 ora_31962_139886341228288.trc
-rw-r-----  1 oracle oinstall          0 Aug  8  2015 ora_3456_140354969544448.trc
[oracle@db trace]$ lsnrctl set log_status on

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-NOV-2017 09:03:16

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
LISTENER parameter "log_status" set to ON
The command completed successfully
[oracle@db trace]$ ls
listener.log  listener.log.bak  ora_11364_139845928687360.trc  ora_31962_139886341228288.trc  ora_3456_140354969544448.trc
[oracle@db trace]$ ll
total 3754952
-rw-r-----  1 oracle oinstall         63 Nov  6 09:03 listener.log
-rw-r-----  1 oracle oinstall 3843788210 Nov  6 09:00 listener.log.bak
-rw-r-----  1 oracle oinstall          0 Feb 27  2017 ora_11364_139845928687360.trc
-rw-r-----. 1 oracle oinstall          0 May 13  2014 ora_31962_139886341228288.trc
-rw-r-----  1 oracle oinstall          0 Aug  8  2015 ora_3456_140354969544448.trc

要看警告日志可以在oracle用户下执行adrci
[oracle@db oracle]$ adrci

ADRCI: Release 11.2.0.1.0 - Production on Mon Nov 6 09:14:50 2017

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/app/oracle"
adrci> show alert

Choose the alert log from the following homes to view:

1: diag/tnslsnr/db/listener
2: diag/rdbms/ipems/ipems
Q: to quit

 

转载于:https://my.oschina.net/peakfang/blog/2874663