Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Listener configure - port 1521 - how not to handoff to a higher port???

Re: Listener configure - port 1521 - how not to handoff to a higher port???

From: Stuart Lindenmayer <stuart.lindenmayer_at_gmail.com>
Date: Wed, 6 Sep 2006 22:48:39 +1000
Message-ID: <f5c9a7e80609060548i73b329e0p223ce4f0479b9af8@mail.gmail.com>


Hi George,
If you're using Oracle on Windows there is a registry setting USE_SHARED_SOCKET which when set to TRUE will force the listener to receive and respond only on port 1521 - great for strict firewall situations! I'm unsure if there's a *nix equivalent.

Cheers,

Stuart.

On 9/6/06, George <george_at_mighty.co.za> wrote:
>
>
> Hi all
>
> HOW:???
>
> normally the connection process goes something like.
> 1. enter username, password and service name and hit enter.
>
> 2. this makes the sqlplus tool query tnsnames.ora to find where the
> service is.
>
> 3. it approaches/contacts that service via a first contact process via the
> defined service parameters, ip, port and service/sid name. The listener
> replies. connect to the following IP (same on standalone, can be different
> node VIP on RAC) and a taget port number...
>
> 4. sqlplus then goes to supplied ip and port and the user process is
> started and user gets connected.
>
> Now. how can you define the possible range for reconnect/supplied ports to
> connect to OR how can i limit it so that all connections is done via
> 1521... RAC environment
>
> thanks
>
> ------------------------------------------------
> George
>
> george_at_mighty.co.za
>
> You Have The Obligation to Inform One Honestly of the risk, And As a
> Person
> You Are Committed to Educate Yourself to the Total Risk In Any Activity!
> Once Informed & Totally Aware of the Risk,
> Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
>
>
>
> -------------------------------------------
> For super low premiums, click here http://www.webmail.co.za/dd.pwm
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 06 2006 - 07:48:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US