Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Error Received After Entering ORACLE_SID Value

SOLVED
Go to solution
Scott Buckingham
Regular Advisor

Error Received After Entering ORACLE_SID Value

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.
Long time dabbler, first time Admin / DBA
6 REPLIES
John Poff
Honored Contributor

Re: Error Received After Entering ORACLE_SID Value

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

Re: Error Received After Entering ORACLE_SID Value

Hi Scott,

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

thanks
James R. Ferguson
Acclaimed Contributor

Re: Error Received After Entering ORACLE_SID Value

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

Re: Error Received After Entering ORACLE_SID Value

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...
If I had only read the instructions first??
Scott Buckingham
Regular Advisor

Re: Error Received After Entering ORACLE_SID Value

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.
Long time dabbler, first time Admin / DBA
James R. Ferguson
Acclaimed Contributor
Solution

Re: Error Received After Entering ORACLE_SID Value

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