Re: 10g: InstantClient tnsnames.ora in registry

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 13 Oct 2005 14:07:39 GMT
Message-ID: <1129212456.366451@proxy.dienste.wien.at>

Micodat <info_at_micodat.com> wrote:
> Server: Oracle 10g / Linux SLES 9.2
> WS: WinXP sp2, InstantClient 10.2.0.1
>
> I can connect using the full Connection-String:
> (DESCRIPTION = (ADDRESS_LIST = ... ) )
>
> I've now installed the tnsnames.ora in c:\Windows:
>
> ORACLEDYNDNS =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = company.dyndns.org)(PORT =
> 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = orcl)
> )
> )
>
> .. and put the following into the registry:
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
> "NLS_LANG"="GERMAN_GERMANY.WE8MSWIN1252"
> "TNS_ADMIN"="C:\\Windows"
>
> But I can't connect with "ORACLEDYNDNS" to the Database.
>
> Do you see my error?

Turn on client tracing and have a look at the trace file.

Does it work if you 'set TNS_ADMIN=...' in the environment?
Does it work if you create an sqlnet.ora file that tells the client to look into tnsnames.ora?

Yours,
Laurenz Albe Received on Thu Oct 13 2005 - 09:07:39 CDT