ORA-01219: database not open: queries allowed on fixed tables/views only
So I did the following steps from command prompt:
Expand|Select|Wrap|Line Numbers
- C:\>sqlplus
- SQL*Plus: Release 10.2.0.3.0 - Production on Thu Jul 7 10:49:58 2011
- Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
- Enter user-name: / as sysdba
- Connected to:
- Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
- With the Partitioning, OLAP and Data Mining options
- SQL> shutdown abort
- ORACLE instance shut down.
- SQL> startup
- ORACLE instance started.
- Total System Global Area 251658240 bytes
- Fixed Size 1289964 bytes
- Variable Size 163578132 bytes
- Database Buffers 79691776 bytes
- Redo Buffers 7098368 bytes
- Database mounted.
- ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
- ORA-01110: data file 7: 'C:\ORACLE\TABLE_SPACES\SWT_TBLSPC'
- SQL> select * from dba_users;
- select * from dba_users
- *
- ERROR at line 1:
- ORA-01219: database not open: queries allowed on fixed tables/views only
- SQL> select open_mode from v$database;
- OPEN_MODE
- ----------
- MOUNTED
Expand|Select|Wrap|Line Numbers
- SQL> alter database open;
- alter database open
- *
- ERROR at line 1:
- ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
- ORA-01110: data file 7: 'C:\ORACLE\TABLE_SPACES\SWT_TBLSPC'
Expand|Select|Wrap|Line Numbers
- SQL> recover database until cancel;
- ORA-00283: recovery session canceled due to errors
- ORA-01110: data file 7: 'C:\ORACLE\TABLE_SPACES\SWT_TBLSPC'
- ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
- ORA-01110: data file 7: 'C:\ORACLE\TABLE_SPACES\SWT_TBLSPC'
may someone explaine and fix this problem?
regards
Osman