Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-01033 oracle initialization or shutdown in progress

1034179Dec 1 2013 — edited Dec 1 2013

hii all,

i am using oracle 11g in windows 7..it was working fine but today when i started im getting ora-01033 oracle initialization or shutdown in progress  error.

i tried the below method

SQL> connect / as sysdba

SQL> shutdown abort

SQL> startup nomount

SQL> alter database mount;

SQL> alter database open;

when i tried the last query alter database open im getting the following errors

ora-01115 : IO ERROR READING BLOCK FROM FILE 2 (BLOCK #  60146)

ORA-01110: DATA FILE 2 : 'C\APP\USER\ORADATA\ORCL\SYSAUX01.DBF'

ORA-27070:ASYNC READ/WRITE FAILED

ORA-04016: ERROR QUEING AN ASYNCHRONOUS I/O REQUEST

O/S ERROR:(OS 1117) THE REQUEST COULD NOT BE PERFORMED BECAUSE OF AN I/O DEVICE ERROR.

can anyone please provide me a solution for this..

Thank u in advance

Regards

Murali

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2013
Added on Dec 1 2013
5 comments
1,492 views