RE: Database/system Crashing

[Stephen Lee]

Title: RE: Database/system Crashing

If the database has data files on NFS mounts, then any network problems or problems on the NFS server can crash things.  Disappearing NFS mounts can be very nasty.  That's why it's a big no-no to put ANY files related to the database -- data files, log files, oracle binaries, etc. -- on NFS mounts.

-----Original Message-----
From: Webber Valerie H [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Database/system Crashing

Yes there are NFS mounts involved. What you said about the OS locks on the audit directory makes a lot of sense. My SA's are back to thinking it's a OS problem because it crashed again with the database shut down.

The odd thing is that there is nothing written to the Oracle alert log file nor are there any entries in the trace files. But when the system is rebooted and I bring the db back up, Oracle knows it previously crashed and recovers itself. That's in the alert log file. Its like the system is losing its pointers or something. I suggested reinstalling the OS and Oracle then put my database back and see if that helps. Are there huge risks with this scenario?

Another odd thing that the SA's can't figure out is there are no entries in the message file nor can they get a dump file to determine why the system crashed. There is nothing. It crashed over the weekend with no activity and they got some sort of i-nodes error.

Thanks for all your replies. Any ideas are helpful and I will relay them to our SA's...

Val

-----Original Message-----
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Database/system Crashing

I wonder if a file lock is being left in place when the instance crashes,
and the OS does not clear the lock until a reboot.  I would think the OS
should clear this without a reboot, but stranger things have been seen with
OS's ... even Unix.  This doesn't explain why the instance crashes.  I
wonder if fuser would show anything.  Are there any NFS mounts involved?

-----Original Message-----
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?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
  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).