Re: Net8 connection problem through IP translation

Hop Pham <Pham_Hop_at_bah.com> writes:

> Hi,
>
> I ran into a Net8 configuration problem, and wondered if anyone had
> similiar experiences. We have a private lab (IP 10.1.x.x) that connects
> to our company's class B network (156.80.x.x) via a router that does IP
> translation (i.e., Oracle server in the lab with real IP 10.1.x.5 will
> be seen by outside hosts as 156.80.x.5). Here is the trouble scenario:
>
> + Outside Oracle clients (IP 156.80.x.x) can NOT access Oracle server
> (IP 10.1.x.5) inside lab via Net8. From outside host, I can ping inside
> Oracle server, and can also tnsping inside server as well (using
> translated IP 156.80.x.5); Net8 clients (Net8 Assistant & sqlplus)
> failed.
>
> + Inside Oracle clients (IP 10.1.x.x) has NO problem accessing outside
> Oracle servers (real IP 156.80.x.5) via Net8. No IP address translation
> for outside Oracle server packets getting to inside clients.
>

Hi,

        If you can connect to your Oracle server from the local net then you can safely say that your database is started and your listener is configured properly (assuming that your local clients are not on the same machine as the server itself).   If you are absolutely sure that the remote clients are configured properly, i.e. tnsnames.ora, then I'd put a network sniffer on your local lan and see if the clients' packets are actually getting to your server. If not, then it might in fact be a problem with the router, although I'd guess not becuase the router is at least translating the source address of your packets when going to the 156.80 network.   If the packets _are_ reaching your server but no packets are being sent back then maybe it is a routing issue on the server itself. It doesn't have a route to the 156.80.x.x network or a default route.
  Other than that I think I'd need to know the error message received by the clients. I.e. Can't resolve tns name, Oracle not availble, etc. etc.

David F. Newman
Oracle DBA
buzzwang_at_ourvillage.com Received on Fri Jul 30 1999 - 13:07:02 CDT