Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oraenv description
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
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