Re: weird problem with database link and synonym

From: craig.ballingall <a_at_b.com>
Date: Mon, 1 Oct 2001 22:20:21 +0100
Message-ID: <3bb8dde6_1@mk-nntp-1.news.uk.worldonline.com>

sounds like its looking to a service called q1

are you entering "sqlplus scott/tiger @q1" or sqlplus "scott/tiger_at_q1"

if i'm being dopey just ignore me, i've been sat if front of Microsnot SQL for 6 months
"Anonymous Developer" <orakcle_at_yahoo.com> wrote in message news:de75c082.0110010251.3934ea1f_at_posting.google.com...
> Here is the problem:
>
> ------------------------------
> $ sqlplus scott/tiger
>
> SQL> CREATE SYNONYM W_T FOR W_T_at_DBL;
> ------------------------------
>
> Now, I am able to run the follwing query within sqlplus session:
>
> ------------------------------
> SQL> SELECT * FROM w_t ;
> ------------------------------
>
> But the same query from the command line and SQL script file
> (as below)
> ------------------------------
> $ cat > q1.sql
> SELECT *
> FROM w_t;
> <Ctrl-D>
> $ sqlplus scott/tiger @q1
> ------------------------------
>
> produces the following well-known error:
> ORA-12154: TNS:could not resolve service name
>
> Besides, "tnsping DBL" succeeds.
>
> Platform: Oracle 8.1.6 / Linux 2.2.16
>
> Any idea?
Received on Mon Oct 01 2001 - 16:20:21 CDT