database link - ora 12666

From: Fred Pierce <fpierce_at_avialantic.com>
Date: 1997/12/19
Message-ID: <349A8018.41C6@avialantic.com>#1/1

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