Hello !
I have an issue with mem parameters.
I have a oracle 19g db (19.21) on Linux RedHat Enterprise Linux 9 last update.
I settings linux settings parameters as show:
/etc/sysctl.conf
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
vm.nr_hugepages = 3410
cat /etc/security/limits.d/97-oracle.conf
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 8457280 (But I can use any value, it doesnt work)
oracle soft memlock 8457280 (But I can use any value, it doesnt work)
and for safety.
/etc/security/limits.conf
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 8457280 (But I can use any value, it doesnt work)
oracle soft memlock 8457280 (But I can use any value, it doesnt work)
doing the ulimit -a with user root or user oracle I have:
real-time non-blocking time (microseconds, -R) unlimited
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 62702
max locked memory (kbytes, -l) 8457280
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 16384
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
If I start the db using the systemd script oracle log show that Im using a default memlock, If I launch it manually passing from root (root>>>>>su - oracle>>>> dbastart $ORACLE_HOME) I get the right parameters.
# Invoking Oracle scripts to start/shutdown Instances defined in /etc/oratab
# and starts Listener
[Unit]
Description=Oracle Database(s) and Listener
Requires=network.target
[Service]
Type=forking
Restart=no
ExecStart=/u/app/oracle/product/19.3/dbhome_1/bin/dbstart /u/app/oracle/product/19.3/dbhome_1
ExecStop=/u/app/oracle/product/19.3/dbhome_1/bin/dbshut /u/app/oracle/product/19.3/dbhome_1
User=oracle
[Install]
What I should check, please ?
Many Thanks