Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h1PLaaD08356 for ; Tue, 25 Feb 2003 15:36:36 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h1PLaZh08351 for ; Tue, 25 Feb 2003 15:36:36 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id KAA51937; Tue, 25 Feb 2003 10:18:20 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00558DB5; Tue, 25 Feb 2003 09:59:02 -0800 Message-ID: Date: Tue, 25 Feb 2003 09:59:02 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Regina Harter Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Regina Harter Subject: Re: SqlNet Response ports Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Content-Transfer-Encoding: 7bit Thank you very much for the information Don. We are using 9i and I think MTS, though I am not certain of that. I will pass this on to our DBA, I am sure he will find this helpful. At 06:03 PM 2/24/2003 -0800, you wrote: >I guess I should have asked also: > >1) what version of Oracle are you using? >2) Is this using MTS or dedicated servers? > >Since this is Linux, there are three cases: >1) Dedicated severs - there is no redirection. Client talks to dedicated >server on listener port. >2) MTS & Oracle 9i - ditto >3) MTS & pre-9iR2 - MTS does redirect by default 0 to some (pseudo-)random >port above 1024 but this may be overridden by adding a pfile (init.ora) >entry like: >mts_dispatchers="(address=(protocol=tcp)(host=yourhostname)(port=443))(dispa >tchers=1)" > >See: Metalink Bulletin: 1016349.102 & Note: 163082.999 >Go to advanced search and search on "Doc ID" with these IDs. > >There may be multiple mts_dispatchers= lines in the init file and there may >be other parameters of interest. For the sake of this particular issue >though, the pertinent item is the ("port=443)" clause. It would force MTS >redirects to port 443. > >Actually, this parameter is obsoleted by the initiiation parameter: > local_listener=listener_name_alias >where tnsnames.ora has an entry like: > listener_name_alias=(address=(protocol= tcp)(host= yourhostname)(port= >443))... >and other appriopriate MTs initialization parameters. > >Please see the documentation for your version for options. > >Good luck! >Don Granaman >certified OraSaurus > >----- Original Message ----- >To: "Multiple recipients of list ORACLE-L" >Sent: Monday, February 24, 2003 12:39 PM > > > > Redhat Linux 7.2 > > > > At 07:28 PM 2/21/2003 -0800, you wrote: > > >What platform is this? Windows? > > > > > >Don Granaman > > >OraSaurus > > > > > >----- Original Message ----- > > >To: "Multiple recipients of list ORACLE-L" > > >Sent: Friday, February 21, 2003 5:48 PM > > > > > > > > > > Hi listers, > > > > > > > > Here is a question my client asked me, that I can't seem to find the > > >answer > > > > to on metalink, mostly because I am not sure how to frame the search > > > > query. If you don't know what NMCI is, just know that it is a >government > > > > program that is establishing control over the network which our >database > > > > servers are on. Anyone have any ideas or advice for me? > > > > > > > > TIA, Regina > > > > > > > > Then, one of the NMCI technical guys mentioned that NMCI PCs wouldn t > > >allow > > > > inbound/outbound 1521 traffic (SQLNET). Hence, no NMCI user would be >able > > > > to use any client/server application. Wow, that s a major problem. >There > > > > are a few possible solutions. > > > > > > > > 1. Configure the database server to listen on port 443, because >NMCI > > > > allows 443. But, SQLNET uses random high order ports on the > > > > return. Anybody know if you can configure SQLNET to use only 443 on >the > > > > response? > > > > > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > -- > > > > Author: Regina Harter > > > > INET: rharter@emc-inc.com > > > > > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > > > San Diego, California -- Mailing list and web hosting services > > > > --------------------------------------------------------------------- > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > to: ListGuru@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.net > > >-- > > >Author: Don Granaman > > > INET: granaman@cox.net > > > > > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > >San Diego, California -- Mailing list and web hosting services > > >--------------------------------------------------------------------- > > >To REMOVE yourself from this mailing list, send an E-Mail message > > >to: ListGuru@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.net > > -- > > Author: Regina Harter > > INET: rharter@emc-inc.com > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: ListGuru@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.net >-- >Author: Don Granaman > INET: granaman@cox.net > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com >San Diego, California -- Mailing list and web hosting services >--------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@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.net -- Author: Regina Harter INET: rharter@emc-inc.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).