sqlplus链接数据库报ORA-09925: Unable to create audit trail file
[localhost.localdomain]:[/oracle11/app/oracle11/product/11.2.0/dbhome_1/dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 22 14:50:48 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on
查看参数文件:
*.audit_file_dest='/u01/app/oracle/admin/PROD/adump'
在服务器上查看没有这个目录,解决方法就是建立这个目录并且赋予读写权限
原因:
$ORACLE_HOME/rdbms/audit 是不是空间满了? 当前用户对$ORACLE_HOME/rdbms/audit 没有写权限? audit_file_dest的设置是不是改了,不是默认的$ORACLE_HOME/rdbms/audit 路径了? 不管audit_trace设不设, DB对以下三项都是要audit的: 1.conn / as sysdba or / as sysoper 2.db shutdown 3.db startup |
笔记