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

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