How do I fix TNS destination host unreachable?

How do I fix TNS destination host unreachable?

Solution:

1. Host name resolving problem. Check the hostname mentioned in tnsnames entry exist in /etc/hosts file and you can ping by hostname.
2. Network driver not working properly.
3. Network is down or experiencing other problems.
4. Firewall issues.
5. Database server is down.

Why is my destination host unreachable?

A destination host unreachable response could also mean that your Internet Service Provider (ISP) is not giving the router an IP address. You may need to check the Internet connection on your modem. To resolve this, you may need to release and renew the IP address on the computer or set a static DNS address.

How do I resolve destination host unreachable in Linux?

how to fix destination host unreachable?

1. Try to disable Firewall and check for the issue.
2. Perform a tracert to the destination IP address and check where the problem occuring.
3. Make sure that local host is configured correctly.

How do I use Tnsping in Oracle?

Using the TNSPING Utility to Test Connectivity from the Client….Testing the Network

1. Start and test each listener.
2. Start and test each Oracle Connection Manager, if included in your network.
3. Test the server with a loopback test or Oracle Net Manager.
4. Test client with a connection.

How do I fix ORA 12543 TNS destination host unreachable?

Action: Make sure the network driver is functioning and the network is up. Common causes for the ORA-12543 error include: Network driver not functioning. There is a problem resolving the host name given in the address parameter of the tnsnames entry.

What is difference between destination host unreachable and request timeout?

Put very simply, request timeout means there was no response whereas destination unreachable may mean the address specified does not exist i.e. you typed in the wrong IP address.

How do I fix destination net unreachable?

How to Fix the Ping Error Destination Net Unreachable?

1. Switch off the devices on your network.
2. Disconnect power cables from Modem and Router.
3. Disconnect the Ethernet cables from Modem, Computer, and Router.
4. Reconnect the power and ethernet cables.
5. Power on the Modem and Router after one minute.
6. Check for the issue.

Why is ora-12543 TNS destination host unreachable?

All rights reserved. SQL> connect hr@proddb Enter password: ERROR: ORA-12543: TNS:destination host unreachable SQL> If you are unfamiliar with the error use the oerr utility to get more information on the error. [oracle@ora2 ~]$ oerr ora 12543 12543, 00000, “TNS:destination host unreachable” // *Cause: Contact can not be made with remote party.

Why is TNS unable to connect to host?

In some cases it could also be that the database server down. If you were to trace the connection attempt you would see something similar to the following. Looking at the trace we can see that TNS was unable to open transport to the host. Below are the following possible issues ranging from least probable to most probable.

Can you use tnsping from a remote client?

It is likely that a telnet to the same HOST and PORT would hang: Trying… Using the same tests with TNSPING on the database server will likely succeed: Copyright (c) 1997, 2011, Oracle. All rights reserved. To view full details, sign in with your My Oracle Support account.

How to resolve hostname adapter in tnsping?

I tried tnsping on my machine and returned the following lines: Used HOSTNAME adapter to resolve the alias Attempting to contact (DESCRIPTION= (CONNECT_DATA= (SERVICE_NAME=)) (ADDRESS= (PROTO COL=TCP) (HOST=192.168.0.20) (PORT=1521))) OK (70 msec)