TNS-12547 TNS Lost Contact when trying to connect from client outside LAN
768724May 26 2010 — edited May 26 2010Hi! i have a bit of a problem here. this may not be an oracle problem but...
im in an office with LAN using 172.16.1.0 as IP address, we have a single WAN ip address (let's say 333.333.333.333). our database server (Windows XP, 11g) is inside the LAN with IP number 172.16.1.109. the database name is IEI
tnsping from the server itself is fine.
IEI =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = IEI)
)
)
we can tnsping from a client within the LAN (with instant client). for example, from 172.16.1.19, tnsping IEI, it's ok.
in tnsnames.ora:
IEI =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.109)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = IEI)
)
)
but we have employees stationed outside the LAN area (from another office) that needs to access the database.
we set up the tnsnames.ora, where hostname = 333.333.333.333, listener port = 1521.
IEI =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 333.333.333.333.)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = IEI)
)
)
but tnsping iei gives TNS-12547. i dont know if it's a firewall problem or what. windows firewall is down in 172.16.1.109 and i dont think there's any other firewall.
in our WAN Modem, we have opened the NAT for port 1521 to 172.16.1.109. so i dont know what the problem is...
any help would be appreciate it.
Edited by: mkdgroup on May 26, 2010 2:58 PM