A logical server name is used on the TimesTen client to connect to remote OracleTimes Server processes that do not listen on the default port or for local client/server using shared memory inter-process communications or UNIX domain sockets.
This document will detail the steps to create a logical server name on UNIX based systems.
On UNIX based systems logical server names are contained in a file named by the environment variable SYSTTCONNECTINI. If this environment variable is not set then Oracle TimesTen uses the file OTT_HOME/< instance name >/info/sys.ttconnect.ini. Below are the contents of the sys.ttconnect.ini after a default install.
# Copyright (c) 1999, 2009, Oracle and/or its affiliates.All rights reserved. ############################################################### # This is a sample sys.ttconnect.ini file that is used for the # TimesTen Client. It contains entries for each server. ############################################################### [ttLocalHost_tt1121] Description=TimesTen Server Network_Address=ttLocalHost TCP_PORT=53385
Note that there is already one logical server name defined. Below is a description of the logical server name format.
[logical server name]- This is the logical server name. A common naming convention is to append _logical to the end of the name.
Description-Description of the TimesTen server
Network_Address- The host name or IP address of the machine that is hosting the TimesTen server
TCP_Port- The port number in which the TimesTen server is listening for connections. For release 11.2.1 the default port number for 32-bit is 53385 and 53389 for 64-bit platforms.
Notice in the definition of the ttLocalHost_tt1121 above that the Network_Address is set to ttLocalHost. For local client/server connectivity TimesTen has the ability to connect either through shared memory or through UNIX domain sockets. A value of ttLocalHost for the Network_Address parameter signifies that connectivity between the local client and server should use UNIX domain sockets. A value of ttShmHost for the Network_Address parameter signifies that connectivity between the local client and server should use shared memory for inter-process communications.
Now we will create a logical server name to be used to for client connections to a remote TimeTen database running on Windows.
First we need to verify the port number in which the TimesTen database is listening upon for connections. Using the ttStatus utility on the TimesTen server we can quickly find the port number. Below is the output of ttStatus from the Windows server ODWIN.
C:\ >ttstatus TimesTen status report as of Wed Aug 04 10:21:08 2010 Daemon pid 540 port 53384 instance tt1121_32 TimesTen server pid 1512 started on port 53385 ------------------------------------------------------------------------ Data store c:\app\oracle\product\timesten\tt1121~1\demoda~1\sampledb_1121 There are no connections to the data store Replication policy : Manual Cache Agent policy : Manual PL/SQL enabled. ------------------------------------------------------------------------ Accessible by group BUILTIN\Administrators End of report C:\ >
Above we see that the port number is 53385. Keep in mind we only need to the port number for the TimesTen server, not the Daemon. At this time we have the port number and host name for the TimesTen database all that is left is to add the logical server name to the OTT_HOME/< instance name >/info/sys.ttconnect.ini.
Below is the logical server name created for use in client DSNs.
[ttODWIN_logical] Description=TimesTen Server 11.2.1 on Windows Network_Address=odwin TCP_PORT=53385