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