Re: SQL NET:different IP networks

there is a solution but not a good one. You can create a link from the second network db B to db on network C so your db A can connect db B using the link to C.

Use dblink for this.

I would suggest to changing routing tables/rules. Bazas wrote in message <7daki6$gsg$1_at_trimpas.omnitel.net>...
>Hello All,
>
>We have following network setup:
>In site A there is local IP network, lets say with address 192.168.1.0
>In site B there are two IP networks, lets say 192.168.2.0 and 192.168.3.0.
>
>IP routing is estabilished between site A and B, but only for first IP
>network, taht is
>192.168.1.0 <--> 192.168.2.0, but not 192.168.1.0 <--> 192.168.3.0.
>In site B there is ip routing between networks 192.168.2.0 and 192.168.3.0
>estabilished.
>
>There are Oracle7 servers in all three networks.
>Problem: user from site A wants to connect (for example with SQLPLUS) to
>server which is in site B in second network (192.168.3.0). I have access to
>Oracle servers SQLNET configuration, but I can not change ip routing rules
>anyhow. Is there any solution for the problem?
>
>TIA
>
>Bazas
>
>
Received on Thu Mar 25 1999 - 00:25:38 CET