Set the Net Service Name for the Oracle Database in the tnsnames.ora File

For cache in TimesTen Classic, set the TNS_ADMIN environment variable to indicate the full path to the directory where the tnsnames.ora file is located. This is for access to Oracle Database data.

For the Oracle Autonomous Database Serverless for the Transaction Processing workload type, use the preconfigured databases services LOW or TP:

databasename_tp
databasename_low

Ensure that the main daemon is stopped before you modify the tnsnames.ora file.
```
ttDaemonAdmin -stop
```
Set the TNS_ADMIN location for the cache agent with the ttInstanceModify -tnsadmin option to set the path to the tnsnames.ora file. Specify the full path to the directory where the file is located.
```
ttInstanceModify -tnsadmin /TimesTen/conf
```
For cache in TimesTen Classic, set the TNS_ADMIN environment variable to indicate the full path to the directory where the tnsnames.ora file is located. Set this variable in the user's profile script so that it will persist.
```
export TNS_ADMIN=/TimesTen/conf
```
Restart the main daemon to capture this setting.
```
ttDaemonAdmin -start
```

Add the net service name for the non-autonomous Oracle Database into the tnsnames.ora file. The following is an example of defining orcl in a tnsnames.ora file:

orcl =  
 (DESCRIPTION =   
   (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)
     (PORT = 1521))     
   (CONNECT_DATA =       
     (SERVICE_NAME = myhost.example.com)))

For the Transaction Processing workload type, the following is an example of defining the orcl_low in a tnsnames.ora file:

orcl_low =  
 (DESCRIPTION =   
   (ADDRESS = (PROTOCOL = TCP)(HOST = adb.us-phoenix-1.oraclecloud.com)
     (PORT = 1521))     
   (CONNECT_DATA =       
     (SERVICE_NAME = orcl_low.adb.oraclecloud.com)))

For TimesTen Scaleout, use ttGridAdmin commands to import or export tnsnames.ora or sqlnet.ora configuration for connecting to an Oracle database. See Add the Oracle Database Net Service Name to the tnsnames.ora File in the Oracle TimesTen In-Memory Database Scaleout User's Guide.