Re: SqlNet Response ports

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" <ORACLE-L_at_fatcity.com> 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" <ORACLE-L_at_fatcity.com>
> >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_at_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_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.net
> >--
> >Author: Don Granaman
> > INET: granaman_at_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_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.net
> --
> Author: Regina Harter
> INET: rharter_at_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_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.net
-- 
Author: Don Granaman
  INET: granaman_at_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_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).