Error Ora-09925 Unable To Create Audit Trail File
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. ora-09925 unable to create audit trail file no such file or directory You can not post a blank message. Please type your message and try linux-x86_64 error: 30: read-only file system again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 7 Replies Latest reply
Ora-09925 Unable To Create Audit Trail File 11gr2
on Feb 7, 2013 3:26 PM by Nicolas.Gasparotto ORA-09925: Unable to create audit trail file 894623 Dec 28, 2011 11:48 PM Hi, Im using oracle 11.1.0.6.0 db, on Linux 64 bit
Ora-09925: Unable To Create Audit Trail File Asm
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 ora-09925 ora-01075 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 advance I have the same question Show 0 Likes(0) 37907Views 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 s
Metalink, [edit]which is now up to date for 10gR2[/edit]. 1)
Ora-09925: Unable To Create Audit Trail File Linux-x86_64 Error: 28: No Space Left On Device
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 ora-09925 read-only file system PWD=/u01/app/oracle/product/10.2.0/db_3 $ $ORACLE_HOME/bin/sqlplus -L "/ as sysdba" SQL> startup ORA-09925: Unable to create audit trail ora-09925 unable to create audit trail file ora-01075 you are currently logged on file IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 9925 $ grep -i audit_file_dest $ORACLE_HOME/dbs/*$ORACLE_SID.ora audit_file_dest=/bar $ ls -lad https://community.oracle.com/thread/2328919 /bar /bar not found $ su - root's Password: # mkdir /bar # exit $ $ORACLE_HOME/bin/sqlplus -L "/ as sysdba" SQL> startup ORA-09925: Unable to create audit trail file IBM AIX RISC System/6000 Error: 13: Permission denied Additional information: 9925 $ su - root's Password: # chown oracle /bar # http://laurentschneider.com/wordpress/2007/12/how-to-resolve-ora-09925.html exit $ $ORACLE_HOME/bin/sqlplus -L "/ as sysdba" SQL> startup quiet nomount ORACLE instance started. SQL> shutdown abort ORACLE instance shut down. 2) $ORACLE_BASE/admin/$ORACLE_SID/adump exists and is not writable ❗ $ ls -lad $ORACLE_BASE/admin/$ORACLE_SID/adump drwxr-xr-x 2 root dba .../admin/FOO/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 IBM AIX RISC System/6000 Error: 13: Permission denied Additional information: 9925 ORA-09925: Unable to create audit trail file IBM AIX RISC System/6000 Error: 13: Permission denied Additional information: 9925 SP2-0751: Unable to connect to Oracle.Exiting SQL*Plus $ su - root's Password: # chown oracle /bar/admin/FOO/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, 2006, Oracle.All Rights Reserved. Connected to an idle instance. SQL> quit 3) $ORAC
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site http://dba.stackexchange.com/questions/9923/ora-09925-unable-to-create-audit-trail-file About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign unable to up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ORA-09925: Unable to create audit trail file up vote 2 down vote favorite I'm using Oracle 11.1.0.6.0 db, on Linux 64 bit server on Amazon cloud. I'm getting following error when I run the connect command SQL> connect / as sysdba ERROR: unable to create 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 I'm not seeing the file system it's just showing as below $ df -h Filesystem Size Used Avail Use% Mounted on I do not understand cause of this issue. Please let me know how to solve this issue oracle audit share|improve this question edited Jan 4 '12 at 7:59 Sathya 98431333 asked Dec 29 '11 at 17:51 praveenb 111113 1 Seems that the filesystem on which the database is installed is readonly.? –Benoit Dec 21 '11 at 16:09 Please update with output of mount (edit your question if possible) –kubanczyk Dec 29 '11 at 23:00 add a comment| 4 Answers 4 active oldest votes up vote 3 down vote Try this: connect to SQL*Plus, then do: show parameter audit_file_dest then exit SQL*Plus and do: cd