Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Showing results for 
Search instead for 
Did you mean: 

Unable to connect to TOAD /PLSQL developer

Occasional Visitor

Unable to connect to TOAD /PLSQL developer

I am able to connect SQL Plus but unable to connect TOAD /PLSQL developer getting error msg
ORA-12705: Invalid or unknown NLS parameter value specified
Jonathan Fife
Honored Contributor

Re: Unable to connect to TOAD /PLSQL developer

I would guess that your NLS_LANG environment variable isn't set correctly. If you're running SQL Developer from Windows I believe this is a registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE and various subdirectories from there.
Decay is inherent in all compounded things. Strive on with diligence
Occasional Visitor

Re: Unable to connect to TOAD /PLSQL developer

Hi satesh

kindly make sure whether ur plsql dev or toad using the same oracle home which is used by ur sqlplus/oracle client

with regards
Sean Dale
Trusted Contributor

Re: Unable to connect to TOAD /PLSQL developer

I set the NLS_LANG parameter as a system environment variable and everything works fine on my computer.
Live life everyday
Honored Contributor

Re: Unable to connect to TOAD /PLSQL developer


do you have several oracle homes on the client?

If yes, on the connect window, click on the "SQL*Net Help" button and set the appropriate "TOAD" home.

hope this helps!

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Frank de Vries
Respected Contributor

Re: Unable to connect to TOAD /PLSQL developer

It means only one thing:

You need to specify the NLS_LANG parameter.
Possible values are:

Now if you are not sure about which ORACLE_HOME then add them in your registry
for each ORACLE_HOME
thus: start run: type regedit
Edit new string value NLS_LANG
and the same for each ..\HOME0
..\HOME1 etc..

ALso if you have an older TOAD you may add
under controlpanel system environment variable set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
But that only makes sense if your ORACLE_HOME is in the %PATH% variable and

But I would try the registry first.
Look before you leap