sql - Oracle Shutdown error ORA-01033

Question

I had installed Oracle 11g on windows 07,everything was working fine.But today it is giving me an error saaying ORA-01033: ORACLE initialization or shutdown in progress . I followed the steps mentioned in the different communities but unable to solve the error. After connecting as sqlplus sys/sys as sysdba. and executing below statement,i got following error. How to solve this error?

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 9: 'C:APPMKHATALORADATAORCLVELODBDATA.DBF'
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: 'C:APPMKHATALORADATAORCLVELODBDATA.DBF'

Thanks in advance!!

Answer 1

First, check your ALERT.LOG file typically located in D:apporaclediag dbmsDBNAMESIDrace.

The latest entries in your ALERT.LOG should give you an indication on what is going on. Is the database starting? Shutting down?

Should the database be stuck in the shutdown process, you can try to kill the oracle.exe process and then restart the database via Windows Service.

Often, when the database seems to hang on startup, it is actually applying REDO to get a consistent state, so pay close attention on what the ALERT.LOG tells you.