Oracle Exalytics: Aggregate Creation On Multi-instance Implementation Fails With Error: "...TimesTen 11.2.2.5.0 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 1.0.0.0.0 to 1.0.0.3.0 [Release 1.0]
Oracle TimesTen In-Memory Database - Version 11.2.2.2.0 to 11.2.2.6.1 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Oracle Exalytics server includes three instances on single bare metal box: DEV, SIT, and UAT. OBI 11.1.1.7.131017 and TimesTen 11.2.2.5.0 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 11.2.2.5.0 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.

Cause

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 hundreds of Community platforms