Hello,
Two weeks ago, I posted a question to the list concerning a problem we were
having in trying to use NLS (National Language Support) with Oracle (Original
question at the end).
Many thanks to all the people that responded.
Many people were under the impression that we weren't able to set the ORA_NLS
variable (and provided solutions to be sure that it was set). This however
was not the problem; Oracle startup was just not taking it into account
(sometimes).
The solution came from Oracle US. It seemed that in addition to setting the
ORA_NLS variable, we also had to set the NLS_LANG variable (we used to do
this for our normal users, but not for the Oracle user).
NLS has been working fine for a week now.
As to why it worked sometimes and sometimes not, we haven't a clue.
Bye.
----------------------------------- Original Question
-------------------------------------
Hello there,
Our DBA is experiencing a weird problem with Oracle. Here it is.
We have a 4 cpu Alpha AXP2100/A500 - OSF/1 3.2 (Rev. 214) running Oracle
RDBMS 7.2.2.3.
As I'm living in Belgium and not everyone speaks English over here, we would
like to make use of the NLS (National Lanuguage Support) introduced in Oracle
since version 7.2.
In order to be able to use this feature, we must set the variable ORA_NLS
prior to starting our database. This is done from /sbin/init.d/oracle with
the command su -oracle -c '/oracle/product/7.2.2/bin/dbstart.
User oracle uses csh and the ORA_NLS variable is set in .cshrc to
/oracle/product/7.2.2/ocommon/nls/admin/data.
Now our problem is that Oracle is not taking into account the setting of
ORA_NLS rendering the feature unusable. We found a workaround: Opening an
oracle shell, unsetting ORA_NLS and setting it again and the doing the
dbstart.
You can verify that the feature works when you do a select from sqlplus:
select to_char(sysdate,'day','nls_date_language=French') from dual;
This should result in 'vendredi' instead of 'friday'; otherwise you get an
error.
Is someone experiencing the same kind of problem in setting ORA_NLS and knows
what to do about it ?
PS.: We were having the same problem a few weeks ago, when our machine was
still running OSF/1 3.0.
Any kind of help would be greatly appreciated.
Received on Fri Jan 26 1996 - 10:35:38 NZDT