Ask the Expert

ORA-01033 error after UPS failure with Oracle 10g

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!

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: