ORA-01109: Database is not openBefore doing such an operation, in Plsql created 2 table space, because the installed is the Oracle Lite version of the table space to create more than 4G can not be created, and then I manually put the table space to delete, the Recycle Bin is also deleted, the problem arises, has been reported that the database is not open.
------Solution--------------------
The cause of the above problem is mistakenly put ' F:\ORADB. DEF ' This data file deleted, this deletion is not normal, if the deletion of the user and table space, and then delete the data file should be no problem, but this time just deleted the data file, the user and table space is still there.
Workaround:
1) Mount Database:
STARTUP MOUNT;
2) OFFLINE Drop Data file:
ALTER DATABASE datafile ' <full_path_file_name> ' OFFLINE DROP;
3) Open the database:
ALTER database Open;ps: At this point, OPEN databases are OK.
4) Delete table space:
DROP tablespace <tablespace_name> including CONTENTS;
PS: If it is deleted by mistake, simply rebuild the table space.
Specific operation:
Sql> Startup Mount
ORA-01081: Unable to start ORACLE that is already running-please close it first
sql> shutdown Immediate
ORA-01109: Database is not open
The database has been uninstalled.
The ORACLE routine has been closed.
Sql> Startup Mount
The ORACLE routine has been started.
Total System Global area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database buffers 436207616 bytes
Redo buffers 7135232 bytes
The database is loaded.
sql> ALTER DATABASE DataFile ' F:\ORADB. DEF ' offline drop
2;
The database has changed.
sql> ALTER DATABASE open;
The database has changed.
Sql> drop tablespace oradb including contents;
Table space has been deleted.
------Solution--------------------
What do you do? Operation times: Always quote database not open
------Solution--------------------
Has it been solved?
------Solution--------------------
The lite version should also have an alter file? Get the contents of the alert file out.
Another: How do you manually delete the tablespace, is the direct operating system removed?
A little bit of thinking: Startup Mount;
ALTER DATABASE datafile ' offline drop;
ALTER DATABASE open;
There is a compact version of the database can not be more than 4g files? Or your disk is in fat format:
ORA-01109: Database is not open
