{"id":214,"date":"2021-02-01T14:53:25","date_gmt":"2021-02-01T13:53:25","guid":{"rendered":"https:\/\/oracledba.fr\/?p=214"},"modified":"2021-02-01T14:54:19","modified_gmt":"2021-02-01T13:54:19","slug":"ora-27300-ora-27301-ora-27302-os-failure-message-no-buffer-space-available","status":"publish","type":"post","link":"https:\/\/oracledba.fr\/?p=214","title":{"rendered":"ORA-27301 OS failure message: No buffer space available"},"content":{"rendered":"\n

If you get this error<\/p>\n\n\n\n

ORA-27300: OS system dependent operation:sendmsg failed with status: 105
ORA-27301: OS failure message: No buffer space available
ORA-27302: failure occurred at: sskgxpsnd2<\/p>\n\n\n\n

The solution is to:<\/p>\n\n\n\n

  1. Lower MTU to 16436. To do this, add following to \/etc\/sysconfig\/network-scripts\/ifcfg-lo or replace the value if MTU is already set in this configuration file.
    MTU=16436<\/li>
  2. Save the file, exit and restart the network service by running:
    systemctl restart network.service<\/li>
  3. Calculate the value for vm.min_free_kbytes to be 0.4 % of the total physical memory and multiply by the number of NUMA nodes.
    total=$(awk ‘\/MemTotal:(.)\/{print $2 }’ \/proc\/meminfo) numa_count=$(lscpu | awk ‘\/^NUMA node(s)(.<\/em>)\/{print $3 }’)
    min_free_kb=$(expr $total \/ 250 * 1) # this is the<\/li>
  4. Increase the value of vm.min_free_kbytes accordingly. This can be done by adding following a new sysctl configuration.
    echo “vm.min_free_kbytes=$min_free_kb” > \/etc\/sysctl.d\/99-vm_min_free_kbytes.conf<\/li><\/ol>\n\n\n\n

    This will take the value of $min_free_kb from the previous step!<\/p>\n\n\n\n

    1. load the new values<\/li><\/ol>\n\n\n\n

      sysctl –system<\/p>\n\n\n\n

      1. Verify the new value has been applied correctly.
        sysctl vm.min_free_kbytes<\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"

        If you get this error ORA-27300: OS system dependent operation:sendmsg failed with status: 105ORA-27301: OS failure message: No buffer space availableORA-27302: failure occurred at: sskgxpsnd2 The solution is to: Lower MTU to 16436. To do this, add following to \/etc\/sysconfig\/network-scripts\/ifcfg-lo or replace the value if MTU is already set in this configuration file.MTU=16436 Save the … <\/p>\n

        Continue reading “ORA-27301 OS failure message: No buffer space available”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-214","post","type-post","status-publish","format-standard","hentry","category-non-classe"],"_links":{"self":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=214"}],"version-history":[{"count":2,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/214\/revisions"}],"predecessor-version":[{"id":216,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/214\/revisions\/216"}],"wp:attachment":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}