Re: 10g: InstantClient tnsnames.ora in registry

From: Micodat <info_at_micodat.com>
Date: 13 Oct 2005 07:40:29 -0700
Message-ID: <1129214429.421348.272350@g47g2000cwa.googlegroups.com>

Hi Laurenz,

I found it:

I don't need a file sqlnet.ora or an env-var 'set TNS_ADMIN=...' if I'm using the registry entries.

My error was, that I had to restart the computer (not the server) after the changes. I'm using a local PHP script with oci8-support and Apache2, so (maybe) it's enough to restart Apache/PHP after the registry-update.

Thanks for your help.
Frank

Laurenz Albe schrieb:

> 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:40:29 CDT