Oracle-L: Database/system Crashing

From: Webber Valerie H <Valerie.H.Webber_at_irs.gov>
Date: Thu, 02 Jan 2003 11:45:17 -0800
Message-ID: <F001.00525FAD.20030102114517@fatcity.com>

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: Webber Valerie H
INET: Valerie.H.Webber_at_irs.gov

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). Received on Thu Jan 02 2003 - 13:45:17 CST