3 Ekim 2018 Çarşamba

ORA-00849 Error during setting AMM (Automatic Memory Management) off

Environment:

  •  Oracle EL 6.9 
  • Oracle 11.2.0.4 
After deciding to turn AMM (Automatic Memory Management) off and to use ASMM (Automatic Shared Memory Management), i have set params as:

SQL> alter system set pga_aggregage_target=20G sid='*' scope=spfile;
SQL> alter system set sga_target=128G sid='*' scope=spfile;
SQL> alter system set sga_max_size=150G sid='*' scope=spfile;
SQL> alter system set memory_target=0 sid='*' scope=spfile;
SQL> alter system set memory_max_target=0 sid='*' scope=spfile;


However after stop of database node starting process failed with:


SQL> startup
ORA-01078: failure in processing system parameters
ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account
ORA-00849: SGA_TARGET 161061273600 cannot be set to more than MEMORY_MAX_TARGET 0.

Instead of setting 0 for params resetting solves this problem:

SQL> alter system reset memory_target sid='*' scope=spfile;
SQL> alter system reset memory_max_target sid='*' scope=spfile;


SQL> startup
ORACLE instance started.

Total System Global Area 1,6034E+11 bytes
Fixed Size      2261848 bytes
Variable Size   5,1003E+10 bytes
Database Buffers  1,0898E+11 bytes
Redo Buffers    352444416 bytes
Database mounted.
Database opened.
SQL> show parameter sga

NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
lock_sga        boolean  FALSE
pre_page_sga        boolean  FALSE
sga_max_size        big integer 150G
sga_target        big integer 128G
SQL> show parameter pga

NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target       big integer 20G
SQL> show parameter memory

NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address      integer  0
memory_max_target       big integer 0
memory_target        big integer 0
shared_memory_address       integer  0
SQL>

Hiç yorum yok:

Yorum Gönder