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!

Unable to Start Oracle Instance in windows 7 machine

2817331Dec 18 2014 — edited Dec 21 2014

Hi Team,

I have installed oracle 11g in my windows 7 machine, which is working fine for quite sometime.

When i trying to login to oracle one fine day, am getting the below error.

ERROR:

ORA-01033: ORACLE initialization or shutdown in progress

Process ID: 0

Session ID: 0 Serial number: 0

Warning: You are no longer connected to ORACLE.

So after googling out, I could find the below one, Some genius has asked me to do shutdown and startup of oracle

But when am doing this am getting the below error,It would really help me if some one can help me in solving this issue.

C:\Users\dwbi>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 19 07:32:54 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown abort

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  778387456 bytes

Fixed Size                  1374808 bytes

Variable Size             402654632 bytes

Database Buffers          369098752 bytes

Redo Buffers                5259264 bytes

Database mounted.

ORA-01115: IO error reading block from file 2 (block # 65169)

ORA-01110: data file 2: 'E:\APP\DWBI\ORADATA\ORCL\SYSAUX01.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>

Thanks in advance...

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2015
Added on Dec 18 2014
6 comments
1,499 views