Home » SQL & PL/SQL » SQL & PL/SQL » ora-12705 - Invalid or unknown NLS parameter value specified
ora-12705 - Invalid or unknown NLS parameter value specified [message #26991] Tue, 12 August 2003 00:21 Go to next message
R.SIVAKUMAR
Messages: 48
Registered: February 2002
Member
while i log on to the oracel, i get the follwoing error
"Ora-12705 - Invalid or unknown NLS parameter value specified"
AND i could not log on.
how can i rectify this problem?

please help me.

siva
Re: ora-12705 - Invalid or unknown NLS parameter value specified [message #26992 is a reply to message #26991] Tue, 12 August 2003 00:45 Go to previous messageGo to next message
Rahman
Messages: 40
Registered: July 2003
Member
ORA-12705 invalid or unknown NLS parameter value specified

Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.

Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. For more information about the syntax of the ALTER SESSION command, see Oracle8i SQL Reference.

rehman
Re: ora-12705 - Invalid or unknown NLS parameter value specified [message #30019 is a reply to message #26992] Tue, 06 April 2004 23:14 Go to previous messageGo to next message
LI Huabo
Messages: 1
Registered: April 2004
Junior Member
You try to remove the environment variable NLS_LANG. Then log again.
Re: ora-12705 - Invalid or unknown NLS parameter value specified [message #33813 is a reply to message #26991] Wed, 03 November 2004 08:18 Go to previous messageGo to next message
Yo
Messages: 3
Registered: December 2002
Junior Member
I had a similar issue and deleting NLS_LANG solved the problem.
Re: ora-12705 - Invalid or unknown NLS parameter value specified [message #264795 is a reply to message #30019] Tue, 04 September 2007 10:47 Go to previous messageGo to next message
mr3953
Messages: 1
Registered: September 2007
Location: SAINT LOUIS
Junior Member

Where exactly do I have to delete NLS_LANG under ORACLE folder in the registry or is it in more then one location.

Thanks
  • Attachment: NLS.doc
    (Size: 67.50KB, Downloaded 8135 times)
Re: ora-12705 - Invalid or unknown NLS parameter value specified [message #264797 is a reply to message #264795] Tue, 04 September 2007 10:50 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
if your getting Ora-12705 error then unset NLS_LANG parameter.


on linux
export NLS_LANG=

on windows
set NLS_LANG=


regards
Taj
Re: ora-12705 - Invalid or unknown NLS parameter value specified [message #264798 is a reply to message #264795] Tue, 04 September 2007 10:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
In the registry.
In environment variables.

Regards
Michel
Re: ora-12705 - Invalid or unknown NLS parameter value specified [message #454046 is a reply to message #26991] Mon, 03 May 2010 15:49 Go to previous message
FOSDTAMA
Messages: 4
Registered: May 2010
Location: Venezuela
Junior Member
Try this...
check if exist into windows registry (regedit) the oracle_home
Example
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
ORACLE_HOME=D:\Appls\Oracle
if not create one.

and add the path into the windows variable PATH adding bin folder
example D:\Appls\Oracle\bin
Control Panel -> System -> Advanced Options -> Environment variables - > system variables -> path

Previous Topic: Sysdate in where clause
Next Topic: PL/SQL Progressively Slower
Goto Forum:
  


Current Time: Thu Feb 06 17:21:48 CST 2025