Exactly what i am looking for by the looks of it, now jsut to find out how to do it on hp-ux 11.23 for oracle EE 10.2.0.2 in a RAC environment. G > 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@xxxxxxxxxxxx> 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@xxxxxxxxxxxx >> >> 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 >> >> -- >> //www.freelists.org/webpage/oracle-l >> >> >> > ------------------------------------------------ George george@xxxxxxxxxxxx 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 -- //www.freelists.org/webpage/oracle-l