ORA-12705: Cannot access NLS data files or invalid environment

在.bash_profile  里加了  

export  NLS_LANG=UTF8

然后 sqlplus  /  as  sysdba

报错:ORA-12705: Cannot access NLS data files or invalid environment

把.bash_profile 里添加的NLS_LANG 相关的都删掉,然后source  .bash_profile 依然报错。

#unset NLS_LANG

看看官方解释:

There are two possible causes:

An attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value.

The NLS_LANG environment variable contains an invalid language, territory, or character set.

Fix:

Unset the NLS_LANG environment variable

Windows - The NLS_LANG must be unset in the Windows registry (re-named is best). Look for the NLS_LANG subkey in the registry at \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE, and rename it.

Linux/UNIX - Here you simply issue the Linux command “unset NLS_LANG”

posted @ 2021-05-08 16:25  beawh  阅读(804)  评论(0编辑  收藏  举报