Re: client connection problem

From: Annie K. <annie.keslassy_at_amig-group.com>
Date: Wed, 13 Feb 2002 11:54:38 +0100
Message-ID: <3C6A45EE.8030504@amig-group.com>

I removed the nls_lang entry in the registry and connection to database 8.0.4 works,
But I also tried a connection to a oracle db 7.3 with sqlplus scott/tiger_at_test7 and got an error ora-01005 null password given
but tnsping test7 works!!
Thanks a lot for your help

Sybrand Bakker wrote:

> Adding to Howards comments
> NLS variables for the Winblows client exist in
> hkey\local_machine\software\oracle in the registry
> On logon they are read by the client which fires alter session statements.
> You might also run into issues because your clients is some 5 or 6 releases
> later than your (desupported) database server 8.0.4
>
> Hth
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
> "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
> news:3c6963e1$0$24585$afc38c87_at_news.optusnet.com.au...
>

>>From the doco:
>>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
>>
>>Make friends with http://technet.oracle.com - it has all the documentation
>>for 8i (and 9i, of course).
>>
>>Regards
>>HJR
>>
>>
>>"Annie K." <annie.keslassy_at_amig-group.com> wrote in message
>>news:3C6949DD.7090909_at_amig-group.com...
>>
>>>I just installed Oracle client 8.1.7 on my nt4workstation pc
>>>In net8 assistant I defined a service name=test,sid=orcl,tcp/ip
>>>host=server name port=1521.My database is 8.0.4
>>>Then I choosed sqlplus :
>>>username:scott
>>>password:tiger
>>>string:test
>>>and got error ora-12705:invalid or unknown nls parameter value given,
>>>thanks for helping
>>>
>>>
>>

>
>
Received on Wed Feb 13 2002 - 04:54:38 CST