Re: Shutdown/Restart ORA-01033 and IO Errors

Oracle on windows can be tricky. Have you started it as the oracle user or a member of the DBA group? The key here looks like your error is trying to say it can't write to the file as the person below stated. Either the file is not there, owned by another user, or corrupt (disk issue?). Let us know if the file exists and if it is owned by the wrong user or has incorrect permissions.

> > Errors in file D:\oradata\pcpw\LOG\pcpwLGWR.TRC:
> > ORA-01110: data file 12: 'D:\ORADATA\DBNAME\DBNAME.DBF'
> > ORA-01114: IO error writing block to file 12 (block # 1)
> > ORA-27072: skgfdisp: I/O error
> > OSD-04008: WriteFile() failure, unable to write to file
> > O/S-Error: (OS 5) Access is denied.
> >

The last error says it cannot access the file, try to figure that issue out. also, read D:\oradata\pcpw\LOG\pcpwLGWR.TRC and see if it gives you a clue. Make sure the controlfile in the init<DBNAME>.ora exists and make sure the controlfiles exist. The reason I say that is because 'D:\ORADATA\DBNAME\DBNAME.DBF' looks strange. Is DBNAME\DBNAME something you changed before posting or is it something odd oracle is picking up from somewhere? I hope you changed that before posting : ) I would love to dole out advise but if this is anything other than a sandbox DB, you need to contact oracle.
Charles Hooper wrote:
> Tam OShanter wrote:
> > Hello Friends,
> >
> > I have inherited a vendor supported database.
> > Environment is :
> >
> > ORACLE V8.1.7.4.1 - Production vsnsta=0
> > vsnsql=f vsnxtr=3
> > Windows 2000 Version 5.2 Service Pack 1, CPU type 586
> >
> > The database is constantly giving me an "ORA-01033 ORACLE initialization or
> > shutdown in progress" regadless of what I try.
> >
> > The folks who turned it over to me had been trying to rectify the problem by
> > rebooting the machine repeatedly.
> >
> > I have attempted to shut it down by using oradim with the immediate option.
> > No luck.
> >
> > Upon looking in the alert log I discover the following:
> >
> >
> > Tue Nov 07 05:00:12 2006
> > alter database open
> > Tue Nov 07 05:00:13 2006
> > Errors in file D:\oradata\pcpw\LOG\pcpwLGWR.TRC:
> > ORA-01110: data file 12: 'D:\ORADATA\DBNAME\DBNAME.DBF'
> > ORA-01114: IO error writing block to file 12 (block # 1)
> > ORA-27072: skgfdisp: I/O error
> > OSD-04008: WriteFile() failure, unable to write to file
> > O/S-Error: (OS 5) Access is denied.
> >
> > Wondering what steps I might take to rectify this.
> >
> > Thanks in advance for your helpful advice.
> >
> >
> > Tam.
>
> Do you have a virus scanner on the server, or are you using a third
> party backup program for the Oracle database? Does this only happen
> when the database instance is started? Have you verified that file 12
> exists and that the Oracle services are set to use the Local System
> Account?
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.
Received on Wed Nov 08 2006 - 23:01:03 CST