Re: Can't connect to remote database

Unset ORACLE_SID and set TWO_TASK to be db1, with the tnsnames as you originally had it.

paul_rogers6_at_my-deja.com wrote:

> Once again thanks for your prompt reply.
>
> I amended the db1 tag in tnsnames.ora to ORCL as you suggested. Using
> sqlplus with User1/password results in the same error messages.
> However User1/password_at_db1 results in
>
> ORA-12154: TNS: could not resolve service name
>
> as you would expect, and User1/password_at_ORCL connects fine.
>
> It almost appears that it is not using the tnsnames.ora file unless the
> @???? is included in the login.
>
> Is this a missing environment variable perhaps?
>
> Once again many thanks.
>
> Paul
>
> In article <3a7f0577_at_news.iprimus.com.au>,
> "Howard J. Rogers" <howardjr_at_www.com> wrote:
> > OK, well you tnsnames.ora explains why the connect "@db1" works -
 because db1
> > is the tns alias for the ORCL sid, and the .ora file explains nicely
 where
> > and how to connect there.
> >
> > When you just connect as User1, though, you really ARE relying on
> > ORACLE_SID, and since that's set to ORCL, and since your tnsnames.ora
 says
> > not one word about how to connect to something called ORCL, it can't.
> >
> > A couple of things to try. First edit the tnsnames, and change the
 line
> > where it says db1= to read ORCL=. See how you get on then. Try a
 connect
> > User1/password and note the results. And then try a connect
> > User1/password_at_ORCL and again note the results.
> >
> > If that works, you could try cutting and pasting the 9 lines you've
 shown
> > here, and then editing that same line again, so that you end up with
 one set
> > of lines saying "db1 = " and one set of lines reading "ORCL =". You
 should
> > then have the choice of what name you wish to connect by (though both
 will
> > actually connect to the ORCL Instance.
> >
> > Let me know how you get on
> >
> > Regards
> > HJR
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Feb 08 2001 - 17:42:10 CST