Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2017
    Posts
    8

    Unanswered: ORA-27102: out of memory on Linux

    Hi guys,

    I'm getting that dreaded error in the subject line.

    Here are my settings (small testing server will very low load):
    page size 4096
    memory_max_target 6G
    memory_target 600M
    kernel.shmall = 4294967296


    lock_sga boolean FALSE
    pre_page_sga boolean TRUE
    sga_max_size big integer 4G
    sga_target big integer 0


    # df -h /dev/shm
    Filesystem Size Used Avail Use% Mounted on
    tmpfs 7.0G 422M 6.6G 6% /dev/shm

    # free -m
    total used free shared buffers cached
    Mem: 8001 2448 5553 496 57 1467
    -/+ buffers/cache: 923 7078
    Swap: 1999 0 1999


    In the alert log file I see this on the last occasion when I got the error:

    Mon Jan 30 10:44:58 2017
    PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
    4K Configured 1536007 718 ORA-27102


    I have now restarted the DB, increasing the memory_target from 600M to 1G and decreasing the memory_max_target from 6G to 4G, but I don't feel safe as I don't really know what caused the problem.

    Please advise.

    Thanks,

    George

  2. #2
    Join Date
    Jun 2004
    Posts
    812
    Provided Answers: 1
    I don't really know what caused the problem
    What testing was being undertaken at the time that the error occurred?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jan 2017
    Posts
    8

    Re: ORA-27102: out of memory on Linux

    Quote Originally Posted by cis_groupie View Post
    What testing was being undertaken at the time that the error occurred?
    The person who reported the problem to me, on both occasions when it came up today and last Friday, was the only user and merely tried to access the AppServer that uses the DB. In other words, minimal DB activity.

    Do my memory settings look reasonable to you?

    How can I monitor the memory load on the system? I know that just before I rebooted (to bounce Oracle), top was showing a much higher memory strain on the system than what I wrote above after the reboot. The free memory was around 150MB.

    I'm more of a DB2 person than an Oracle person and it's hurting me right now...

    - G

  4. #4
    Join Date
    Jun 2004
    Posts
    812
    Provided Answers: 1
    The most obvious answer would be that you haven't allocated enough memory. HOWEVER...a quick google search suggests that the problem may actually lie with the OS and not with Oracle.
    Sadly, as I don't use Oracle on Linux servers, I can't suggest what your settings should be. But if you search for "ORA-27102 out of memory Linux-x86_64 Error" you will get some links that will hopefully help you.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •