Re: Linux: Problem using sql*plus to talk to remote databases

From: <woerdt_at_my-dejanews.com>
Date: Wed, 04 Nov 1998 14:32:31 GMT
Message-ID: <71pohv$q8f$1@nnrp1.dejanews.com>

In article <slrn73mhjm.55a.rupa_at_gw.rupa.com>, rupa_at_rupa.com wrote:

> I have Oracle 8 for Linux installed on my system. SQL*Plus works fine
> for local databases, but I cannot connect to a remote Oracle 7.3.3
> database. I get an error saying username/password is incorrect.
what error ?

> The SQL*Net config is correct. I can create a dblink in my database
> and select data from the remote db w/out problems.
>
> I have tried connecting with:
>
> sqlplus user/pass_at_remotedb
>

I had similar problems:
I needed: ORACLE_HOME=<where you put oracle> ORACLE_SID=<remotedb>
and 2 files: tnsnames.ora & tnsnav.ora in network/admin/ [have a look at the samples dir there]
then "sqlplus user/pass_at_remotedb" worked!!

sqlplus did survive frome stoneage into oracle 8 ! even edlin was more powerfull....
han vd woerdt

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 04 1998 - 08:32:31 CST