This content has been marked as final. Show 25 replies
It may be the case, the database did not stop correctly.
Try out following.
Open Dos command Prompt
c:> sqlplus /nolog
sql> connect sys/manager as sysdba
While startup it may show error message like some of the parameter is missing. Note down that parameter and update in initSID.ora file.
SQL> connect sys/manager as sysdba
SQL> shutdown immediate;
ORA-01109: database not open
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145750508 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'C:\ORADATA\PRODUCT_DAT1.DBF'
I now realized what happened and how this happened. It's all my fault. During a clean-up effort this file was accidentally deleted. I have no backups too.
I am willing to lose the data in this datafile. Is there something I can do so that the startup does not try to open this file ?
All I am able to do now is to mount the database but not open it.
you better start your own thread instead of appending on a more than two years old post. When you post please also include your Oracle version and OS and a brief description of how you got the error.
You need to make sure your database is up and running.
ORA-01033: ORACLE initialization or shutdown in progress
Cause: An attempt was made to log on while Oracle is being started up or shutdown.
Action: Wait a few minutes. Then retry the operation.
The steps provided by you were very helpful.
Basically there was no space in my root partition.
So I tried to free up those space, thinking that with this I may be able to access database using sqlplus. But still faced the same error.
So jst followed ur step of accessing as "sqlplus /nolog" and performed the steps mentioned.
The database got started without any error.