Linux openfiles modification
There are two main changes:
One is:
/ etc/security/limits.conf
Oracle soft nproc 2047
Oracle hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
Oracle soft stack 10240
But in this case: oracle ulimit-a still doesn't work.
[oracle@rman1] $ulimit-a
Core file size (blocks,-c) 0
Data seg size (kbytes,-d) unlimited
Scheduling priority (- e) 0
File size (blocks,-f) unlimited
Pending signals (- I) 7336
Max locked memory (kbytes,-l) 64
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) 1024
Virtual memory (kbytes,-v) unlimited
File locks (- x) unlimited
And then there is to modify this place:
/ etc/security/limits.d/90-nproc.conf
As follows:
# Default limit for number of user's processes to prevent
# accidental fork bombs.
# See rhbz # 432903 for reasoning.
* soft nproc 1024
Root soft nproc unlimited
Oracle soft nofile 65536
Other restrictions can be added, and the ulimit-an of oracle users will take effect:
[oracle@rman1] $ulimit-a
Core file size (blocks,-c) 0
Data seg size (kbytes,-d) unlimited
Scheduling priority (- e) 0
File size (blocks,-f) unlimited
Pending signals (- I) 7336
Max locked memory (kbytes,-l) 64
Max memory size (kbytes,-m) unlimited
Open files (- n) 65536
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) 2047
Virtual memory (kbytes,-v) unlimited
File locks (- x) unlimited
