Pete Finnigan's Oracle Security Forum


    
      
        Pete Finnigan's Oracle Security Forum
        (http://www.petefinnigan.com/forum/yabb/YaBB.cgi)
      

        Oracle General >> General Oracle questions >> Oracle (on NT) port Redirection
        
(Message started by: Pete Finnigan on Jan 3^rd, 2006, 6:57pm)

Title: Oracle (on NT) port Redirection
Post by Pete Finnigan on Jan 3^rd, 2006, 6:57pm

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_thread/thread/402afb603455d151/9140b81de6d6bde7?lnk=st&q=sqlnet+port+redirection&rnum=3&hl=en#9140b81de6d6bde7

Title: Re: Oracle (on NT) port Redirection
Post by Pete Finnigan on Jan 5^th, 2006, 5:59pm

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

Title: Re: Oracle (on NT) port Redirection
Post by Pete Finnigan on Apr 4^th, 2006, 10:49pm

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