Server First Connection Attributes
Use these attributes to set the number of connections to a TimesTen server, the number of servers for each DSN and the size of each connection to the server.
These attributes allow you to specify multiple client connections to a single server. By default, TimesTen creates only one connection to a server per child process.
Server first connection attributes are specified in the server DSN only and are read at first connection. See Defining Server DSNs for TimesTen Server on a Linux or UNIX System in Oracle TimesTen In-Memory Database Operations Guide.
Note:
These attributes must be specified in the DSN. If these attributes are specified in a connection string, TimesTen ignores them and their values.
There are also TimesTen main daemon options that can specify multiple server connections. In the case that both the daemon options and these attributes have been specified, the value of the attributes takes precedence.
The server first connection attributes are described in detail next.
CipherSuites
The CipherSuites
attribute lists the cipher suite or suites that can be used, depending also on the client setting.
SSL_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256
SSL_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384
SSL_RSA_WITH_AES_128_CBC_SHA256
You must set this attribute for both the client and the server. For TLS to be used, the server and client settings must include at least one common suite.
See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.
Required Privilege
No privilege is required to change the value of this attribute.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in TimesTen Classic but not supported in TimesTen Scaleout.Setting
Set CipherSuites
as follows.
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
CipherSuites |
Specify |
Windows ODBC Data Source Administrator |
Encryption field on the Oracle TimesTen Client DSN Setup dialog. |
Specify |
Encryption
The Encryption
attribute specifies whether encryption is accepted, rejected, requested, or required for a client/server connection.
You must set this attribute for both the client and the server. Cipher settings must be the same on both the client and server, in most cases.
See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.
Required Privilege
No privilege is required to change the value of this attribute.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in TimesTen Classic but not supported in TimesTen Scaleout.Setting
Set Encryption
as follows.
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
|
Windows ODBC Data Source Administrator |
Encryption field on the Oracle TimesTen Client DSN Setup dialog. |
|
SSLClientAuthentication
The SSLClientAuthentication
attribute specifies whether SSL client authentication is required (setting of 1) or not (setting of 0, the default).
With client authentication, the server validates an identity presented by the client, and requires an identity (public/private key) in the client wallet.
Regardless of the client authentication setting, server authentication is performed, where the client validates the server.
You must set this attribute for both the client and the server. Regardless of the client authentication setting, server authentication is performed, where the client validates the server.
See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.
Required Privilege
No privilege is required to change the value of this attribute.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in TimesTen Classic but not supported in TimesTen Scaleout.Setting
Set SSLClientAuthentication
as follows.
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
|
Windows ODBC Data Source Administrator |
SSL Client Authentication field on the Oracle TimesTen Client DSN Setup dialog. |
|
MaxConnsPerServer
The MaxConnsPerServer
attribute sets the maximum number of concurrent connections to the server which the DSN references.
If you want to support many connections to the server, you must ensure that the per-process file descriptor limit for the UID
that TimesTen is being run as is set to a value somewhat more than the number of concurrent child servers that are active. This is the number of anticipated concurrent client connections divided by MaxConnsPerServer
. For full details on MaxConnsPerServer
, see Connection Attributes for Data Manager DSNs or Server DSNs in the Oracle TimesTen In-Memory Database Operations
Guide.
The value of this attribute takes precedence over the setting of the value of the max_conns_per_server
attribute in the timesten.conf
file. For details, see Specifying Multiple Connections to the TimesTen Server in Oracle TimesTen In-Memory Database Operations
Guide .
For limits on the maximum number of connections to a TimesTen database, see System Limits.
Changes to TimesTen server settings do not occur until the TimeTen server is restarted. To restart server, use the command ttDaemonAdmin -restartserver
.
Required Privilege
Only a user with operating system privileges on the system DSN in which this attribute is defined can change the value of this attribute to a value other than the one currently in effect.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in both TimesTen Classic and TimesTen Scaleout.Setting
Set MaxConnsPerServer
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
A value between 1 and 2047. The default is |
Windows ODBC Data Source Administrator |
Not applicable |
ServersPerDSN
The ServersPerDSN
attribute specifies the number of child server processes for a particular server DSN that will use round-robin connection distribution.
This attribute only has any effect if the TimesTen server is configured to operate in
multithreaded mode (MaxConnsPerServer > 1
). If
ServersPerDSN
is set to 1 then the first MaxConnsPerServer
client connections to the server DSN
will be assigned to one child server process, the next
MaxConnsPerServer
connections to a second child server process
and so on. See Connection Attributes for Data Manager DSNs or Server DSNs
in the Oracle TimesTen In-Memory Database Operations
Guide for more details.
The value of this attribute takes precedence over the setting of the value of the servers_per_dsn
attribute in the timesten.conf
file. For details, see Specifying Multiple Connections to the TimesTen Server in the Oracle TimesTen In-Memory Database Operations
Guide.
Changes to TimesTen server settings do not occur until the TimesTen server is restarted. To restart the server, use the command ttDaemonAdmin -restartserver
.
Required Privilege
Only a user with operating system privileges on the system DSN in which this attribute is defined can change the value of this attribute to a value other than the one currently in effect.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in both TimesTen Classic and TimesTen Scaleout.Setting
Set ServersPerDSN
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
A value between 1 and 2047. The default is |
Windows ODBC Data Source Administrator |
Not applicable |
ServerStackSize
The ServerStackSize
attribute value determines the size of the stack on the server for each connection.
The value of this attribute is only meaningful if the value of MaxConnsPerServer
is greater than one. If there is only one connection per server, the child server uses the process' main stack. It is also platform-dependent, as defined in the setting below.
You generally should not need to set the ServerStackSize
attribute. However, if the ttcserver
process is getting repeatable Access Violations (Windows) or core dumps (Linux and Unix), you may consider increasing the ServerStackSize
attribute to 1024 KB or greater.
This value of this attribute takes precedence over the setting of the server_stack_size
attribute in the timesten.conf
file. For details, see Defining Server DSNs for TimesTen Server on a Linux or UNIX System in Oracle TimesTen In-Memory Database Operations
Guide.
Changes to TimesTen server settings do not occur until the TimesTen server is restarted. To restart the server, use the command ttDaemonAdmin -restartserver
.
Required Privilege
Only a user with operating system privileges on the system DSN in which this attribute is defined can change the value of this attribute to a value other than the one currently in effect.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in both TimesTen Classic and TimesTen Scaleout.Setting
Set ServerStackSize
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
Valid values depend on the platform. The default is 768 KB. If the
else the minimum is 0. |
Windows ODBC Data Source Administrator |
Not applicable |
SSLRenegotiationPeriod
The SSLRenegotiationPeriod
attribute specifies a period of time, in minutes, after which session renegotiation is performed.
The default setting is 0, meaning do not renegotiate based on a time period.
Changes to TimesTen server settings do not occur until the TimesTen server is restarted. To restart the server, use the command ttDaemonAdmin -restartserver
.
If both SSLRenegotiationSize
and SSLRenegotiationPeriod
are set with non-zero values, whichever setting occurs first causes the renegotiation.
See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.
Required Privilege
Only a user with operating system privileges on the system DSN in which this attribute is defined can change the value of this attribute to a value other than the one currently in effect.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in TimesTen Classic but not supported in TimesTen Scaleout.Setting
Set SSLRenegotiationPeriod
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
An integer representing the number of minutes to wait to for session renegotiation.
|
Windows ODBC Data Source Administrator |
Not applicable |
SSLRenegotiationSize
The SSLRenegotiationSize
attribute specifies a number of megabytes of data transfer in either direction between the client and server, after which session renegotiation is performed.
The default setting is 0, meaning do not renegotiate based on megabytes transferred.
Changes to TimesTen server settings do not occur until the TimesTen server is restarted. To restart the server, use the command ttDaemonAdmin -restartserver
.
If both SSLRenegotiationSize
and SSLRenegotiationPeriod
are set with non-zero values, whichever setting occurs first causes the renegotiation.
See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.
Required Privilege
Only a user with operating system privileges on the system DSN in which this attribute is defined can change the value of this attribute to a value other than the one currently in effect.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in TimesTen Classic but not supported in TimesTen Scaleout.Setting
Set SSLRenegotiationSize
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
An integer representing the number of megabytes of data transfer after which the session restart is renegotiated.
|
Windows ODBC Data Source Administrator |
Not applicable |
Wallet
The Wallet
attribute specifies the fully qualified directory path name, where you placed the certificates that you generated (preferably the same directory path as on the client).
There is no default location. If you specify a relative path, it is relative to the timesten_home
/info
directory.
You must set this attribute for both the client and the server. You must set the same path on both the client and server.
See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.
Required Privilege
No privilege is required to change the value of this attribute.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in both TimesTen Classic and TimesTen Scaleout.Setting
Set Wallet
as follows.
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
A fully qualified directory path name (no default). |
Windows ODBC Data Source Administrator |
Wallet field on the Oracle TimesTen Client DSN Setup dialog. |
A fully qualified directory path name (no default). |