Re: tnsnames, TNS-03505

From: <fitzjarrell_at_cox.net>
Date: Mon, 20 Aug 2007 10:57:21 -0700
Message-ID: <1187632641.911400.19220@22g2000hsm.googlegroups.com>

On Aug 20, 11:09 am, "Helmut Schneider" <jumpe..._at_gmx.de> wrote:
> Hi,
>
> what does a tnsnames.ora have to look like on a client? I copied a working
> tnsnames.ora from a server (Windows 2003, 10g) to my client (Windows XP,
> also 10g) but still can't tnsping the SID, TNS-03505.
>
> PROD_SID =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = myhost.domain.tld)(PORT = 1521))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = prod_sid.oracle_domain.domain.tld)
> )
> )
>
> Thanks, Helmut
>
> --
> No Swen today, my love has gone away
> My mailbox stands for lorn, a symbol of the dawn

A tnsnames.ora file, properly configured, should be transferrable to any client or server in the network. That being said a valid sqlnet.ora may also be required; I expect you didn't copy that over from your Windows 2003 server.

David Fitzjarrell Received on Mon Aug 20 2007 - 12:57:21 CDT