Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oraenv description

Re: oraenv description

From: Joachim Flierdl <Joachim.Flierdl_at_Materna.DE>
Date: 1997/09/09
Message-ID: <5v314m$ba$1@peanuts.Materna.DE>#1/1

In article vix_at_medisoft.ee says...

>Hi
>
>Setting up NLS stuff isn't what oraenv is supposed to do. Just write
>few-liner shell script, which does what you need and source it from
>your shell. For bash/ksh your .profile might contain a line:
>
>. /opt/etc/oracle_environment
>
>and /opt/etc/oracle_environment might be:
>
>export NLS_LANG=ESTONIAN_ESTONIA.WE8ISO8859P1
>export ORACLE_SID=foo
>export ORAENV_ASK=NO
>. oraenv
>ORAENV_ASK=
Hello,

may be I should be a little more precise. I used the following lines in my '.profile' (for ksh):

export ORACLE_BASE=/u01/home/dba/oracle           
export ORACLE_HOME=$ORACLE_BASE                   
export ORACLE_SID=foo

# may be this is the problem?
export ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data export DBA=$ORACLE_BASE/admin export PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin:. # old NLS_LANG variable
# export NLS_LANG=GERMAN_GERMANY.EEC8EUROPA3 export NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 export ORAENV_ASK=NO
#. oraenv

If I call '. oraenv', the NLS_LANG variable is ignored (sqlplus shows data still with the 'GERMAN_GERMANY.EEC8EUROPA3' character set. Otherwise sqlplus shows data with the right 'GERMAN_GERMANY.WE8ISO8859P1' character set). May be oraenv isn't the problem, but isn't it a strange behaviour?

>
>
>BTW. oraenv is shell script too. You can always read from there, what
>it does and/or doesn't.

You're right and I found nothing in it about NLS_LANG.

bye
Joachim

BTW. we're using ORACLE 7.2.2 under SINIX 5.42 and the DB is created with the 'GERMAN_GERMANY.WE8ISO8859P1' character set (we migrated from 'GERMAN_GERMANY.EEC8EUROPA3').

-- 
_____________________________________________________________________
Joachim Flierdl
Tel.:    D-(0231)5599-697
Fax:     D-(0231)5599-68697
         D-(0231)5599-588
E-Mail:  Joachim.Flierdl_at_Materna.De
X.400:   c=DE; a=UMI-DE; p=MATERNA; s=Flierdl; g=Joachim
_____________________________________________________________________
Received on Tue Sep 09 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US