Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: running public DBLINKs
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