Ora-09925 Unable To Create Audit Trail File Linux Error 30
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 ora-09925 unable to create audit trail file 12c enter a title. You can not post a blank message. Please type
Ora-09925 Unable To Create Audit Trail File No Such File Or Directory
your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived
Ora-09925 Unable To Create Audit Trail File 11gr2
7 Replies Latest reply 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
Ora-09925 Ora-01075
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 ora-09925: unable to create audit trail file linux-x86_64 error: 28: no space left on device 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 advance I have the same question Show 0 Likes(0) 38435Views 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 informat
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 About Us Learn more about Stack Overflow the company ora-09925 unable to create audit trail file ora-01075 you are currently logged on Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags ora-09925 read-only file system Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve ora-09925 unable to create audit trail file asm their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up https://community.oracle.com/thread/2328919 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: 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 http://dba.stackexchange.com/questions/9923/ora-09925-unable-to-create-audit-trail-file 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
Unix/Linux Problem: I get the ORA-09925 error when trying to log on to SQL*Plus: https://prevexp.wordpress.com/2014/12/09/how-to-resolve-ora-09925/ 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 Diagnose: ORACLE was unable to not able to create the file being 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 unable to create 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 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/ad