Re: Database/system Crashing

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
> valerie.h.webber_at_irs.gov
> 704-566-5321

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.com

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: ListGuru_at_fatcity.com (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).