topic Re: Error Received After Entering ORACLE_SID Value in Operating System - HP-UX

Error Received After Entering ORACLE_SID Value

Scott Buckingham — Tue, 25 Sep 2001 20:00:50 GMT

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.

Re: Error Received After Entering ORACLE_SID Value

John Poff — Tue, 25 Sep 2001 20:11:38 GMT

Hello,

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

JP

Re: Error Received After Entering ORACLE_SID Value

Sanjay_6 — Tue, 25 Sep 2001 20:16:16 GMT

Hi Scott,

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

thanks

Re: Error Received After Entering ORACLE_SID Value

James R. Ferguson — Tue, 25 Sep 2001 20:21:26 GMT

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...

Re: Error Received After Entering ORACLE_SID Value

Joseph C. Denman — Tue, 25 Sep 2001 20:36:56 GMT

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...

Re: Error Received After Entering ORACLE_SID Value

Scott Buckingham — Tue, 25 Sep 2001 21:10:04 GMT

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.

Re: Error Received After Entering ORACLE_SID Value

James R. Ferguson — Tue, 25 Sep 2001 21:21:46 GMT

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...