ora-01219:database not open:queries allowed on fixed tables/views only
“ora-01219:数据库未打开:仅允许在固定表/视图中查询”的警告窗口!
解决办法:
登录oracle sql*plus
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'
这里就是讲'/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.
---------------------------------------------------------------------------------------
oracle数据库出现了ora-01033:oracle initialization
在orcl数据库下
进入cmd已dba用户登录,命令是:sqlplus /nolog
sql>connect sys/kucun as sysdba
sql>shutdown immediate
sql>startup mount
sql>alter database open;
提示,ora-01113:文件9需要介质回复,ora-01110:数据文件'd:\oracle\oradata\kucun\users01.dbf'
alter database datafile 9 offline drop;
shutdown normal
startup mount