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 , ORA-01113

496575Mar 2 2008 — edited Mar 2 2008

I got the following error while trying to log in to Oracle SQL plus
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

I tried the following and here's what i got. Could you please help me rectify this error.
SQL> connect sys/manager as sysdba
Connected.
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
ORA-01109: database not open

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

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: 'C:\ORACLE\ORADATA\AMINA\XDB01.DBF'

Thanks,
Amina

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2008

Added on Mar 2 2008

#general-database-discussions

1 comment

701 views