Re: System always asks for ORACLE_SID

"jishnuk" <jishnukinwar_at_hotmail.com> wrote in message news:18ce01ca.0108301340.2aebf23f_at_posting.google.com...
> Hi i am on a solaris 2.8 Sun Ultra 10 running oracle 8i
> wheenever i try login into my acount i get the following error.
> The error occurs in the execution of the .cshrc file
> at the point i try to set up
> source /usr/local/bin/coraenv
> i know that because the echo statement after this never prints
> Below is the script session
>
> sript started on Thu 30 Aug 2001 04:26:30 PM CDT
> Hi Mr Kinwar
>
> SunOS 5.8
>
>
>
> login: jsihnuk      ishnuk
> Password:
>
> Sun Microsystems Inc. SunOS 5.8 Generic February 2000
> Hi Mr Kinwar
> Syntax error ******* THE PROBLEM ********
> turing%
> turing%
> turing%
> turing% cat .cshrc
> # @(#)cshrc 1.11 89/11/29 SMI
> umask 077
> set path=(/bin /usr/bin /usr/ucb /etc
> /sysadm/app/oracle/product/8.1.7/bin /sysadm/acrobat /usr/sbin .)
> if ( $?prompt ) then
> set history=32
> endif
> set ORACLE_SID=ma214
> set ORACLE_HOME=/sysadm/app/oracle/product/8.1.7
> #source /usr/local/bin/coraenv
> set LD_LIBRARY_PATH =($ORACLE_HOME/lib /usr/openwin/lib /usr/dt/lib)
> set ORAENV_ASK=NO
> echo "Hi Mr Kinwar"
> source /usr/local/bin/coraenv
> echo "Hi Mr " ******NEVER PRINTS THIS *********
> unset ORAENV_ASK
> turing%
> turing% exit
> turing% logout
> Connection closed by foreign host.
>
> Can any one tell me how this can be solved.
> thanks in advance
> Jishnu Kinwar
> Lamar University

In the current situation, as you already have a hardcoded Oracle_home (not recommended) I don't see why you call coraenv at all. In ksh the proper solution is
export ORACLE_SID=<yoursid>
export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=

Are you sure ORAENV_ASK is available with the proper value to the coraenv script.
It very much looks like it is not.

Hth,

Sybrand Bakker,
Senior Oracle DBA Received on Thu Aug 30 2001 - 16:54:03 CDT