Setup Shell limits for Oracle user in Linux

Add lines to /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

Above values depend on your environment.

Add following script to /etc/profile.local
if [ $USER = “oracle” ]; then
if [ $SHELL = “/bin/ksh” ] ; then
ulimit –p 16384
ulimit –n 65536
else
ulimit –u 16384 –n 65536
fi
fi

Have a nice day!