Ora-09925 Unable To Create Audit Trail File Linux Error 2
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please ora-09925: unable to create audit trail file 12c type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database linux-x86_64 error: 30: read-only file system Discussions This discussion is archived 7 Replies Latest reply on Feb 7, 2013 3:26 PM by Nicolas.Gasparotto ORA-09925: Unable to create
Ora-09925 Unable To Create Audit Trail File 11gr2
audit trail file 894623 Dec 28, 2011 11:48 PM Hi, Im using oracle 11.1.0.6.0 db, on Linux 64 bit server on Amazon cloud. im getting following error when i run the connect command SQL> connect /
Ora-09925 Ora-01075
as sysdba ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 30: Read-only file system Additional information: 9925 ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 30: Read-only file system Additional information: 9925 when i run this df -h command im not seeing the file system it's jst showing as below $ df -h Filesystem Size Used Avail Use% Mounted on I donot understand cause of this issue. Please ora-09925: unable to create audit trail file linux-x86_64 error: 28: no space left on device let me know how to solve this issue Thanks in advance I have the same question Show 0 Likes(0) 38431Views Tags: none (add) 11gContent tagged with 11g, 30Content tagged with 30, errorContent tagged with error, fileContent tagged with file, linux-x86_64Content tagged with linux-x86_64, oracleContent tagged with oracle, read-onlyContent tagged with read-only, systemContent tagged with system This content has been marked as final. Show 7 replies 1. Re: ORA-09925: Unable to create audit trail file sb92075 Dec 28, 2011 11:55 PM (in response to 894623) praveenb wrote: Hi, Im using oracle 11.1.0.6.0 db, on Linux 64 bit server on Amazon cloud. im getting following error when i run the connect command SQL> connect / as sysdba ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 30: Read-only file system Additional information: 9925 ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 30: Read-only file system Additional information: 9925 when i run this df -h command im not seeing the file system it's jst showing as below $ df -h Filesystem Size Used Avail Use% Mounted on I donot understand cause of this issue. Please let me know how to solve this issue Thanks in advanceSQL> show parameter audit NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_file_dest string /u01/app/oracle/admin/v112/adu mp audit_sys_operations boolean F
Unix/Linux Problem: I get the ORA-09925 error when trying to log on to SQL*Plus:
Ora-09925 Unable To Create Audit Trail File Ora-01075 You Are Currently Logged On
ERROR: ORA-09925: Unable to create audit ora-09925 read-only file system trail file Linux-x86_64 Error: 2: No such file or directory ora-09925: unable to create audit trail file asm Additional information: 9925 ORA-01075: you are currently logged on Diagnose: ORACLE was not able to create the file being https://community.oracle.com/thread/2328919 used to hold audit trail records. that could be becaouse of 1) AUDIT_FILE_DEST is not writable 2) $ORACLE_BASE/admin/$ORACLE_SID/adump exists and is not writable 3) $ORACLE_HOME/rdbms/audit is not writable Solution: 1) AUDIT_FILE_DEST is not writable $ env _=/usr/bin/env ORACLE_SID=FOO TERM=dtterm ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_3 PWD=/u01/app/oracle/product/10.2.0/db_3 $ $ORACLE_HOME/bin/sqlplus -L "/ as sysdba" SQL> startup https://prevexp.wordpress.com/2014/12/09/how-to-resolve-ora-09925/ ORA-09925: Unable to create audit trail file Linux Error: 2: No such file or directory Additional information: 9925 ORA-01075: you are currently logged on $ grep -i audit_file_dest $ORACLE_HOME/dbs/*$ORACLE_SID.ora audit_file_dest=/u01/app/oracle/admin/orcl/adump $ ls -lad /u01/app/oracle/admin/orcl/adump /u01/app/oracle/admin/orcl/adump not found $ mkdir -p /u01/app/oracle/admin/orcl/adump $ $ORACLE_HOME/bin/sqlplus -L "/ as sysdba" SQL> startup nomount ORACLE instance started. SQL> shutdown normal ORACLE instance shut down. 2) $ORACLE_BASE/admin/$ORACLE_SID/adump exists and is not writable $ ls -ltr $ORACLE_BASE/admin/$ORACLE_SID dr-xr-xr-x. 2 oracle oinstall 4096 Dec 9 14:15 adump/ $ $ORACLE_HOME/bin/sqlplus -L "/ as sysdba" SQL*Plus: Release 10.2.0.3.0 - Production on Mon Dec 17 09:02:29 2007 Copyright (c) 1982, 2006, 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 $ chmod +w /u01/app/oracle/admin/orcl/adump $ $ORACLE_HOME/bin/sqlplus -L "/ as sysdba" SQL*Plus: Release 10.2.0.3.0 - Production on Mon Dec 17 09:02:48 2007 Copyright (c) 1982, 2
export ORACLE_SID=test [oracle@ora11gr2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr http://afatkulin.blogspot.com/2012/04/ora-09925-unable-to-create-audit-trail.html 30 17:09:31 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> exit Disconnected I have no instance named test running on the box and get the expected behavior. Now let's continue: [oracle@ora11gr2 ~]$ touch /tmp/test [oracle@ora11gr2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr unable to 30 17:10:54 2012 Copyright (c) 1982, 2011, 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-09925: Unable to create audit trail file Linux-x86_64 Error: 2: No such file or directory Additional information: 9925 The only thing I changed is unable to create created an empty file /tmp/test and suddenly I'm getting some "ORA-09925: Unable to create audit trail file" errors? What's going on? If we strace SQL*Plus we would see the following: 3798 stat("/u01/app/oracle/admin/test/adump", 0x7fff1a8b5bd0) = -1 ENOENT (No such file or directory) 3798 access("/tmp/test", F_OK) = 0 3798 open("/u01/app/oracle/product/11.2.0/dbhome_2/rdbms/audit//tmp/test_ora_3798_1.aud", O_RDWR|O_CREAT|O_EXCL, 0660) = -1 ENOENT (No such file or directory) The first command checks for audit file directory in a default location. However, the second pair of commands does something strange. It tests whether file /tmp/test exists and if it does it tries to open an audit trace file under a really weird path. But where does this path comes from? If I look at my environment variables: [oracle@ora11gr2 ~]$ env | grep /tmp ORACLE_PATH=/tmp Apparently I have some strange ORACLE_PATH variable set. What if I unset it? [oracle@ora11gr2 ~]$ unset ORACLE_PATH [oracle@ora11gr2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 30 17:22:27 2012 Copyright (c) 1982, 2011, Oracle