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

512866

Need some help to resolve this error message....

ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

How can I resolve this error?

I am attempting a connection between Oracle 10g XE and SQL-Developer.

Details are as follows:

SQL-Developer
Version 1.0.0.15.57
Build Main 15.57 and

10g XE Database
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

OS: Windows XP SP2

530897

12705, 00000, "Cannot access NLS data files or invalid environment specified"
// *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.

Where just attempting to connect, or were you running SQL?

512866

Just attempting to make a connection....

Not running any SQL commands on the db.

536805

NLS Lang version mismatch at the time of installation Oracle 10g XE and SQL-Developer

512866

NLS Lang version mismatch at the time of installation
Oracle 10g XE and SQL-Developer

.......what?

Please explain what you mean, since both have been installed concurrently, and you don't run an exe for the SQL-Developer installation just an zip extraction into a folder.

Thanks

Paul M.

Are you able to connect from Sql*Plus ?

536805

check language installed on 10g
for checking enter following sql

select userenv('LANGUAGE') from dual;

512866

Thanks all.

Got it to work by uninstalling XE, deleting all reference to ORACLE in windows registry and doing a complete re-installation of XE.

568267

The problem occurs when you had a previous install of Oracle.
To solve the issue, clean up windows regisrty entries for Oracle.

637024

you can solve this problem changing your regional configuration under windows as same as your oracle installation, probably (English) United States.

642158

i also got this kind of problem..
i want 2 uninstall Oracle in my pc,
but i dont know what to delete or how to clean the Windows registry entries for Oracle...