The tnsnames.ora file contains one or more database connection details that SAS, ODBC, SQL Developer, etc., uses to connect to an oracle  database. When a database is migrated, it may be necessary to update its entry in the tnsnames file, unless a cname (alias) is being used.

There can be multiple tnsnames.ora files when a SAS installation is present. Below are some common locations:

tnsnames.ora file location(s):

c:\Oracle\product\11.2.0\client_1\network\admin

c:\instant_client\instantclient_11_2

c\instantclient-basic-windows.x64-11.2.0.4.0\ODBC_nic29176_20170926

c\Users\z-Tulenko\Documents