My Oracle Support Banner

TimesTen Client Connection Failed With Error: "08001: Unable to connect to data source ... EHOSTUNREACH: No route to host. TimesTen Server is unreachable." (Doc ID 1571037.1)

Last updated on JULY 22, 2021

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1 and later
Oracle Exalytics Software - Version and later
Information in this document applies to any platform.


User had just created a new TimesTen database and was attempting to configure client connection settings in sys.odbc.ini and sys.ttconnect.ini.

In testing ttIsql (direct connection), it succeeded, but in testing ttIsqlcs (client connection), user got:

08001: Unable to connect to data source (DSN: mydsn; Network Address: myttserver.DOMAIN_NAME; Port Number: 53397). EHOSTUNREACH: No route to host. TimesTen Server is unreachable

User checked what port the server runs on by doing ttStatus on the TimeTen database machine:

$ ttstatus
TimesTen status report as of Wed Jul 24 09:15:22 2013

Daemon pid 8566 port 44210 instance tt112241_64
TimesTen server pid 8591 started on port 53389
Data store /ds/mydsn
There are no connections to the data store
Replication policy  : Manual
Cache Agent policy  : Manual
PL/SQL enabled.


User found it odd that the error message indicated it failed on port 53397 but TimesTen server is running on 53389.  This discrepency is explained below in the Solution section.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.