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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > >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: [EMAIL PROTECTED] > > > > > > 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: [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). > > > > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: Don Granaman > > INET: [EMAIL PROTECTED] > > > >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: [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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Regina Harter > INET: [EMAIL PROTECTED] > > 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: [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). >
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman INET: [EMAIL PROTECTED]
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: [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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Regina Harter INET: [EMAIL PROTECTED]
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: [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).