Change NLS_LANG

[big]

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.

[ErmanArslansOracleBlog]

Oracle RDBMS/client software can not locate the definitions of charactersets , in this case French.

Do you have ORA_NLS settings in your environment?

Here I suppose you connect to the database from the OS auth directly.. I mean /as sysdba connection.

Connect the OS with the oracle user that you execute sqlplus ..Check it with;

env |grep ORA_NLS

Note that: Explicitly defining ORA_NLSxx in 9i and above is only needed when using an non default directory location for the nls files. So you have all the nlb files present in your $ORACLE_HOME/nls/data and you must not have a wrong ORA_NLS env setting in your environment.

Also note that, For EBS environments, we set ORA_NLS10 environment variable 9idata located inside Oracle Home. ( for instance :/u01/dbebs/product/19.0.0/nls/data/9idata) -- but this is for EBS environments..