Re: Help? Oracle Error

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 19 Jan 2001 12:26:29 -0000
Message-ID: <949bpn$ud$1@soap.pipex.net>

The key part of the trace is this:

"Jennmar Corp" <here_at_work.com> wrote in message news:t6e5i44skdon6e_at_corp.supernews.com...
> The entries were as follows.
>
> orclPMON.trc

<snip>
> ORA-00471: DBWR process terminated with error

and

>
> orclDBWR.trc
> KCF: write/open error block=0x2a online=1
> file=2 F:\ORANT\DATABASE\RBS1ORCL.ORA
> error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to
> file
> O/S-Error: (OS 33) The process cannot access the file because
> another process has locked a portion of the file.'
<snip>

In other words the database file referred to cannot be written to. This could be because, as the message suggests the file is open by some other process (a backup or defrag program maybe), or less likely because the oracle account doesn't have permissions on the file.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK



> > "Jennmar Corp" <here_at_work.com> wrote in message

> > news:t6bauuqmhn9s64_at_corp.supernews.com...

> > > Help!

> > >

> > > I have just started to work with Oracle so I am lost as to where to

 look
 for


> > > the source of our problem...

> > > We have been getting random PMON errors - Oracle terminated with

 error.


> > > Rebooting our server has fixed the problem thus far but I have not

 been
 able


> > > to determine what is causing it.

> > > We have entries in our trace file but I am not sure what they are

 referring


> > > to???

> > >

> > > If anyone can offer advice on where to look to fix this - I would

 appreciate


> > > it!

> > >

> > > Thanks!

> > >

> > >

> >

> >

>

>

Received on Fri Jan 19 2001 - 06:26:29 CST