Timesten - Server

Timesten Component

Timesten - Server


The TimesTen Server is a child process of the TimesTen daemon (then on a server machine) that operates continually in the background.

It takes network requests from TimesTen Clients (in a client server architecture) and translates them into operations on databases on the server machine.

On the server machine, the TimesTen Server is linked with the TimesTen Data Manager ODBC driver.

The Server's responsibility is to listen for requests from a client application, process the request through the Data Manager ODBC driver, and then send the results and any error information back to the client application.

Timesten Client And Timesten Server

How to


You can stop and start the server with the ttDaemonAdmin utility.

[oracle@Exalytics-01 ~]$ ttDaemonAdmin -stopserver
TimesTen Server stopped.


You can stop and start the server with the ttDaemonAdmin utility.

[oracle@Exalytics-01 ~]$ ttDaemonAdmin -startserver
TimesTen Server started.


Cannot connect to TimesTen Server

Example of message that you can get from OBIS (Oracle BI Server) when the server is down.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] 
[nQSError: 10058] A general error has occurred. 
[nQSError: 43113] Message returned from OBIS. 
[nQSError: 43119] Query Failed: 
[nQSError: 16001] ODBC error state: 08001 code: 0 message: 
[TimesTen][TimesTen CLIENT] Unable to connect to data source 
(DSN: DI_TT_AGGR_STORE; Network Address: Exalytics-01.hotitem.local; Port Number: 53397). 
Cannot connect to TimesTen Server. Verify that the TimesTen Server is running or verify that 
your TCP PORT is set correctly.. (HY000)

Documentation / Reference

Discover More
Timesten Component
Timesten - (Data Manager) Daemon (timestend)

The TimesTen main daemon (timestend) is a background process, which: Spawns child server process to manage shared database connections Spawns child subdaemon to manage the database Starts: the...
Timesten Component
Timesten - (Server) Process

A server process manages a connection. See the ttstatus utility By default, a server process is spawned at the time a client requests a connection. By setting the -serverPool option in the...
Timesten Client And Timesten Server
Timesten - Client/Server Connection

The client application refers to the Client DSN when initiating a connection to locate and connect to the TimesTen database. The Client DSN defines: the server machine and the Server DSN. The...
Timesten Component
Timesten - DSN

When you connect from an application, you use a Data Source Name (DSN) to uniquely identify the particular TimesTen database to which you want to connect. A DSN is a character-string name that identifies...
Timesten Component
Timesten - ttStatus Utility

With the ttStatus Utility, you can get information: on the database process such as the daemon on the connection on the replication policy on the cache agent policy where we can see that:...
Timesten Component
Timesten - ttendaemon.options configuration file

The ttendaemon.options file contains TimesTen daemon options. Some connection attributes can be configured in the TimesTen daemon options file (ttendaemon.options). If you have set the same connection...
Timesten Component
Timesten - ttmodinstall utility

The ttmodinstall utility allows the instance administrator to change daemon options (in the ttendaemon.options file) for most commonly changed options. If you cannot use ttmodinstall to change a particular...

Share this page:
Follow us:
Task Runner