cancel
Showing results for 
Search instead for 
Did you mean: 

oraenv error

Ingo Dengler
Occasional Contributor

oraenv error

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
qwe
5 REPLIES
Ian Lochray
Respected Contributor

Re: oraenv error

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
Respected Contributor

Re: oraenv error

Afterwards, do a set +x, not a set -x.
Jean-Luc Oudart
Honored Contributor

Re: oraenv error

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
fiat lux
Steven E. Protter
Exalted Contributor

Re: oraenv error

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Rory R Hammond
Trusted Contributor

Re: oraenv error

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
There are a 100 ways to do things and 97 of them are right