Re: Listening at two different IP adresses.

"jean-paul" <jpchausseau_at_cgf-pharmatechREMOVE.com> wrote in message news:<995553470.598343_at_news.aei.ca>...
> The server running Oracle has two netcards. The first has its adress set as
> 192.168.0.101 (used for connections from the LAN). This was the only netcard
> when Oracle was installed on the server. The second card, installed at a
> later time, has its adress set as 192.0.100. This second card is configured
> for tcp/ip connections exclusively, and is intended for connections from the
> WAN.
>
> While I am able to connect clients to Oracle through the 192.168.0.101
> adress, I am unable to connect them by using 192.168.0.100 although the card
> is definitely fully functional (it is used for accessing the web server from
> the WAN). The message I get is 'NO LISTENER', although I added the
> 192.168.0.100 adress to the listener's configuration, stopped the service
> (Windows 2000) and re-started it.
>
> Could someone help me on this issue?
>
> Many thanks in advance,
>
> Jean-Paul

Hi !
You just have to add a line in your listener.ora parameter file. you should already have something like this : listener=
  (address=(protocol= tcp)(host= 192.168.0.101)(port= 1521)) add this one :
  (address=(protocol= tcp)(host= 192.168.0.100)(port= 1521)) and stop/start the listener.

Bye Received on Thu Jul 19 2001 - 12:33:36 CDT