Re: io error on alert file

Thank Jeff,
your answer is much productive than oracle support. My question is if this is permission problem, then we should have the error everyday. This error bothered us for quite a long time. sometimes can be quiet a month and happened again.

Thanks,
joan

Jeff Herrick wrote:
>
> If the W2K box was a converted NT box, I have heard of
> authentication issues within services. The credentials
> have to be re-created through the services control panel.
> The Access-denied error is usually due to a service's
> logon use not having the proper rights. If you are just
> using LocalSystem then I'm not sure this would be an issue
> butI would switch it temporarily to a user account and then
> back to LocalSystem to regenerate the security identifier.
>
> Also...check the NTFS permissions on the D: drive for who
> has write access.
>
> HTH
>
> Jeff Herrick
>
> On Thu, 5 Dec 2002, Joan Hsieh wrote:
>
> > Hi Listers,
> >
> > We had a portal database with some other schemas on the win2000 box. we
> > got error so often and needs to recover that datafile. It hits different
> > datafiles each time. We created the tar with oracle, they pointed to
> > Microsoft problem. Our nt group insisted they didn't see any error log.
> > db version is 8.1.7.2 . Since we had the problem so often, I migrated
> > the whole database and portal to UNIX box. I am curious if someone can
> > give me light why this io "access denied" comes from?
> >
> > Joan
> >
> > Completed: alter database open
> > Wed Dec 04 09:12:12 2002
> > KCF: write/open error block=0x8ba7 online=1
> > file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF
> > error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write
> > to file
> > O/S-Error: (OS 5) Access is denied.'
> > Automatic datafile offline due to write error on
> > file 14: D:\ORACLE\ORADATA\ORCL\SISDW.DBF
> > KCF: write/open error block=0x8bd6 online=0
> > file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF
> > error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write
> > to file
> > O/S-Error: (OS 5) Access is denied.'
> > KCF: write/open error block=0x8ba6 online=0
> > file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF
> > error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write
> > to file
> > O/S-Error: (OS 5) Access is denied.'
> > KCF: write/open error block=0x8d5c online=0
> > file=14 D:\ORACLE\ORADATA\ORCL\SISDW.DBF
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Joan Hsieh
> > INET: joan.hsieh_at_tufts.edu
> >
> > 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.com
> --
> Author: Jeff Herrick
> INET: jherrick_at_igs.net
>
> 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.com
-- 
Author: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

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