My TNSNAMES.ORA file contains an sid =ORCL
I removed the entry NLS_LANG from HKEY_LOCAL_MACHINE - ORACLE.
it was set to french
and now my connection to database 8.0 is ok.
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
Mau wrote:
> This error has nothing to do with sqlnet, so it is not necessary to provide
> tnsnames.
> Better check your client's registry what NLS_LANG's value. Try to remove
> this from HKEY_LOCAL_MACHINE - ORACLE.
>
> "damorgan" <dan.morgan_at_ci.seattle.wa.us> schreef in bericht
> news:3C694F50.17989FA7_at_ci.seattle.wa.us...
>
>>Post your TNSNAMES.ORA file.
>>
>>Likely it contains SERVICE_NAME rather than SID.
>>
>>Daniel Morgan
>>
>>
>>
>>
>>"Annie K." wrote:
>>
>>
>>>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:42:29 CST
