Q

ORA-01033 error after UPS failure with Oracle 10g

Recently my machine got shut down from a UPS failure when I was in the middle of a transaction with Oracle 10g. When I restarted my machine and tried to log in, I got the "ORA-01033: Initialization or shut down in progress" error.

Recently my machine got shut down because of some UPS failure, when I was in the middle of a transaction with Oracle

10g. And when I restarted my machine and tried to log in, I got the "ORA-01033: Initialization or shut down in progress" error.

I googled regarding this and followed the steps given in the following sites ("Oracle Error and how to fix it (ORA-01033)" and "Getting ORA-01033 when logging in to 9i application") but nothing seems to be working!

This is my SQL trace when I tried to shut down and restart:

SQL> SHUTDOWN
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145488364 bytes
Database Buffers           25165824 bytes
Redo Buffers                 524288 bytes
Database mounted.
ORA-01115: IO error reading block from file 4 (block # 59449)
ORA-01110: data file 4: 
'D:DATABASESORACLE10GORADATAQRULESUSERS01.DBF'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 23) Data error (cyclic redundancy check).

SQL>

I absolutely have no idea what this says!

Can someone please let me know what exactly is happening here?? Thanks in advance!

The ORA-01115 error is telling me that your operating system cannot read the file indicated by the ORA-01110 error. This is a hardware problem which Oracle cannot get around. The first thing I would do is to verify that I can read and write to files on the D: drive of your server. Then, I would verify that Oracle has read and write permissions to this file. If all of these pass, it is possible that the file is corrupt and you will have to restore the file from a previous backup.
This was first published in July 2007

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close