on large databases we have lower memlock than needed

[DmitriyStoyanov]

SUMMARY

On database with 20GB we found that memlock hard limited to 8GB as described here https://docs.oracle.com/cd/E11882_01/server.112/e10839/appi_vlm.htm#UNXAR396 we should have memlock configured to shm and SGA size

in that case here vars/oracle12.yml we should change static limits here - "oracle soft memlock 7340032" - "oracle hard memlock 8388608"

also in centos7 we have some changes in checks of /etc/security/limits.conf https://serverfault.com/questions/628610/increasing-nproc-for-processes-launched-by-systemd-on-centos-7/678861#678861 and such changes also should be configured in service template file templates/oracledb.systemd.j2 for example: [Service] ... LimitMEMLOCK=infinity LimitNOFILE=65535 ..,

ISSUE TYPE

• Bug Report

COMPONENT NAME

ANSIBLE VERSION

CONFIGURATION

OS / ENVIRONMENT

STEPS TO REPRODUCE

Create DB with 20GB and in alert log you will see message like:

1. Increase per process memlock (soft) limit to at least 20GB to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory

EXPECTED RESULTS

memlock size configured as SGA or SHM size

ACTUAL RESULTS