Re: Database/system Crashing

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:lvordos_at_qwest.com]
> 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
> > > 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: 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).