ORA-00845: MEMORY_TARGET not supported on this system
Hi everyone
We have 2 node 11.2.0.2 RAC running on Linux X_64
We have 8 GB RAM on the servers so we decided to utilize 5GB of it for Oracle
Here were our settings as related to SGA / PGA
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big integer 2656M
memory_target big integer 2656M
pga_aggregate_target big integer 0
sga_max_size big integer 2656M
sga_target big integer 2G
We changed the AMM settings as below:
SQL> alter system set memory_max_target=5120M scope=spfile sid='*';
System altered.
SQL> alter system set memory_target=4096M scope=spfile sid='*';