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" <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).
--
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).
Received on Tue Feb 25 2003 - 11:59:02 CST
