Re: Database links

did you defined a TWO_TASK (PROTOCOL is THEN BEQ) What protocol is defined in the LISTENER for Myserv (IPC) ?

B. Polarski

In article <88s8b4$kpj$1_at_nnrp1.deja.com>,   Frank <frankd28_at_my-deja.com> wrote:
> 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.
>

--
B.Polarski

http://www.geocities.com/bpolarsk
Email : bpolarsk_at_yahoo.com

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