topic Re: oraenv error in Operating System - HP-UX

oraenv error

Ingo Dengler — Tue, 25 Feb 2003 15:09:07 GMT

please help, i don't know why an error occures, i never changed anything in that file.

I take ksh. but it just does nothing after entering the SID.
The oraenv file is attached

Re: oraenv error

Ian Lochray — Tue, 25 Feb 2003 16:22:17 GMT

Before you run oraenv, issue the command:
ORACLE_TRACE=T
When you run oraenv it will display debug information and show you the command it is hanging on.
Afterwards, unset ORACLE_TRACE and do a set -x in your shell.

Re: oraenv error

Ian Lochray — Tue, 25 Feb 2003 16:26:28 GMT

Afterwards, do a set +x, not a set -x.

Re: oraenv error

Jean-Luc Oudart — Tue, 25 Feb 2003 17:19:33 GMT

We comment out some of the lines we don't need , export ORAENV_ASK=NO and have one oraenv script per oracle version (e.g. /usr/local/bin/oraenv.817)

cf. attachment

Rgds,
Jean-luc

Re: oraenv error

Steven E. Protter — Tue, 25 Feb 2003 20:15:52 GMT

This code section was not properly tested by Oracle.

The first test which says unlimited doesn't work on HP-UX

You'll need to modify that code. This only applies if your error is....something like this.

unlimited not numeric. That's not exact but I used to get it all the time.

if [ $? = 0 -a "$ULIMIT" != "unlimited" ] ; then
if [ "$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

Here is some possible alternet code, though you'll need to thoroughly test it.

102ULIMIT=`LANG=C ulimit 2>/dev/null`
103
104if [ $? = 0 -a "$ULIMIT" -lt 2113674 ] ; then
105
106 if [ -f $ORACLE_HOME/bin/osh ] ; then
107 exec $ORACLE_HOME/bin/osh
108 else
109 for D in `echo $PATH | tr : " "`
110 do
111 if [ -f $D/osh ] ; then
112 exec $D/osh
113 fi
114 done
115 fi
116
117 fi

numbers left in on purpose. Makes you read it.

SEP

Re: oraenv error

Rory R Hammond — Wed, 26 Feb 2003 16:22:22 GMT

If you are using ksh. it probably is ksh ulimit=unlimitd.
modify your ora env:

if [ $? = 0 -a "$ULIMIT" != "unlimited" ] ; then
if [ "$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