Re: Oracle SQL*Net failing for multiple IP addresses

Fred Furia wrote:

> Has anyone out there tried running Oracle Server 7.3 on NT Server 4.0,
> and
> had problems arise with SQL*Net? I can get SQL*Net aliases to work
> fine
> when the server has only one IP address, but if I add a second IP
> address
> using NT's network control panel and reboot, SQL*Net connections stop
> working.
>
> This happens whether I use separate network cards (each with its own
> IP
> address) or one network card with multiple IP addresses, and I am at a
>
> loss. Any leads are appreciated, as this has become a major obstacle
> for
> me.
>
> Thanks,
>
> Fred
> --
> --
> ------------------------------------------------------------------------
>
> Frederick A. Furia, Jr. CS Grad Alumnus -- U. of
> Penn
> <fred_at_dagobah.stwing.upenn.edu> Fan -- The Philadelphia
> FLYERS
> ------
> --------------------------------------------------------------------

Fred,

We've got this exact configuration working at my customer's site. You'll need to change your listener.ora (server) and tnsnames.ora (client & server) files to reflect the two NIC cards with different IPs. You'll also need to stop and start the listener service as well.

--
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.