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).
