weird problem with database link and synonym

From: Anonymous Developer <orakcle_at_yahoo.com>
Date: 1 Oct 2001 03:51:53 -0700
Message-ID: <de75c082.0110010251.3934ea1f@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 - 05:51:53 CDT