One thing to try is set audit_trail=none in init.ora, then bounce the instance. If the problem goes away then it's related to something gone awry in system-wide auditing.
Check for errors in the alert.log and for trace files in the *_dump_dest directories. In sqlplus do 'show paramter audit' to verify what directory audit_file_dest uses, and do an 'ls -ld' on that directory to verify ownership and permissions. > Webber Valerie H wrote: > > Yes, you're correct and it can write the file to > $ORACLE_HOME/rdbms/audit once the system is rebooted. Its just that > when the database crashes, it can't write to that location until its > rebooted. > > Is it possible that I need to beef up my init.ora parameters? Can low > system/database resources make the system crash like this and make the > system lose track of UNIX commands and/or file directories? I might > add that there are 2 disks on this box and the Oracle server software > is located on the same disk as root but a different slice. > > thanks for the reply > Val > > -----Original Message----- > From: Suzy Vordos [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 02, 2003 4:59 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Database/system Crashing > > 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). -- 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).
