Auditing an Oracle database for security issues is very important. PeteFinnigan.com provides all of the information and tools that you will need Click here for details of PeteFinnigan.com Limited's detailed Oracle database security audit service Click here for details of PeteFinnigan.com Limited's Oracle Security Training Courses
Cookie Policy:We only use essential cookies on small sections of this website. For details see here.

Welcome, Guest. Please Login.
Nov 23rd, 2017, 7:11am
News: If you would like to register contact the forum admin
Home | Help | Search | Members | Login
   Pete Finnigan's Oracle Security Forum
   Oracle General
   General Oracle questions
(Moderator: Pete Finnigan)
   Oracle (on NT) port Redirection
« Previous topic | Next topic »
Pages: 1  Reply | Notify of replies | Send Topic | Print
   Author  Topic: Oracle (on NT) port Redirection  (Read 5985 times)
MikeD1
PeteFinnigan.com Newbie
*



I love YaBB 1G - SP1!

   
View Profile |

Posts: 1
Oracle (on NT) port Redirection
« on: Jan 3rd, 2006, 6:57pm »
Quote | Modify

Does anyone know what range of ports Oracle will use when using SQL*Net port redirection?  
 
I've seen reports that the port Oracle chooses is totally random, but I doubt oracle will choose port 0.  Rather I suspect Oracle ask the OS to open one that is not in use, which puts you in the 1024-65535 range.  Does anyone happen to know for sure?
 
also, has anyone ever seen a "modern" install of oracle running its listener on port 66?
http://groups.google.com/group/comp.databases.oracle.server/browse_threa d/thread/402afb603455d151/9140b81de6d6bde7?lnk=st&q=sqlnet+port+redirection&rnum=3&hl=en#9140b81de6d6bde7
IP Logged
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
Posts: 309
Re: Oracle (on NT) port Redirection
« Reply #1 on: Jan 5th, 2006, 5:59pm »
Quote | Modify

hi,
 
the USE_SHARED_SOCKET parameter may possibly be an alternative but bear in mind the potential performance issues in using it. There is a discussion of it [url http://www.freelists.org/archives/oracle-l/11-2004/msg00463.html]here[/url]
 
cheers
 
Pete
IP Logged

Pete Finnigan (email:pete@petefinnigan.com)
Oracle Security Web site: http://www.petefinnigan.com
Forum: http://www.petefinnigan.com/forum/yabb/YaBB.cgi
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
Paul Breniuc
PeteFinnigan.com Newbie
*



I love this!

  syntheticbyte  
View Profile | WWW | Email

Gender: male
Posts: 12
Re: Oracle (on NT) port Redirection
« Reply #2 on: Apr 4th, 2006, 10:49pm »
Quote | Modify

Specific MS implementation of sockets will give you this "side effect". It is not a listener issue this, it is an OS (oracle just call some like "create socket") so if this limitation it is possible onOS level...it can be done if not (oracle use specified ports numbers not random... on UNIX just 1521 - default, Win lies the client ... if you check a web server on 80... you'll see 99% of users connected on over 1500 and this is not about web server software)... In fact this will help you improve trafic (Win trick). Using shared_so... may be a sec. issue. as well as a performance one (if not using MTS=shared servers same trick but well oracle done ... in a DBA controlled way- i.e.). Cheers...
« Last Edit: Apr 4th, 2006, 10:52pm by Paul Breniuc » IP Logged
Pages: 1  Reply | Notify of replies | Send Topic | Print

« Previous topic | Next topic »

Powered by YaBB 1 Gold - SP 1.4!
Forum software copyright 2000-2004 Yet another Bulletin Board