Since the internal subnets are physically disconnected, you can't use internal
IP. And external IP is probably inaccessible due to firewall restrictions. There
are several ways to get around this problem:
- setup a bridge between your subnets.
- configure firewall to allow access to the server from your subnet on
Oracle's port (TCP/1521). Since you can access the db server on
different ports (which is required to map windows network shares) I
suspect the firewall is simply configured to deny access to port 1521.
hth.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Rune Forberg" <rune_at_dbc-munin.no> wrote in message news:a64kno$69b$1_at_lise.netcom.no...
> I have a problem when connecting to my oracle database from toad after we
> installed a new firewall. Before we connected to the database with external
> ip address, but after we installed the firewall this won't work. I cannot
> connect with local ip address either, because the server is on another
> subnet. That is the same subnet (255.255.255.0) on a physically separated
> network. What should I do to connect to the database from my computer. I
> tried to map up the server to o: on my computer, and set oracle home to that
> mapped drive. o:\oracle\ora81, so i could use the
> o:\oracle\ora81\network\admin\tnsnames.ora file on the server to connect,
> but this seemed like a dirty solution, besides it didn't work. Help of any
> form i appreciated. Here is my tnsnames.ora data:
>
> old external server ip: 212.45.170.197
> new internal ip for the server: 192.168.0.4
>
> PROD =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 212.45.170.197)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = prod.dbc_munin.no)
> )
> )
>
>
Received on Wed Mar 06 2002 - 03:26:51 CST
