About
Sample tnsnames.ora found in the directory TimesTen_Base/network/admin/samples with TNS entry:
- for the cache of an oracle database
In Oracle Instant Client used by the cache is installed on the server at this location: TimesTen_Base/tt1122/ttoracle_home/instantclient_11_2
Articles Related
TNS_ADMIN
The TNS_ADMIN can be configured in the ttendaemon.options file with the ttmodinstall utility
[oracle@Exalytics-01 ~]$ 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/
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)))