ORA-27102: out of memory, Linux Error: 12: Cannot allocate memory
Hi Guys,
I am trying to adjust the pga_aggregate_target, sga_max_size and sga_target parameters (Oracle DB 10g, R2) to make use of the
4GB Ram available on my test server (Centos - Linux Kernel 4, 32 Bit).
I am trying to split 1 GB for OS and the 3GB to Oracle (1 GB PGA and 2 GB SGA).
I have increased the shmmax parameter to 3GB following some of the notes.
I can change the PGA and sga_max_size size parameters and re-start the db without any problem.
But If Change the sga_target to any value > 1GB, I get the following error when I restart the DB
I am trying to adjust the pga_aggregate_target, sga_max_size and sga_target parameters (Oracle DB 10g, R2) to make use of the
4GB Ram available on my test server (Centos - Linux Kernel 4, 32 Bit).
I am trying to split 1 GB for OS and the 3GB to Oracle (1 GB PGA and 2 GB SGA).
I have increased the shmmax parameter to 3GB following some of the notes.
I can change the PGA and sga_max_size size parameters and re-start the db without any problem.
But If Change the sga_target to any value > 1GB, I get the following error when I restart the DB
0