Pages

Friday 4 July 2014

Issue while trying to tnsping or connecting to database:


TNS-12543: TNS:destination host unreachable

There was a request from the client to create a new empty database for testing. We just created the database and provided
the users with the user details. He revert back with a connection error and we tried to connect tnsping the database from a different server, There was
a host unreachable error. It was strange that I can able to ping the host and also login using ssh. Checked if the port was not opened and found its opened.

The problem is with the firewall was enabled. So just disabled the firewall with the below command:


Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ********)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SAM)))
TNS-12543: TNS:destination host unreachable 


Turn off the firewall:
---------------------
chkconfig iptables off (as a root) or
service iptables stop (as a root)


To check the firewall is running or not:
---------------------------------------
service iptables status