Re: Shutdown/Restart ORA-01033 and IO Errors

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 - 18:46:13 CST