Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: running public DBLINKs

Re: running public DBLINKs

From: Keith Jamieson <keith_jamieson_at_hotmail.com>
Date: Tue, 9 Dec 2003 13:09:52 -0000
Message-ID: <yQjBb.132$HR.25@news.indigo.ie>


The entry must be on the Tnsnames.ora file on the server, not the client machine.
Can you, on the Server, connect through SQLPLUS with this entry?

"Jon" <aaa_at_bbb.ccc> wrote in message news:br4frj$b21$1_at_unbe.sarenet.es...
> 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"
>
>
Received on Tue Dec 09 2003 - 07:09:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US