问题描述
前几天,我收到了这个令人讨厌的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数据文件或无效的环境的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!