在连接数据库时报错
$ sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.3.0 - Production on Mon Aug 16 09:38:49 2010 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. ERROR: ORA-09817: Write to audit file failed. IBM AIX RISC System/6000 Error: 28: No space left on device ORA-01075: you are currently logged on 查看硬盘空间发现archivelog满了,我用oracle用户到对应的archivelog目录下删除了比较老的日志后又操作了一遍,报错依旧 $ sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.3.0 - Production on Mon Aug 16 09:38:49 2010 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. ERROR: ORA-09817: Write to audit file failed. IBM AIX RISC System/6000 Error: 28: No space left on device ORA-01075: you are currently logged on 我按照提示接着用system用户登录 Enter user-name: system Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options 登录成功,查看了下数据库的状态,没有发现问题 SQL> select * from v$instance; 试图重启数据库时报错 SQL> shutdown immediate ORA-01031: insufficient privileges 查看audit_file_dest指向的目标是否无法写入了 SQL> show parameter audit_file_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_file_dest string /oracle/admin/sample/adump 发现/oracle目录已满,删除 /oracle/admin/sample/adump和 /oracle/admin/sample/bdump中的文件,问题解决 |
|