My Oracle Support Banner

Oracle Exalytics: Aggregate Creation On Multi-instance Implementation Fails With Error: "...TimesTen CLIENT...Unable to connect to data source (DSN: TT_AGGR_STORE..." (Doc ID 1613149.1)

Last updated on JANUARY 15, 2014

Applies to:

Oracle Exalytics Software - Version to [Release 1.0]
Oracle TimesTen In-Memory Database - Version to [Release 11.2]
Information in this document applies to any platform.


Oracle Exalytics server includes three instances on single bare metal box: DEV, SIT, and UAT. OBI and TimesTen are installed on each instance and each instance was installed using a separate operating system user.  All the TimesTen instances are running on different ports and each has the default aggregate store called "tt_aggr_store." But when trying to create aggregates using nqcmd, all instance seem to point to the Dev instance of TimesTen. The issue happens even when the DEV TT instance is down and while creating the aggregates in SIT or UAT, the build errors out and nqserver.log shows the following error:

"[ERROR:1] [] [] [ecid: 004vsQa898eB5ELLqQG7yY0002Y50007gc,0:497:1] [tid: 425e0940] [nQSError: 16001] ODBC error state: 08001 code: 0 message: [TimesTen][TimesTen CLIENT]Unable to connect to data source (DSN: TT_AGGR_STORE; Network Address: localhost; Port Number: 53397).”

The port mentioned in the error (53397) is for the Dev TT instance.


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

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

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