I’d been getting this error when trying to connect to an Oracle Database using SQLPlus, unless I happened to be in the Oracle home bin directory.
Trawling for an answer it turns out you need to modify a registry entry which indicates the NLS parameter used by SQLPlus when it attempts to ALTER SESSION at login;
Navigate to registry key [ HKEY_LOCAL_MACHINE \ Software \ Oracle ] and rename or delete the NLS_LANG value.
9 thoughts on “ORA-12705 Cannot access NLS data files or invalid environment specified”
Thanks for this info – it has helped me a lot.
Thanks. It saved my tons of efforts.
Thanks a ton.. was a big help
are you kidding?
after hours searching lot of error page, you just give us simple help but it’s work ….
Cool… It worked for me….. Thanks a lot.
Glad it helped
Banging my head against the brick wall (you know the one we’ve all head butted before) thinking it was a driver error. I don’t like messing with the registry but this worked a treat. Thanks alot 🙂
Thanks. Quick explanation — and solved the problem.
Thanx a Lot. It was a quick resolution.