Re: Listener with 2 TCP/IP for same instance

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 29 Jul 1999 21:06:06 +0200
Message-ID: <933275158.26623.0.pluto.d4ee154e@news.demon.nl>

Define two servicenames in your listener.ora and tnsnames.ora, the first one using the first IP address as the host address, the second the second IP address. Of your course that needs to happen at the clients tnsnames.ora also.
To make sure traffic is distributed, create a registry key LOCAL in HKLM\software\oracle. One half of your users will have set that to the first service name, the other half to the second. Hopefully this should do it.

Hth,

Sybrand Bakker, Oracle DBA

<raguc_at_yahoo.com> wrote in message news:7nq62d$va0$1_at_nnrp1.deja.com...
> We have one instance of Oracle 8 running on NT box. We want to take
> advantage of 2 TCP/IP addresses alloctaed to the box so as to split the
> traffic.
>
> 1. How shall we do that?
> 2. How to ensure thatthe traffic will be divided between the two
> TCP/IPs?
>
> Any ideas are welcome
>
> Thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jul 29 1999 - 14:06:06 CDT