My mistake. The parameter is audit_file_dest, which is the location where audit files are written if audit_trail=os. By default audit_file_dest is $ORACLE_HOME/rdbms/audit. I suspect audit_file_dest is explicitly set to another location which either doesn't exist or lacks proper permissions.
Suzy Vordos wrote: > > Check your init.ora for the audit_trail parameter. It's probably set to > write a file to a location that either doesn't exist or lacks proper > permissions. > > > Webber Valerie H wrote: > > > > I have a 8.1.7 repository database for Designer 9i (client) running on > > SUN Solaris 8. I can start the database up but when I access the data > > via Designer it crashes. I try to start it back up and I get the > > following message > > > > ORA-09925: Unable to create audit trail file > > SVR4 Error: 6: No such device or address > > Additional information: 9925 > > > > This happens even after I have removed all of the .aud files from > > $ORACLE_HOME/rdbms/audit. > > > > Can anyone give me some clues as to what the problem might be? How do > > you determine whether it's a hardware problem or a database problem. I > > have checked everything I know to check as far as the database is > > concerned. Nothing major has changed on this system since or before > > this started. > > > > I think its a hardware problem (controller/buffer cache/data block ?) > > because after my database crashes the UNIX system doesn't work > > properly. For example, sometimes I can't even do a ps -ef or cat/more > > a file. The SA can't reboot the system without flipping the switch but > > still thinks its a database problem. Once the SA flips the switch > > (fsck runs fine) then I can start the database. The UNIX system has > > hung on one occasion with the database shutdown. It also happened once > > in the middle of a cold backup of the database. > > > > Thanks in advance! > > Val > > > > Valerie H. Webber > > Management Systems Designers, Inc > > Database Administrator > > [EMAIL PROTECTED] > > 704-566-5321 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
