Open DmitriyStoyanov opened 5 years ago
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
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 ..,
Create DB with 20GB and in alert log you will see message like:
memlock size configured as SGA or SHM size
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
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
COMPONENT NAME
ANSIBLE VERSION
CONFIGURATION
OS / ENVIRONMENT
STEPS TO REPRODUCE
Create DB with 20GB and in alert log you will see message like:
EXPECTED RESULTS
memlock size configured as SGA or SHM size
ACTUAL RESULTS