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
