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

For cache in TimesTen, 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 Autonomous Transaction Processing, 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, 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 Autonomous Transaction Processing, 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)))

Note:

TimesTen supports both TCP and mTLS-based connections for Oracle Autonomous Database on Dedicated Exadata Infrastructure and only mTLS-based connections for Oracle Autonomous Database Serverless.