ORA-01219:database not open:queries allowed on fixed tables/views only

username  sys
password   sa
String    orcl as sysdba

SQL> select open_mode from v$database;
OPEN_MODE
----------
MOUNTED
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/data/app/oradata/ora237/users01.dbf'

SQL> alter database datafile '/data/app/oradata/ora237/users01.dbf' offline drop;
Database altered.
SQL> alter database open;
Database altered.
SQL>

Error Id: ORA-01110

Title: data file string: ’string’

Description:

data file string: ’string’

Action:

See associated error message

Cause:

Reporting file name for details of another error

Error Id: ORA-01157

Title: cannot identify/lock data file string - see DBWR trace file

Description:

cannot identify/lock data file string - see DBWR trace file

Action:

Have operating system make file available to database. Then either open the database or do ALTER SYSTEM CHECK DATAFILES.

Cause:

The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified.

Error Id: ORA-01219

Title: database not open: queries allowed on fixed tables/views only

Description:

database not open: queries allowed on fixed tables/views only

Action:

Re-phrase the query to include only fixed objects, or open the database.

Cause:

A query was issued against an object not recognized as a fixed table or fixed view before the database has been opened.

-- 来自：