Oracle systemd

Systemd ignora i limiti assegnati nel file /etc/security/limits.d/*. Per evitare problemi è caldamente consigliabile configurare i limiti di processi, numero files e memoria a livello di systemd.

[root@host02 system]# pwd
/usr/local/lib/systemd/system

[root@host02 system]# more oracle_listener.service
[Unit]
Description="Oracle Listener"
After=network.target

[Service]
User=oracle
Group=oinstall
Type=forking
WorkingDirectory=/app/oracle/product/11.2.0/dbhome_1
Environment=ORACLE_BASE=/app/oracle ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1
Restart=on-failure
ExecStart=/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start LISTENER
ExecStop=/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl stop LISTENER
LimitNOFILE=65536
LimitNPROC=16384
#LimitSTACK=unlimited
LimitMEMLOCK=134217728

[Install]
WantedBy=multi-user.target

[root@host02 system]# more oracle_database_test.service
[Unit]
Description="Oracle database test"
After=network.target

[Service]
User=oracle
Group=oinstall
Type=forking
WorkingDirectory=/app/oracle/product/11.2.0/dbhome_1
Environment=ORACLE_BASE=/app/oracle ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1 ORACLE_SID=test
Restart=on-failure
ExecStart=/bin/sh -c "echo startup | /app/oracle/product/11.2.0/dbhome_1/bin/sqlplus '/ as sysdba'"
ExecStop=/bin/sh -c "echo shutdown immediate | /app/oracle/product/11.2.0/dbhome_1/bin/sqlplus '/ as sysdba'"
LimitNOFILE=65536
LimitNPROC=16384
#LimitSTACK=unlimited
LimitMEMLOCK=134217728

[Install]
WantedBy=multi-user.target