1、通過sqlplus / as sysdba在服務(wù)器上無法登錄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所在的服務(wù)器的磁盤空間已經(jīng)被占用滿了，需要清理不必要的磁盤文件，重啟數(shù)據(jù)庫即可。

#查看磁盤使用情況

df -h

#查找oracle的trace文件目錄

find / -name ? trace ?-type d

eg:/u01/app/oracle/diag/rdbms/ipems/ipems/trace

#進入trace目錄，查尋、刪除指定天數(shù)以前的文件

find -ctime +10 | more

#查看當(dāng)前目錄下文件個數(shù)

find ./ ?-type f | wc -l

find ?-type f | wc -l

#查看目錄下各文件的大小，并按順序顯示(從小到大)

du -sh * | sort -n

#查看告警日志文件的大小

du -sh alert_ipems.log

#告警日志可以直接刪除(如無特殊查看需要的化)，刪除后系統(tǒng)會自動創(chuàng)建(記錄啟動，關(guān)閉，連接錯誤信息)

#查看監(jiān)聽日志(通過如下命令可以查看到監(jiān)聽告警日志的目錄，監(jiān)聽日志的目錄在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用戶下執(zhí)行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

總結(jié)

以上是生活随笔為你收集整理的oracle no space left,ORA-09817/Linux-x86_64 Error: 28: No space left on device/ORA-01075的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。