Error Received After Entering ORACLE_SID Value

[Scott Buckingham]

What is this telling me?

sh: unlimited: The specified number is not valid for this command

I receive this after I execute:

. oraenv

which I do after logging in as Oracle. I have two instances of Oracle on this box, which is HP-UX 11.

[John Poff]

Hello,

Sounds like a bad entry in your oraenv file. Maybe you can post it for the local wizards to look at.

JP

[Sanjay_6]

Hi Scott,

Post the complete error and can you attach the oraenv file for us to look at.

thanks

[James R. Ferguson]

Hi Scott:

I suspect that you have a 'ulimit' statement in your 'oraenv' and that your are running as a ksh (Korn) shell.

For 'ksh' the value 4194304 represents 'unlimited'. The POSIX shell (sh) uses the string 'unlimited' instead.

Regards!

...JRF...

[Joseph C. Denman]

James is correct as alway!!

In the oraenv, a test is done to see if the value returned from ulimit is less than a certain number. Since in the POSIX shell, the return value is unlimited, the test fails. "unlimited" is not a number. If you change to the korn shell, you will not get the error because the value returned from the ulimit command is a number.

The error has no impact, just an eye sore.

...jcd...

[Scott Buckingham]

Well guys, here you go! And James, you are right about the 'ulimit', but being rather 'green' in this area, I'm not sure what this is suppose to be.

[James R. Ferguson · Accepted solution]

Hi (again) Scott:

Joseph is correct. Change:

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

...to be...

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

...and add one terminating 'fi' at the end. In all, this code will look like:

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
fi

Regards!

...JRF...