查看
ulimit -a
/etc/profile
~/.bash_profile
/etc/security/limit.conf
/etc/security/limit.d/20-nproc.conf
优先级(网上说法):
1./etc/security/limit.d/20-nproc.conf
2./etc/security/limit.conf
3.~/.bash_profile
4./etc/profile
优先级(我个人理解)(bash_profile里的类似每次切换用户临时生效,所以高于永久生效):
1.~/.bash_profile
2./etc/profile
3./etc/security/limit.d/20-nproc.conf
4./etc/security/limit.conf
1.常规
编辑/etc/security/limits.conf 添加如下内容:
vi /etc/security/limits.conf
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
2.99 20文件(优先级高于上面的limits.conf)
Linux6:
/etc/security/limits.d/90-nproc.conf
Linux7:
/etc/security/limits.d/20-nproc.conf
3.oracle-database-preinstall-19c.conf文件
一般19c有,位置也在 /etc/security/limits.d/下,用sqlplus startup起会用这个的限制
# oracle-database-preinstall-19c setting for nofile soft limit is 1024
oracle soft nofile 1024
# oracle-database-preinstall-19c setting for nofile hard limit is 65536
oracle hard nofile 65536
# oracle-database-preinstall-19c setting for nproc soft limit is 16384
# refer orabug15971421 for more info.
oracle soft nproc 16384
# oracle-database-preinstall-19c setting for nproc hard limit is 16384
oracle hard nproc 16384
# oracle-database-preinstall-19c setting for stack soft limit is 10240KB
oracle soft stack 10240
# oracle-database-preinstall-19c setting for stack hard limit is 32768KB
oracle hard stack 32768
# oracle-database-preinstall-19c setting for memlock hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90 % of RAM
oracle hard memlock 474620572
# oracle-database-preinstall-19c setting for memlock soft limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM
oracle soft memlock 474620572
# oracle-database-preinstall-19c setting for data soft limit is ‘unlimited’
oracle soft data unlimited
# oracle-database-preinstall-19c setting for data hard limit is ‘unlimited’
oracle hard data unlimited