Re: tnsnames, TNS-03505

On Aug 21, 4:08 am, "Helmut Schneider" <jumpe..._at_gmx.de> wrote:
> 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

But you are on a client machine right? The database is not on that client machine, right?
Check Chapter 2 of Oracle Database Net Services Administrator's Guide. There it will be explained.

c:> sqlplus username/password_at_net_service_name Received on Tue Aug 21 2007 - 12:44:54 CDT