Re: database link - ora 12666

This is a known bug. Contact Oracle support. They should be able to get you a patch for it.

                                        Rick
                                        Rick Wessman
                                        Middleware Security Products
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com

P.S. You know, the significance of the number didn't occur to until a couple of months after I created it. :-)

Fred Pierce <fpierce_at_avialantic.com> writes:

>
> Oracle rel 7.3.3
> SQLNET v 2.3.3
> alpha unix OSF1 V4
>
> I created a database link from rsirs733_nssdc.world as
> create public database link irand733_nssdc.world
> connect to account identified by password
> using 'irand733_nssdc.world'
>
> I can connect to each instance from the other, and listener shows
> everything ok, but I get
> an ora 12666 (I know - it's the Beast) when attempting a query such as
>
> select * from table_at_irand733_nssdc.world
>
> same error with any other permutations of the command I've tried.
>
> the error text reads thus:
>
> ORA-12666 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 fo SQL*Net to authenticate a proxy connection that uses a
> protocol that is differe
> nt 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 co
> nnection as that used for the inbound connection.
>
> What is this trying to tell me? The only place I see to indicate
> protocols is in tnsnames and listener, both of which indicate TCP.
>
> I'm not terribly experienced with SQLNET and have copy-catted most of
> this stuff from the existing 7.1.6 instances from which I am migrating.
> Any clarification on what else needs to be set and where it might be
> will be appreciated.
>
> thanks,
>
> Fred Pierce
>
> My tnsnames are defined as:
>
> ################
> # Filename......: tnsnames.ora
> # Node..........: nssdc.world
> # Date..........: 03-APR-95 16:20:16
> # Updated.......: 11-FEB-97 by Jane Dowling
> # Updated.......: 04-DEC-97 by Fred Pierce for 733
> ################
>
>
> rsirs733_nssdc.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcpcomm.world)
> (PROTOCOL = TCP)
> (Host = nssdc)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = rsirs733)
> )
> )
>
> irand733_nssdc.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcpcomm.world)
> (PROTOCOL = TCP)
> (Host = nssdc)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = irand733)
> )
> )
>
> ------------------------------------------------------
> Fred Pierce - fpierce_at_avialantic.com
> Mid Atlantic Aviaion on the Web - www.avialantic.com
> MAAM WWII Commemorative Weekend June 5-7 /maamwwii.com
> --------------------------------------------------------
  Received on Fri Dec 19 1997 - 00:00:00 CST