Re: Instance Terminated Problem

My first thought is that someone physically deleted the database files. This would cause an error in the running processes. Not sure what the error 340 is. Did the database files actually disappear? If so, check the history file (if unix) of the Oracle user. This will show you commands issued by the Oracle user - who should be the only user able to do this type of thing with the exception of root!? I have never heard of an Oracle instance "disappearing" in my 16 years of working with Oracle. Unless this is a very strange situation, you may have some sabatoge or very inexperienced person that caused this.

Interesting. Let us know what actually happened here.

Melanie

Calvin Lim <calvin-lim_at_mediaring.com> on 05/23/2000 01:20:37 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: Instance Terminated Problem

Hi,

I got up this morning only to find out that one of our 8.1.5 instances had mysteriously "gone away". Only trace of why the instance died are these 3 lines in the alert log in bdump.

Anybody got ideas what went wrong? Thanks.

>Tue May 23 03:17:15 2000
>LGWR: terminating instance due to error 340
>Instance terminated by LGWR, pid = 510

Regards,
Calvin

--
Author: Calvin Lim
  INET: calvin-lim_at_mediaring.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).






----------------------------------------------------------------
      The information transmitted is intended only for the person or entity to
      which it is addressed and may contain confidential and/or privileged
      material.  Any review, retransmission, dissemination or other use of, or
      taking of any action in reliance upon, this information by persons or
      entities other than the intended recipient is prohibited.   If you
      received this in error, please contact the sender and delete the material