Re: System always asks for ORACLE_SID

From: Dirk Kiehne <dirk_at_liberate.com>
Date: Fri, 31 Aug 2001 17:30:27 GMT
Message-ID: <3B8FCA3A.7C9AF3B7@liberate.com>

Sybrand Bakker wrote:
>
> "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

and in csh you'll need to use:

 setenv ORACLE_SID ma214
 setenv ORACLE_HOME /sysadm/app/oracle/product/8.1.7

I always include:

 setenv ORACLE_BASE /sysadm
 setenv ORACLE_DOC $ORACLE_BASE/doc
 setenv ORACLE_TERM xterm

 setenv TNS_ADMIN $ORACLE_HOME/network/admin/tnsnames.ora

Good luck,
-Dirk Received on Fri Aug 31 2001 - 12:30:27 CDT