ORA-12170: TNS:Connect timeout occurred

by

[Gathering the answers in the comments]

The problem is that the Oracle service is running on a IP address, and the host is configured with another IP address.

To see the IP address of the Oracle service, issue an lsnrctl status command and check the address reported (in this case is 127.0.0.1, the localhost):

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

To see the host IP address, issue the ipconfig (under windows) or ifconfig (under linux) command.

Howewer, in my installation, the Oracle service does not work if set on localhost address, I must set the real host IP address (for example 192.168.10.X).

To avoid this problem in the future, do not use DHCP for assigning an IP address of the host, but use a static one.

More Related Contents:

  1. Determining location of relevant tnsnames.ora file
  2. How to uninstall / completely remove Oracle 11g (client)?
  3. How can I set a custom date time format in Oracle SQL Developer?
  4. Default row ordering for select query in oracle
  5. oracle convert unix epoch time to date
  6. Oracle trigger after insert or delete
  7. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  8. Difference between a user and a schema in Oracle?
  9. Base64 encoding and decoding in oracle
  10. What is the dual table in Oracle?
  11. How to avoid variable substitution in Oracle SQL Developer
  12. Recursion In Oracle
  13. creating parameterized views in oracle11g
  14. Oracle’s default date format is YYYY-MM-DD, WHY?
  15. PL/SQL print out ref cursor returned by a stored procedure
  16. How to send email using Oracle 10 g Forms
  17. How to get primary key column in Oracle?
  18. How to create a user in Oracle 11g and grant permissions
  19. Trigger to enforce M-M relationship
  20. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  21. Oracle: how to INSERT if a row doesn’t exist
  22. Valid Date Checks in Oracle
  23. Functions vs procedures in Oracle
  24. Oracle: difference between max(id)+1 and sequence.nextval
  25. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  26. How can I solve ORA-00911: invalid character error?
  27. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  28. How to Register Pluggable Database(PDB) with new created LISTENER
  29. Grant Select on all Tables Owned By Specific User
  30. ORA-12704: character set mismatch

Leave a Comment