topic Re: oracle user error - ulimit in Operating System - HP-UX

oracle user error - ulimit

Lisa Callison — Thu, 14 Jul 2005 08:03:35 GMT

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

Re: oracle user error - ulimit

David Child_1 — Thu, 14 Jul 2005 08:13:22 GMT

Lisa,

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

Re: oracle user error - ulimit

Kent Ostby — Thu, 14 Jul 2005 08:15:28 GMT

Lisa -- Check out document KBRC00013163

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

Re: oracle user error - ulimit

Neil Wilson_2 — Thu, 14 Jul 2005 08:16:10 GMT

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

Re: oracle user error - ulimit

RAC_1 — Thu, 14 Jul 2005 08:18:26 GMT

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

Anil

Re: oracle user error - ulimit

Patti Johnson — Thu, 14 Jul 2005 08:18:47 GMT

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

Re: oracle user error - ulimit

Lisa Callison — Thu, 14 Jul 2005 08:31:44 GMT

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.

Re: oracle user error - ulimit

Lisa Callison — Fri, 15 Jul 2005 01:12:08 GMT

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

Re: oracle user error - ulimit

Indira Aramandla — Fri, 15 Jul 2005 01:51:11 GMT

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

Re: oracle user error - ulimit

Lisa Callison — Fri, 15 Jul 2005 02:10:16 GMT

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

Re: oracle user error - ulimit

Patti Johnson — Mon, 25 Jul 2005 10:04:47 GMT

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