Re: Database links

Is xyz_link the sid of your database? It doesn't look like it and I believe this needs to be the case. Try renaming/creating your link as mysid.

Good luck,
Frank

In article <38B17A05.D0821AD9_at_Unforgettable.com>,   K Stahl <BlueSax_at_Unforgettable.com> wrote:
> It has been a while since I've needed to work with a database link and
> apparently there is some detail that I'm missing.
>
> I've created a database link like this:
>
> create public database link xyz_link
> connect to myid identified by mypass using 'myserv'
>
> myserv is a database alias in the tnsnames.ora on the server where
I've
> created the link:
>
> myserv =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (HOST = 123.123.123.12)
> (PORT = 1521)
> )
> )
> (CONNECT_DATA =
> (SID = mysid)
> )
> )
>
> (I've dummied the IP address here, but I have the actual IP address in
the
> file. mysid is also a dummied name but I have the correct one in the
> file.).
>
> Once it was created I could do like this:
>
> connect myid/mypwd_at_myserv
>
> and got a connection, so that told me that the tnsnames.ora entry was
> correct and that the listener is running on the remote machine. But
when I
> tried this:
>
> select * from mytable_at_xyz_link
>
> I received the message:
>
> ERROR at line 1:
> ORA-12666: Message 12666 not found; product=RDBMS; facility=ORA
>
> I tried using oerr to look up ora-12666, but there was no message. I
then
> tried TNS as a facility and got this:
>
> 12666, 00000, "Dedicated server: outbound transport protocol different
from
> inbound"
> // *Cause: The protocol specified for an externally-identified
outbound
> // connection from a dedicated server (database link) was not
the
> same
> // as that used for the inbound connection. It is not
possible for
> // SQL*Net to authenticate a proxy connection that uses a
protocol
> // that is different from that which was used for the
connection
> to
> // the dedicated server.
> // *Action: Specify the same protocol in the SQL*Net connect string or
> alias
> // for the outbound connection as that used for the inbound
> // connection
>
> But I'm not sure whether this is relevant since the original error was
> reported as ORA-12666 not TNS-12666.
>
> Hopefully this is enough information. Can anyone tell me what I'm
doing
> wrong?
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 21 2000 - 14:48:37 CST