Re: tnsnames, TNS-03505

From: Helmut Schneider <jumper99_at_gmx.de>
Date: Wed, 22 Aug 2007 10:00:30 +0200
Message-ID: <5j28ovF3qavkgU1@mid.individual.net>

EdStevens <quetico_man_at_yahoo.com> wrote:

> On Aug 21, 4:08 am, "Helmut Schneider" <jumpe..._at_gmx.de> wrote:

>> 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. :)
> But you are on a client machine right? The database is not on that > client machine, right?

Yes, 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

I see.

Thanks, Helmut

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

Received on Wed Aug 22 2007 - 03:00:30 CDT