I have powerful machine with 70 GB RAM. I created one Oracle instance with 20 GB as sga_target. I am not able to create another Oracle instance with sga_target > 10G
even when I keep the first database down. If I set sga_target >=10G
it gives below error on startup:
ORA-27104: system-defined limits for shared memory was misconfigured
While free -m
shows that there is enough memeory available though:
total used free shared buffers cached
Mem: 72419 34490 37928 0 618 28159
-/+ buffers/cache: 5711 66707
Swap: 2047 0 2047
Do I need to increase swap space? Any pointer in this regard is highly appreciated.
Also for 70 GB memory, for creating many instances, what would be best value for swap space - is there some way to caluculate this? My objective is to have at least two instances each with sga_target=20G
and will keep only one instance up at a time. If I am missing any concept here?
Output of ipcs -im
is as below
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 4194303
max total shared memory (kbytes) = 8388608
min seg size (bytes) = 1