oracle user error - ulimit

[Lisa Callison]

I receive the following error after invoking the oraenv file, (when trying to update the ORACLE_SID) I get the error message:
ksh: unlimited: bad number
The oracle_sid is changed but this error message never used to appear before. Is this because oracle doesn't like one of my ulimit parameters?

How do I figure out which parameter it is and can I put something into the oracle user .profile/oraenv to get rid of the message?

Thanks in advance
Lisa

[David Child_1]

Lisa,

Refer to this link; http://unix.derkeiler.com/Mailing-Lists/HP-UX-Admin/2003-10/0021.html

[Kent Ostby]

Lisa -- Check out document KBRC00013163

http://www2.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=KBRC00013163

[Neil Wilson_2]

Hi Lisa

best if you can post a copy of the oraenv file on here. Would suggest the ULIMIT values in there might need changing.

have you also run a ulimit and ulimit -a ??

what is the output of these?

Neil.

PS this might be useful too....
http://unix.derkeiler.com/Mailing-Lists/HP-UX-Admin/2003-10/0016.html

[RAC_1]

Check all ulimit commands that oraenv is setting. Some of those ulimts are not being set properly.

Anil

[Patti Johnson]

Lisa,

This is an old bug in the oraenv script.
Find out where your oraenv script - make a backup copy and change the last section of the scripts.
I got this from Metalink note 1023496.6.
This issue has been part of the Oracle delivered script for versions 7, 8, 9 - so every time you patch or upgrade it comes back.

FROM: ----- if [ $? = 0 -a "$ULIMIT" -lt 2113674 ] ; then if [ -f $ORACLE_HOME/bin/osh ] ; then exec $ORACLE_HOME/bin/osh else for D in `echo $PATH | tr : " "` do if [ -f $D/osh ] ; then exec $D/osh fi done fi fi If Not on IBM AIX change to: ---------------------------- if [ $? = 0 -a "$ULIMIT" != "unlimited" ] ; then if [ $? = 0 -a "$ULIMIT" -lt 2113674 ] ; then if [ -f $ORACLE_HOME/bin/osh ] ; then exec $ORACLE_HOME/bin/osh else for D in `echo $PATH | tr : " "` do if [ -f $D/osh ] ; then exec $D/osh fi done fi fi fi

[Lisa Callison]

Thanks for all the quick replies, I'm going to have a read and check things out and post my findings and points again in the morning.

[Lisa Callison]

Hi all

Well I tested the change to the oraenv file:

# Locate "osh" and exec it if found
ULIMIT=`(ulimit) 2>/dev/null`

if [ "$ULIMIT" != "ulimited" ]; then
if [ $? = 0 -a "$ULIMIT" -lt 2113674 ] ; then

if [ -f $ORACLE_HOME/bin/osh ] ; then
exec $ORACLE_HOME/bin/osh
else
for D in `echo $PATH | tr : " "`
do
if [ -f $D/osh ] ; then
exec $D/osh
fi
done
fi

fi
fi

(Adding in the first 'if' statement as suggested), however after logging back in as oracle it errors with the same message.

So then I tried the suggested line by Patti which was slightly different, same problem.

Neil - when I run ulimit as oracle user:
unlimited
When I run ulimit -a:
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 1048576
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) 4194303

Any more ideas would be greatly appreciated....

Thanks Lisa

[Indira Aramandla]

Hi Lisa,

As patti mentioned you may be encountering a problem (Bug 369373) with the oraenv file that comes with Oracle for HP UNIX.

ORAENV checks for the value of 'ulimit' which is a parameter that verifies that there is enough resource available for users. This parameter should parse and return a numeric value from UNIX to the ORAENV. The bad oraenv file traps a return argument to the ulimit UNIX command of "unlimited" when the script expects a number.

Attached is the steps to modify the oraenv file.

If you receive the following message in UNIX when you start PSUB, thenyou may have a blank line at line 24 of the oraenv file. This line may have some unrecognizable code in it. If so, you should delete the line and try starting PSUB again.

IA

[Lisa Callison]

Indira

I already tried Patti's suggestion, however I still have the same problem, when checking line 24 of the oraenv file, it is the "T)"line.... which as far as I can see is fine.

case ${ORACLE_TRACE:-""} in
T) set -x ;;
esac

Thanks
Lisa

[Patti Johnson]

Lisa,

Do a 'which oraenv'
Oracle installation may put a copy is /etc or /usr/local/bin - so changing the oraenv in $ORACLE_HOME/bin may not help.

Patti