oraenv error

[Ingo Dengler]

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

[Ian Lochray]

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.

[Ian Lochray]

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

[Jean-Luc Oudart]

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

[Steven E. Protter]

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

[Rory R Hammond]

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