Oracle Database Discussions

everything was alright before i accidentally delete the "TESTREPOSITORY01.DBF" inside oradata->orcl->

this is the original error occurred while starting the sql developer:

An error was encountered performing the requested operation:

ORA-01033: ORACLE initialization or shutdown in progress
01033. 00000 - "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.
Vendor code 1033




this was displayed when starting up the database..
SQL> shutdown immediate;
ORA-01109: database not open


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

Total System Global Area 612368384 bytes
Fixed Size 1292036 bytes
Variable Size 511707388 bytes
Database Buffers 92274688 bytes
Redo Buffers 7094272 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TESTREPOSITORY01.DBF'



now, when i try to start the sql developer or isqlplus..error occurs saying "ERROR - ORA-01033: ORACLE initialization or shutdown in progress"

please help me...
hoping to get best solution..