tnsnames, TNS-03505

From: Helmut Schneider <jumper99_at_gmx.de>
Date: Mon, 20 Aug 2007 18:09:43 +0200
Message-ID: <5itsm7F3rnja1U1@mid.individual.net>

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 

Received on Mon Aug 20 2007 - 11:09:43 CDT