Cannot set 'soft limits' for 'maximum stack size' for a standard user

Linux and Unix-Like Red Hat
1

Hi Guys,

I'm trying to install Oracle Database on to Oracle Linux 7.6 but when
the database install package checks the OS set-up, it keeps on failing
on the soft limits for the stack. It's default value is 8192 but I'm trying
to set it to 10240.

This is what I added to /etc/sysctl.d/50-oracle-sysctl.conf 

fs.file-max                =6815744
 net.core.rmem_default    =262144
net.core.rmem_max        =4194304
net.core.wmem_default    =262144
net.core.wmem_max        =1048576

which works without issuing any warnings or errors.

This is what I copied from: Oracle Database 12c Preinstall Steps for Oracle Linux Simplified | Oracle Linux Blog
and placed into the config file at /etc/security/limits.d/50-oracle-limits.conf
because I was having problems and thought the parameters from the oracle
blog may have a better outcome. No change unfortunately.

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  134217728
oracle soft memlock 134217728

On restart the soft stack limit for user oracle is as good as ignored with still the default value of 8192.
Oracle database installer requires 10240 to proceed with the installation.

If I set the soft limit on the command line using ulimit -s 10240 the system accepts it.
Also tried adding this session required pam_limits.so to /etc/pam.d/su as described here
linux - how do i set hard and soft file limits for a non-root user at boot? - Server Fault but it
may not be having the required consequences.

The funny thing is, just adding the above lines to the config files under Oracle Linux 7.5
worked without any problems. Can only speculate that Oracle has added or changed
something that now works differently.

I'd like to apply the limits in a proper fashion without having to add commands to by
bash profile. Any ideas would be greatly appreciated. Thanks in advance.

SYSTEM

Oracle Database 12.2.0.1.0
Oracle Linux 7.6
  Dell Optiplex 3060 (RAM8GB/SWAP32GiB/SYS256GB/DATA256GB)
2

Are there any other files within /etc/security/limits.d that have this setting that could be overriding your new one?

Is there a duplicate in the one you edited perhaps?

grep -r oracle /etc/security/limits.d | grep soft | grep stack

I've written it out as three piped commands to ignore any differences in the delimiters.

Kind regards,
Robin

3

Also, changing the file does not change the limits of a running program, or even an existing login. The service may need restarting.