Re: Connect to database from TOAD after installing firewall

Rune,

Here is a simple problem/solution to your problem:

http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi?s=3c8662862d2effff;act=ST; f=3;t=23

Hope that helps somehow.

Trifon Anguelov
Senior Oracle DBA

Check the latest Oracle DBA forums on:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

"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 - 20:51:29 CST