Share |

ORA-12705: Invalid or unknown NLS parameter value specified

You specified an invalid NLS parameter, either in the registry, on the command prompt or shell or using the alter session set NLS.... command.

Either remove the invalid setting from the registry, unset it in the command prompt/shell or fix the alter session statement.
eg: 
C:>set NLS_LANG=american_america.unknown

C:>sqlplus system@ora920

SQL*Plus: Release 9.2.0.7.0 - Production 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter password:
ERROR:
ORA-12705: invalid or unknown NLS parameter value specified


Enter user-name:

C:>set NLS_LANG=

C:>sqlplus system@ora920

SQL*Plus: Release 9.2.0.7.0 - Production

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter password:

Connected to:
 Was this information helpful?  Yes No
If it was not helpful, please take some time to explain why. This is not to ask questions, you can do so in the forum.

Welcome to our forum for Oracle error: ORA-12705 Add your own message



reply On 06-MAR-2009 11:12:41 SANTANU asked: errore while tying to retrive text ora-12705
Reply
why the 'errore while tying to retrive text ora-12705'

is coming .. how to over come this errore .. plz advice..
reply On 06-MAR-2009 11:17:36 DbMotive replied
Reply
Because you get the message: could not retreive text for ORA- message, this normally indicactes that your ORACLE_HOME was nor configured correctly.

It might be possible that when you fix your Oracle home setting, the error for the Invalid NLS parameter will also disappear:

 
reply On 28-MAY-2009 13:43:13 M.A.Malik asked: NLS error
Reply
hi all,

i am trying to connect from oracle 9i client to oracle 10g, and i am recivieng this ora-12705 NLS error.
when i tried to conncet with command promp, it connected without any error but when i am tring to connect using sqlplus it contantly returning this erro.
an early reply will realy be hellpfull, thanks in advance.

regards,
Ahsan Malik
reply On 28-MAY-2009 15:32:16 Dbmotive replied
Reply
Check your setting for the NLS_LANG parameter.

On Linux it is an environment variable, in Windows you need to check your Registry settings in HKEY_LOCAL_MACHINE\Software\Oracle
 
reply On 11-JUL-2009 14:24:54 semko asked: error
Reply
12705

Add your message

 Please provide your personal info 



 Please ask your message as briefly and clear as possible 

 Spam Protection 
Validation Code: f064ncngqnnj6ozro


Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.


Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.


Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.