1 Reply Latest reply on Aug 2, 2016 2:26 AM by Beauty_and_dBest

    Why Swap is not used?

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.1.3

      OL6

      11gR1

       

       

      We have PROD and DEV on the same machine.

       

       

      When I start DEV, I got memory error

       

      Starting the database DEV ...

       

      SQL*Plus: Release 11.1.0.7.0 - Production on Tue Aug 2 09:09:51 2016

      Copyright (c) 1982, 2008, Oracle.  All rights reserved.

      Connected to an idle instance.

      ORA-27102: out of memory

      Linux-x86_64 Error: 28: No space left on device

       

       

      But when I monitor TOP, I can see that my swap space is not used.

       

      Capture.GIF

       

       

      Please help...

       

       

      Kind regards,

      jc

        • 1. Re: Why Swap is not used?
          Beauty_and_dBest

          I got this in google:

           

          ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device

          Solution:

          Check the page size:
          #getconf PAGE_SIZE
          4096

          Calculate proper value for shmall:

          The value of shmall should be:

          Shmall=total size of the SGAs on the system/page size.

          Let’s assume the size of the SGA is 16GB in the system then it would be 1024 * 1024 * 1024 * 16 / 4096 = 4194304

          Change shmall in /etc/sysctl.conf
          vi /etc/sysctl.conf  

          kernel.shmall = 4194304

          Apply the changes:

          # sysctl -p 

          check shmall value after change
          # sysctl -A | grep shmall

          Start the database
          # su - oracle
          # sqlplus sys as sysdba
          SQL> startup