Re: running public DBLINKs

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Tue, 09 Dec 2003 21:45:17 +0100
Message-ID: <c1dctv0ia9sov0m86ks3hrsj9akll7qvlj@4ax.com>

On Tue, 9 Dec 2003 13:38:15 +0100, "Jon" <aaa_at_bbb.ccc> wrote:

>I have created a "public" & "fixed user" DBLINK. In the "using connect
>string" clause of the creation statement, I have use a entry from the
>tnsnames.ora. When trying to run the dblink, it returns the following "...
>ERROR at line 1:
>ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
>descriptor"
>

12514 signifies the service_name = clause in the connect data section of tnsnames.ora doesn't match the service name of the database.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Dec 09 2003 - 14:45:17 CST