NLS problems - I cannot get access to oracle database

[aagj]

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

[nandukrishnavs]

@aagj 

Refer to this link http://www.dba-oracle.com/t_ora_12705_resolution.htm

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[aagj]

@nandukrishnavs 
I don't get this error when I am using my old laptop (I changed yesterday) and I have checked all the NLS parameter values...  

[nandukrishnavs]

@aagj 

Possible reasons are

1. An attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value.
2. The NLS_LANG environment variable contains an invalid language, territory, or character set.

You can resolve this by unset the NLS_LANG environment variable

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.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[aagj]

@nandukrishnavs 
what does it mean to 'unset the NLS_LANG '? 

[v-juanli-msft]

Hi @aagj 

nandukrishnavs's sharing would be helpful, could you try the suggestions from the link?

'unset the NLS_LANG': https://docs.oracle.com/cd/E12102_01/books/AnyInstAdm784/AnyInstAdmPreInstall18.html

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.