Re: Can I bind second IP Address on Oracle Server ?

From: Christopher Denney <chris_at_pagan.net>
Date: Mon, 15 Nov 1999 10:45:37 -0700
Message-ID: <B45594D1.38F1%chris@pagan.net>

in article 80oq2n$3b3k$1_at_member.gcn.net.tw, Jedi Master Liao at jedi_at_ms17.hinet.net wrote on 11/15/99 04:19:

> I have two network, one is registed IP the other one is private IP.
> While I bind both of those IP on my Oracle Server, some happened.
> I can't connect from clients that use private IP. ( But registed IP is
> work. )
> After I remove the registed IP from Oracle Server, the clients use private
> IP is work.
>
> Could anyone tell me why? Please!
>
> My Oracle version is 7.0 for NT Server
>
> Thanks.
>
>

Did you put an entry for both addresses in the listener.ora file?

I use oracle on a Sun platform, but there should be a file with the listener configuration in in someplace on the NT box. For example:

LISTENER=

 (ADDRESS_LIST= 
 (ADDRESS= 
 (PROTOCOL=TCP) 
 (host = hostname.domain.top)
 (port = 1521)) 
 (ADDRESS= 
 (PROTOCOL=TCP) 
 (host 192.168.xxx.xxx)
 (port = 1521))

)

Cd -- chris_at_isis.bbmbc.org------ Christopher Denney chris_at_pagan.net----------- -- One is always a long way from solving a problem until one actually has the answer. -Stephen Hawking

Received on Mon Nov 15 1999 - 11:45:37 CST