人生最低谷绝望的心情:ORA-09817,ORA-01075报错解决方法
来源:百度文库 编辑:中财网 时间:2024/04/27 23:48:27
在连接数据库时报错
$ 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中的文件,问题解决
$ 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中的文件,问题解决
ora-03114报错,怎么解决?、
ora-1157
[oracle][odbc][ora ]ora-00904
关于ORA-06550的问题
ora-12537 tns 连接关闭
java.sql.SQLException: ORA-01009: ?? ????? ????
ORA-12560:TNS:协议适配器错误
ora数据这个错误是什么意思!求救!!!``
ora数据这个错误是什么意思!求救!!!
ORA-00001: 违反唯一约束条件 (FSDPGL.PK_TBYPZC)是什么意思呀
我登录oracle9i的时候出现ora 12545错误是怎么回事?
Error while trying to retrieve text for error ORA-12154
ORA-12545: 因目标主机或对象不存在,连接失败
ora-01033:oracle initializationg or shutdown in progress
ORA-01036: 非法的变量名/编号
ORA-01033:ORACLE initialization or shutdown in progress
PL/SQL ORA 00900 无效sql语句?
"java.sql.SQLException: ORA-01008: 并非所有变量都已关联" 这是啥么原因呢
pl/sql 连接 oracle 提示:ORA-12154 无法解析指定的连接标志符
中国化工报
本命年报
报程序员
电子版报
《报地名》