Oracle-12c
ORA-00823: sga_target 的指定值大於 sga_max_size dba
我正在對我的數據庫進行修改,而我不應該做得很好,我收到以下錯誤:
SQL> startup ORA-00823: Specified value of sga_target greater than sga_max_size ORA-01078: failure in processing system parameters
如何解決?
我解決瞭如下:
- 打開pfile並設置
sga_target=0
並保存。- 後 :
create spfile from pfile; create pfile from spfile;
- 現在啟動數據庫:
SQL> startup ORACLE instance started. Total System Global Area 5133828096 bytes Fixed Size 8929496 bytes Variable Size 956305192 bytes Database Buffers 4160749568 bytes Redo Buffers 7843840 bytes Database mounted. Database opened.