RE: ODBC port

Barbara,

ODBC still uses Sqlnet as the transport, so you have to allow 1521 incoming, and all TCP high ports out.

If allowing all tcp high ports out is not acceptable to the network guys, you can also force the Oracle listener to use the same connection for both incoming and outgoing traffic. To do that, set this registry entry -

 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEx\USE_SHARED_SOCKET

to a value of TRUE, where HOMEx is the Oracle home of your listener. If you have multiple listeners, and you want to allow all of them to work with the firewall, it might be easier to just create a system environment variable

USE_SHARED_SOCKET=TRUE it will have the same effect.

In either case, you have to reboot after making the change.

Keep in mind if you use port sharing, the client is using the same connection to communicate with the database that it used to connect to the listener. Hence, if you shutdown the listener you will kill *all* current ODBC and sqlnet connections to your database (I think, I'm not positive on this point). That's one drawback of doing it. Frequently the network guys are much less concerned about outgoing connections than incoming, so if your firewall already allows outgoing connections on ports > 1024, I would opt out of using socket sharing. But, if its not already allowing ports > 1024, I wouldn't open a big hole just for the listener, I'd choose to use socket sharing in that case.

HTH, Beth

-----Original Message-----
Sent: Tuesday, January 29, 2002 5:11 PM
To: Multiple recipients of list ORACLE-L

Sorry for the OT post, but I cannot find this elsewhere. We need to get connectivity from outside our firewall into an Oracle database using ODBC.

Our network guy thinks there should be a port designation or something to allow these odbc connects through.
I'm clueless.
Any ideas where we can look to find out how to configure this?

Thanks in advance for any help.

Barb

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: bbaker_at_denvernewspaperagency.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: Beth.Seefelt_at_TetleyUSA.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).