Change NLS_LANG

Posted by big on Apr 21, 2021; 6:12am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Change-NLS-LANG-tp9644.html

Hi,
On 19c7 on AIX, we have the following error:

SQL> select userenv('LANGUAGE') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.WE8ISO8859P15

SQL> ALTER SESSION SET NLS_LANGUAGE= 'FRENCH';
ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified


SQL> ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN';

Session altered.

Any idea?

Thank you.