1. Reference
  2. Connection Attributes
  3. Client and Server Connection Attributes
  4. Client General Connection Attributes
  5. TTC_Server2, TTC_ServerN

TTC_Server2, TTC_ServerN

For TimesTen Classic, this attribute specifies the logical server name to use if an automatic failover occurs. See the description of TTC_Server or TTC_Server1 for details on setting the value of this attribute and associated attributes.

  • When using automatic client failover with an active standby pair replication scheme in TimesTen Classic, you can only define TTC_Server2. After which, the client alternately attempts to connect to TTC_Server and TTC_Server2 until a connection succeeds or the TTC_TIMEOUT attribute expires.

  • For other types of automatic client failover, you can specify a list of failover servers with TTC_ServerN connection attributes where N >= 2. TimesTen can iterate through this list of designated failover servers (as necessary) that you configured as TTC_Server2, TTC_Server3, TTC_Server4, and so on. The maximum number of servers that the client can specify is 999.

    Note:

    See TTC_Random_Selection on how TimesTen iterates through the list of designated failover servers.

Unspecified values for TTC_ServerN, TTC_Server_DSNN, and TCP_PortN inherit the value of TTC_Server (or equivalently, TTC_Server1), TTC_Server_DSN (or TTC_Server_DSN1), and TCP_PORT (or TCP_PORT1), respectively. For example, if TTC_Server2 is specified but TTC_Server_DSN2 and TCP_Port2 are not, then TTC_Server_DSN2 is set to the TTC_Server_DSN value and TCP_Port2 is set to the TCP_Port value.

You should configure your failover servers sequentially. If you do skip a number when configuring your failover servers, then TimesTen automatically creates the missing definition and assigns it to the server identified by TTC_Server. In this case, your client could fail over to the same server multiple times.

When using an active standby pair replication scheme for client failover, the TTC_Server or TTC_Server1 and TTC_Server2 connection attributes could potentially have the same setting if it is a virtual IP address. Virtual IP addresses can dynamically move to different hosts; thus, both connection attributes may have the same definition, but could be referencing distinct databases.

See Using Automatic Client Failover in Oracle TimesTen In-Memory Database Operations Guide for more information on automatic client failover.

Required Privilege

No privilege is required to change the value of this attributes.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported in both TimesTen Classic and TimesTen Scaleout.

Setting

Set TTC_Server2 or TTC_ServerN as follows:

Where to set the attribute How the attribute is represented Setting

C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen Classic or in the database definition (.dbdef) file in TimesTen Scaleout

TTC_Server2, TTC_ServerN

Character string specifying the logical server to be used if an automatic failover occurs.

Windows ODBC Data Source Administrator

Failover Server Name or Network Address field on the Oracle TimesTen Client DSN Setup dialog configures the TTC_Server2 connection attribute.

Character string specifying the logical server to be used if an automatic failover occurs.