1 Reply Latest reply: Feb 14, 2013 2:17 AM by Helios-GunesEROL RSS

    SGA size can not be greater than maximum shared memory segment size

    okKarol
      Hello Dear's

      I've this issue which is not quite logical ,
      Platform:
      Linux UBUNTU 12.4
      Oracle 11g2

      Kernel Parameters from sysctl

      fs.aio-max-nr = 1048576
      fs.file-max = 6815744
      kernel.shmall = 2097152
      #kernel.shmmax = 536870912
      kernel.shmmax = 2147483648 >>>>> I put the Max Value
      kernel.shmmni = 4096
      kernel.sem = 250 32000 100 128
      net.ipv4.ip_local_port_range = 9000 65500
      net.core.rmem_default = 262144
      net.core.rmem_max = 4194304
      net.core.wmem_default = 262144
      net.core.wmem_max = 1048576

      BUT:
      When Creating a Database using DBCA when choosing the Memory Type (AMM) or custom (Manually Shared Memory management) ... If I choose to configure Manually,
      I define the following Values:
      SGA 8Gb,
      BuFFER Cache = 4Gb

      Just this values are enough to get that warning message "SGA size can not be greater than maximum shared memory segment size"
      But If instead, I configure 32Gb using AMM Type it dosn't give me any warning !!!!!
      Which makes me think ... something is wrong
      Any Help ?
      Thxs in advance