ORA-12705:无法访问NLS数据文件或无效的环境 [英] ORA-12705: Cannot access NLS data files or invalid environment

问题描述

前几天，我收到了这个令人讨厌的oracle错误:ORA-12705:无法访问NLS数据文件或指定了无效的环境.有趣的是，我没有尝试访问NLS数据文件

The other day I got this annoying oracle error: ORA-12705: Cannot access NLS data files or invalid environment specified. Funny thing I wasn't trying to access NLS data files

推荐答案

有两种可能的原因:

试图发出带有无效NLS参数或值的ALTER SESSION语句.

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

NLS_LANG环境变量包含无效的语言，地区或字符集.

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

修复:

取消设置NLS_LANG环境变量

Unset the NLS_LANG environment variable

Windows-必须在Windows注册表中取消设置NLS_LANG(最好重命名).在\ HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE中的注册表中查找NLS_LANG子项，然后重命名.

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-在这里，您只需发出Linux命令"unset NLS_LANG"

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

这篇关于ORA-12705:无法访问NLS数据文件或无效的环境的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！