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

肖朋偉發表於2019-07-22

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

問:

解決 ORA-01219:database not open:queries allowed on fixed tables/views only 需要幾步?

答:

4 步

第一步:開啟 SQL Plus 連線資料庫;

第二步:嘗試執行:

alter database open;

肯定沒這麼簡單,檢視報錯,拷貝報錯檔案地址。

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

第三步:幹掉這個檔案(其實你可能沒有這個檔案):

alter database datafile '檔案地址' offline drop;

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

第四步:再次執行:

alter database open;

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

成功:

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

相關文章