oracle ora-09925 无法创建审计跟踪文件没有这样的文件或目录
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/39997318/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
ora-09925 unable to create audit trail file no such file or directory
提问by mradul
I have just installed a oracle 12c 12.1.0 DB on a linux machine.
我刚刚在 linux 机器上安装了一个 oracle 12c 12.1.0 DB。
after completing the installation i tried to login to database as sysdba
完成安装后，我尝试以 sysdba 身份登录数据库
[oracle@bjorn adump]$ sqlplus sys as sysdba/welcome
SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 12 16:41:17 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
Now i tried to startup the DB using below command
现在我尝试使用以下命令启动数据库
SQL> startup mount
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
and this error pop up !
并弹出此错误！
my ENV variable are --
我的 ENV 变量是——
[oracle@bjorn adump]$ echo $ORACLE_BASE
/oracle
[oracle@bjorn adump]$ echo $ORACLE_HOME
/oracle/product/12.1.0/db_1
I have checked into pfile which is $ORACLE_HOME/dbs/init.ora
我已经检查了 $ORACLE_HOME/dbs/init.ora 的 pfile
there is the entry for audit file
有审计文件的条目
audit_file_dest="/oracle/admin/orcl/adump"
I also go to this location and check if the folder exists or nt but the folder was there and it aleady has some files in it like
我也去这个位置检查文件夹是否存在或nt但是文件夹在那里并且它aleady里面有一些文件
orcl_m000_21634_20161012143245012051143795.aud
there are lots of file with names like this.
有很多这样的文件名。
I gave permission to this folder
我已授予此文件夹的权限
chmod -R 755 /oracle/admin/orcl/adump
tried creating a new file using
尝试使用创建一个新文件
touch afile
and file get created.
并创建文件。
It also got connect to the idle session but when i tried to do a startup the error pops up !
它还连接到空闲会话，但是当我尝试启动时，错误弹出！
Please suggest what i am overlooking here which needs to be corrected.
请提出我在这里忽略的需要纠正的内容。
回答by Sebz
Usually this could happen because:
通常这可能是因为：
- AUDIT_FILE_DEST is not writable(chown +w $AUDIT_FILE_DEST)
- $ORACLE_BASE/admin/$ORACLE_SID/adump exists and is not writable
- $ORACLE_HOME/rdbms/audit is not writable
- AUDIT_FILE_DEST 不可写(chown +w $AUDIT_FILE_DEST)
- $ORACLE_BASE/admin/$ORACLE_SID/adump 存在且不可写
- $ORACLE_HOME/rdbms/audit 不可写
PS: Make sure to check permissions for the oracle user
PS：一定要检查oracle用户的权限
Also please check for disk space availability
另请检查磁盘空间可用性
回答by kilroy
In our case, one of the drives in one of our 2-node RAC servers was failing - the reason why the OS (Linux) limited anyone's access, including root, to read-only.
在我们的案例中，我们的一台 2 节点 RAC 服务器中的一个驱动器出现故障 - 这就是操作系统 (Linux) 将任何人的访问权限（包括 root）限制为只读的原因。
The amber light was suppose to turn on but it didn't. It only turned on when we restarted that particular node.
琥珀色的灯本来应该亮着，但它没有。它仅在我们重新启动该特定节点时打开。
回答by Triptic
You also have 3 things to verify: - As already mentionned, check free space with df -have - Check if the file system are Read/Write or read-only: cat /proc/mounts - Finally, you can check free inodes space with df -i
您还需要验证 3 件事： - 如前所述，使用 df -have 检查可用空间 - 检查文件系统是读/写还是只读： cat /proc/mounts - 最后，您可以使用以下命令检查空闲 inode 空间df -i
Detailled information can be found here: https://www.oracle-scripts.net/unable-to-create-audit-trail-file-read-only-file-system/
详细信息可以在这里找到：https://www.oracle-scripts.net/unable-to-create-audit-trail-file-read-only-file-system/
