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).
