Connect via internet

[Deeg]

How can i make a pl/sql developer connection to an oracle database via the internet, that is running on a pc behind a router ( firewall ) without an URL, only an IP address ?

 

[Claus Pedersen]

Make an entry in your tnsnames.ora file (or via program Oracle NetX Easy Config).

This should do the trick.

 

[Deeg]

Thanks, indeed an entry in tnsnames.ora with the ip-address in HOST. Furthermore on the server-side, when you are using a firewall/router,
1. you must use a fixed ip-address,
2. add port 1521 to the NAPT table of the router/firewall and
3. add environment variable USE_SHARED_SOCKET = TRUE