Oracle-12c

ORA-00823: sga_target 的指定值大於 sga_max_size dba

  • September 12, 2020

我正在對我的數據庫進行修改,而我不應該做得很好,我收到以下錯誤:

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.

引用自:https://dba.stackexchange.com/questions/251208