Re: tnsnames, TNS-03505

jumpe..._at_gmx.de <jumpe..._at_gmx.de> wrote:
> 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)
>> )
>> )
>
> 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.

OK, did so, can tnsping the host now, but with sqlplus I get an ORA-12560:

C:\>sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 21 11:00:08 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:^C
C:\>

ORACLE_SID is set and of course I can telnet the machine on TCP 1521. :)

Helmut

-- 
No Swen today, my love has gone away
My mailbox stands for lorn, a symbol of the dawn