thanks a lot to all who responded !!!
DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -----Original Message----- Sent: Mon, May 20, 2002 3:27 PM To: [EMAIL PROTECTED] Oracle has a registry setting that will force all traffic for a session through the same port that the listener connection was made on (e.g. 1521). Place the USE_SHARED_SOCKET parameter in the registry under HKEY_LOCAL_MACHINE:Software:Oracle with a value of TRUE, and restart Oracle and the listener for it to take effect. It also doesn't hurt to set this parameter as a system environment variable as well. --------------- Jason Heinrich, OCP Oracle Database Administrator Pensacola Christian College (850) 478-8496 x2509 [EMAIL PROTECTED] > From: Andrey Bronfin <[EMAIL PROTECTED]> > Date: Sunday, May 19, 2002 10:36 AM > Subject: Connecting to DB from behind a firewall. > > Dear list ! > It's an Oracle 8.0.5 on Win NT question: > We want to put our database server behind a firewall. > The problem is the clients that need to connect to our DB from the "outer > world". > Now , i know that the Oracle listener can choose any port when passing the > connection to the Oracle server. > That means , that theoretically all the ports should be open on the firewall > in order to allow client connections. > Sounds illogical. > So, is there a way to limit the ports range used by the listener when > passing the connections to the Oracle server ? > I do not want to use "connection manager" etc.. > > thanks a lot ! > > DBAndrey > > * 03-9254520 > * 058-548133 > * mailto:[EMAIL PROTECTED] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).