#created at 18-10-28 by nod
#提示磁盘空间已满 不能登录数据库 18-10-28
[oracle@oracle ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sun Oct 28 21:16:25 2018
Copyright (c) 1982, 2011, Oracle. All rights reserved.
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
参考博文:
https://www.cnblogs.com/vanwoos/p/8080072.html
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@oracle alert]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 45G 42G 16M 100% /
tmpfs 931M 483M 449M 52% /dev/shm
/dev/sda1 190M 40M 141M 22% /boot
/dev/sr0 3.7G 3.7G 0 100% /mnt
处理方式:清除以下2个文件夹当中所有内容
/u01/app/diag/rdbms/orcl/orcl/alert
/u01/app/diag/rdbms/orcl/orcl/trace