ORA-12705: Cannot access NLS data files or invalid environment specified
Yesterday I got to "help" a colleague out with the aforementioned ORA-12705. I had never seen it before and there doesn't seem to be a whole lot of information out
there, especially in regards to OBIEE.
Here's the definition from the
docs:
Cause:
Either an attempt was made to issue an ALTER SESSION command with an invalid NLS parameter or value; or the environment variable(s) NLS_LANG, ORA_NLSxx, or ORACLE_HOME was incorrectly specified, therefore the NLS data files cannot be located.
Action:
Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify the correct directory path/values in the environment variables.
This would occur when trying to import tables into the RPD (OBIEE). First thing that pops up is the Select Data Source screen:
Then this beauty would pop up:
Ultimately the solution that, sort of worked, was
here.
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.
We tried changing it to what I had in my registry:
AMERICAN_AMERICA.WE8MSWIN1252That didn't work.
Tried renaming it as the article suggested, that didn't work.
Finally, my colleague (without prompting from me), cleared the key (didn't delete, just blanked it)...and voila!
Labels: obiee, ORA-12705, oradb
