RE: Database/system Crashing

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-----
Sent: Thursday, January 02, 2003 4:59 PM To: Multiple recipients of list ORACLE-L

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


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