Timesten - TNSNAMES.ORA

> Database > (TimesTen|TT) (In-Memory Database|IMDB)

1 - About

Sample tnsnames.ora found in the directory TimesTen_Base/network/admin/samples with TNS entry:

In Oracle Instant Client used by the cache is installed on the server at this location: TimesTen_Base/tt1122/ttoracle_home/instantclient_11_2

Advertising

3 - TNS_ADMIN

The TNS_ADMIN can be configured in the ttendaemon.options file with the ttmodinstall utility

[[email protected] ~]$ ttmodinstall -tns_admin /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/
TNS_ADMIN for the instance 'tt1122' is currently not set.
Would you like to change TNS_ADMIN for this instance? [ yes ] 
Please enter a value for TNS_ADMIN (q=quit)? [ /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/ ]
Do you want to restart the daemon using the new configuration? [ yes ]
Restarting the daemon ...
TimesTen Daemon stopped.
TimesTen Daemon startup OK.
Instance tt1122 is now configured with TNS_ADMIN=/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/

4 - Example

## SAMPLE Timesten TNSNAMES.ORA file
# To configure to use this file, place this file in the directory
#     setenv TNS_ADMIN <path to directory containing this file>

## Timesten Cache Sample tnsnames entries
# These are sample entries for Timesten Cache to connect to Oracle RDBMS 
# database instances. You may insert the tnsnames entries as configured 
# in $ORACLE_HOME/network/admin of your Oracle Server or as given to you
# by your Oracle Database Administrator.

#
# Basic Format of tnsnames.ora File
#
# net_service_name=
#  (DESCRIPTION=
#    (ADDRESS=(protocol_address_information))
#    (CONNECT_DATA=
#      (SERVICE_NAME=service_name)))
#
# Example 1
#
# sales=
#  (DESCRIPTION=
#  (ADDRESS=(PROTOCOL=tcp)(HOST=sales-svr)(PORT=1521))
#  (CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com))
#
# Example2
#
# ORCL =
#   (DESCRIPTION =
#     (ADDRESS = (PROTOCOL = TCP)(HOST = database_machine.us.oracle.com)(PORT=1630))
#     (CONNECT_DATA =
#       (SERVICE_NAME = orcl)
#     )
#   )
# 


## Timesten OCI Sample tnsnames entries
# These are entries that can be used by OCI programs to connect to Timesten databases
# These samples correspond to the DSNs that are pre-configured in Timesten's sys.odbc.ini file.

# The Timesten Direct entries follow the pattern of:
# <NAME> =(DESCRIPTION=(CONNECT_DATA = (SERVICE_NAME = <NAME> )(SERVER = timesten_direct)))

sampledb_1122 =(DESCRIPTION=(CONNECT_DATA = (SERVICE_NAME = sampledb_1122)(SERVER = timesten_direct)))

# The Timesten Client entries follow the pattern of:
# <NAME> =(DESCRIPTION=(CONNECT_DATA = (SERVICE_NAME = <NAME> )(SERVER = timesten_client)))

sampledbCS_1122 =(DESCRIPTION=(CONNECT_DATA = (SERVICE_NAME = sampledbCS_1122)(SERVER = timesten_client)))