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: ORACLE9 Windows 2003 TCP Port Sharing

Re: ORACLE9 Windows 2003 TCP Port Sharing

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 12 Aug 2005 09:20:50 +0100
Message-ID: <7765c8970508120120b855151@mail.gmail.com>


On 8/12/05, brian <brian_at_techcat.com> wrote:
> Hello all.
> We are on ORACLE 9.2 on AIX 5.2. We would like to connect to an oracle 9.2
> database on Windows 2003.
> The windows box is in a DMZ on the network. The AIX machine is in a private
> address space behind the firewall.
> We only want the Windows box to talk to the AIX machine on windows port
> 1521, and the router, firewall, etc are configured to only only that port
> through to AIX.
>
> The problem is that oracle on windows by default does not use port sharing,
> so it will dynamically allocate a new tcp port for the connection.

I think you have it backwards :(. The redirects on windows are done by the listener, and not the client. The USE_SHARED_SOCKET solution applies if the database server (technically the server running the listener but they are normally the same) is running on windows.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 12 2005 - 03:22:54 CDT

Original text of this message

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