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.
Please check the alert file and post the message in alert 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.
Mount the database and drop the datafile using
alter database datafile '<<file_name>>' offline drop;
and then open the database
alter database open;
Thanks..I am in now.
Check the tablespaces that was created on that dropped file.
You still need to to "drop tablespace <name> including contents;" after the "alter database open"
Hi, as stated that the data file is locked, is it possible to unlock the file?
Can you post complete error ?
Have you seen that the thread was more than one years old.
Please create your own thread with a little bit more explanation about your problem.
I didn't notice. about thread date...
anyway this thread again remember your 'BETWEEN DATE QUERY".;-)
any way to correct 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.
Have you read the last post of Nicolas?
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.