You need to set the “session limits for Oracle user” before you install any Oracle Database product.
When you try to login into “oracle” user you will receive following error
test@server1$ su - oracle
/etc/profile[57]: ulimit: pipe: is read only
Check the ulimit using below command
test@server1$ulimit -a
address space limit (kbytes) (-M) unlimited
core file size (blocks) (-c) unlimited
cpu time (seconds) (-t) unlimited
data size (kbytes) (-d) unlimited
file size (blocks) (-f) unlimited
locks (-L) unlimited
locked address space (kbytes) (-l) 32
nofile (-n) 65536
nproc (-u) 16384
pipe buffer size (bytes) (-p) 4096
resident set size (kbytes) (-m) unlimited
socket buffer size (bytes) (-b) 4096
stack size (kbytes) (-s) 10240
threads (-T) not supported
process size (kbytes) (-v) unlimited
The syntax that was previously used to set the "Max user processes limitation" is changed from "ulimit -p" to "ulimit -u", which is causing the issue.
Replace the session limits in /etc/profile with below code to resolve the issue.
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -u 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
Regards
Satishbabu Gunukula
http://www.oracleracexpert.com
Thursday, September 29, 2011
Subscribe to:
Post Comments (Atom)

0 comments:
Post a Comment