Re: sqlplus foo/bar@baz works; connect foo/bar@baz doesn't

No you dont...DB_LINKs are a different animal altogether....

One possibility ( which I think you have addressed) is that your SqlPlus uses a different tnsnames.ora ( if you PATH has more than one (Oracle_home)/bin entry, SqlPlus will run from the first one and that Oracle_home/network/admin is where it will look for the tnsnames.ora file;once connected this could change depending on where you are on the client while in SqlPlus

Ban Spam <ban-spam_at_operamail.com> wrote:

>rene.nyffenegger_at_gmx.ch (Rene Nyffenegger) wrote in
>news:a6d06107.0109182307.25c7aa84_at_posting.google.com:
>
>> Hi
>>
>> I have this weird problem on W2K: If I open a cmd box and
>> type
>> sqlplus foo/bar_at_baz, I can connect to baz as foo, as expected.
>> But if I do a
>> connect foo/bar_at_baz
>> in the (same) sqlplus prompt I get an ORA-12154 error (german:
>> TNS: Der Service Name konnte nicht aufgeloest werden,
>> english translation would be something like
>> TNS: could not resolve service name)
>>
>> SQLPLUS is 9.0.1.0.1 for Windows, while
>> the DB Server is 8i on HP.
>>
>> What can cause this?
>>
>> AHA
>> Rene
>
>The first example of invoking sqlplus on the command
>line ONLY needs an entry in TNSNAMES.ORA file.
>
>After you are "inside" the sqlplus application,
>you need BOTH an entry in TNSNAMES.ORA file, plus
>a database link (DB_LINK) defined inside the instance.
>
>HTH & YMMV!
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Thu Sep 20 2001 - 09:41:14 CDT