Re: Hopefully stupid db link question

<mundayb_at_my-deja.com> wrote in message news:955ae0$2ij$1_at_nnrp1.deja.com...
> Hi,
>
> Hopefully I am just making an elementary mistake, but I can't seem to
> find it. I'm trying to create a dabatase link, and even though it
> appears as though the link is created, when I try to use it I keep
> getting a 12154 TNS:could not resolve service name error.
>
> My tnsnames.ora file contains:
> CT42A.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = p3apbtk3)(PORT = 1521))
> (CONNECT_DATA = (SID = ct42))
> )
> CT42JTEST1.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = ct42jtest)(PORT = 1521))
> (CONNECT_DATA = (SID = ct42))
> )
>
> and I've been using the syntax
>
> create public database link ct42a
> connect to USERNAME identified by PASSWORD
> using 'CT42A';
>
> Does anyone have any ideas what;s wrong. I can connect to both
> databases without any trouble using SQL+ and Net*.
>
> Thanks in advance
>
> Bryan
> bryan.munday_at_parexel.com
>
>
> Sent via Deja.com

Is this your tnsnames.ora on your client or on your server? The service name has to be known to the server also, as the server connects on your behalf, your client doesn't connect to the remote database.

Hth,

Sybrand Bakker, Oracle DBA

> http://www.deja.com/
Received on Mon Jan 29 2001 - 22:52:46 CST