Re: SQL*Net thru Linux IP Forwarding

From: Greg Stark <greg-spare-1_at_mit.edu>
Date: 2000/03/31
Message-ID: <873dp6kh1w.fsf@HSE-MTL-ppp43091.qc.sympatico.ca>#1/1

stuart.crawford_at_home.com writes:

> When I attempt to connect using SQL*Net I can't...I understand that you
> initially connect on 1521/1526 and then the listener will tell the
> client to reconnect on Port ####...my question is to this newsgroup is
> there away for the listener to give out specific Port numbers?

I think it will only do this if you have MTS set up. You'll have to disable MTS for this connection by doing something like this in your tnsnames.ora, note the last line:

dedicated =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = gateway)
          (Port = 1521) 
        )

    )
    (CONNECT_DATA = (SID = ORCL)
    (SRVR=DEDICATED)
    )
  )

-- 
greg

Received on Fri Mar 31 2000 - 00:00:00 CST