Oracle Database
--
Questions
--
Followers
Top Experts
ORA-09925: Unable to create audit trail file
What are the causes and the fix?
$ sqlplus '/as sysdba'
SQL*Plus: Release 8.1.7.0.0 - Production on Mon Aug 21 12:03:53 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to an idle instance.
12:03:53 SQL> startup nomount;
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 9925
$ sqlplus '/as sysdba'
SQL*Plus: Release 8.1.7.0.0 - Production on Mon Aug 21 12:03:53 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to an idle instance.
12:03:53 SQL> startup nomount;
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 9925
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Check the permisions on the AUDIT_DEST folder. it's nomally set to $ORACLE_HOME\rdbms\audit.
Also check if there is sufficient space.
Also check if there is sufficient space.
/u01/oracle/product/8.1.7.
# ls -al
total 136
drwxr-sr-x 13 oracle dba 512 Nov 20 2003 .
drwxr-sr-x 40 oracle dba 1024 Nov 20 2003 ..
drwxr-sr-x 2 oracle dba 10240 Sep 08 2005 admin
drwxr-sr-x 2 oracle dba 6144 Aug 21 13:48 audit
drwxr-sr-x 2 oracle dba 5120 Nov 20 2003 demo
drwxr-sr-x 2 oracle dba 512 Nov 20 2003 doc
drwxr-sr-x 5 oracle dba 512 Nov 20 2003 install
drwxr-sr-x 2 oracle dba 512 Nov 20 2003 jlib
drwxr-sr-x 2 oracle dba 2048 Nov 20 2003 lib
drwxr-sr-x 2 oracle dba 512 Apr 18 10:30 log
drwxr-sr-x 2 oracle dba 1024 Nov 20 2003 mesg
drwxrwsr-x 2 oracle dba 512 Nov 20 2003 notes
drwxr-sr-x 2 oracle dba 512 Nov 20 2003 public
df -g
/dev/u01backup 8.19 4.45 46% 38012 2% /u01
It looks ok though.... Anything else to look at?
# ls -al
total 136
drwxr-sr-x 13 oracle dba 512 Nov 20 2003 .
drwxr-sr-x 40 oracle dba 1024 Nov 20 2003 ..
drwxr-sr-x 2 oracle dba 10240 Sep 08 2005 admin
drwxr-sr-x 2 oracle dba 6144 Aug 21 13:48 audit
drwxr-sr-x 2 oracle dba 5120 Nov 20 2003 demo
drwxr-sr-x 2 oracle dba 512 Nov 20 2003 doc
drwxr-sr-x 5 oracle dba 512 Nov 20 2003 install
drwxr-sr-x 2 oracle dba 512 Nov 20 2003 jlib
drwxr-sr-x 2 oracle dba 2048 Nov 20 2003 lib
drwxr-sr-x 2 oracle dba 512 Apr 18 10:30 log
drwxr-sr-x 2 oracle dba 1024 Nov 20 2003 mesg
drwxrwsr-x 2 oracle dba 512 Nov 20 2003 notes
drwxr-sr-x 2 oracle dba 512 Nov 20 2003 public
df -g
/dev/u01backup 8.19 4.45 46% 38012 2% /u01
It looks ok though.... Anything else to look at?
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Oracle Database
--
Questions
--
Followers
Top Experts
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.