Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Shutdown/Restart ORA-01033 and IO Errors

Re: Shutdown/Restart ORA-01033 and IO Errors

From: Vitaliy Vorontsov <vitaliy.vorontsov_at_gmail.com>
Date: 9 Nov 2006 02:59:25 -0800
Message-ID: <1163069965.448300.146700@m7g2000cwm.googlegroups.com>


If it wasn't a problem with access rights on dbfile then it could be the process of backup or other software accessing the file and locking it.
We had the same situation when DBW0 couldn't write to the datafile. The problem was in a backup policy in Veritas Netbackup software, because it accidentally included database file in operational systems files backup.

"""Tam OShanter ΠΙΣΑΜ(Α):
"""
> 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.
Received on Thu Nov 09 2006 - 04:59:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US