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

From: Rupa Schomaker <rupa_at_rupa.com>
Date: Sat, 31 Oct 1998 17:18:46 GMT
Message-Id: <slrn73mhjm.55a.rupa@gw.rupa.com>

I sent an email to Oracle and have received no response. Perhaps someone here as a) experienced the problem and b) solved it.

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.

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

Ive also tried

sqlplus user_at_remotedb

and then supply the password.

Finally, I tried running sqlplus and putting the info in the prompts. In any case, I cannot succesfully connect to a remote db with sqlplus.

Thoughts?

-rupa
Received on Sat Oct 31 1998 - 11:18:46 CST