RE: Database shut itself down

You are most likely correct Lisa. I have never tried on NT but I have seen that error on Unix and that is one of the most likely causes is that someone has deleted the data file. I can confirm that the delete definitely works under the Unix o/s for better or worse.

-----Original Message-----
Sent: 02 April 2002 22:38
To: Multiple recipients of list ORACLE-L

I thought you couldn't delete a database file in Windows when the database is up? I have tried and tried to no avail.

Maybe this is a nice 'feature' but it doesn't leave much room for testing b&r

Lisa Koivu
Oracle Database Brick House - 36-54-36
Fairfield Resorts, Inc.
954-935-4117

> -----Original Message-----
> From: John Hallas [SMTP:john.hallas_at_hcresources.co.uk]
> Sent: Tuesday, April 02, 2002 3:53 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Database shut itself down
>
> Sorry to be the bearer of bad news
> That normally happens when someone has deleted the file by mistake.
>
> Other suggestions could be that it was being archived or locked by some
> other process which inhibited Oracle from updating the file.
>
> Has the database restarted OK.
>
> HTH
>
> John
>
> -----Original Message-----
> Dave
> Sent: 02 April 2002 20:03
> To: Multiple recipients of list ORACLE-L
>
> I have a 8.1.7 database running on NT 4.0 that had a problem this morning
> and shut itself down. In the <SID>Alert.log I have the following error.
>
> Tue Apr 02 10:47:40 2002
> KCF: write/open error block=0x21de online=1
> file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF
> error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
> file
> O/S-Error: (OS 5) Access is denied.'
> DBW0: terminating instance due to error 1242
> Instance terminated by DBW0, pid = 287
>
>
> This is a new for me. Any ideas what I am dealing with?
>
> Thanks,
>
> Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Farnsworth, Dave
> INET: DFarnsworth_at_Ashleyfurniture.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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Hallas
> INET: john.hallas_at_hcresources.co.uk
>
> 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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Koivu, Lisa
  INET: lisa.koivu_at_efairfield.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Hallas
  INET: john.hallas_at_hcresources.co.uk

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