Re: ORACLE9 Windows 2003 TCP Port Sharing
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: brian@xxxxxxxxxxx
- Date: Fri, 12 Aug 2005 09:20:50 +0100
On 8/12/05, brian <brian@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
