Skip To Content

Using the tnsnames.ora file to establish an Oracle database connection

Rapid Insight software looks for an Oracle configuration file when attempting to establish data connections to Oracle databases. The “tnsnames.ora” file often resides with other Oracle files you may have on your PC – but not always. The tnsnames.ora file is associated with Oracle databases, and if you do not have one, your database administrator should be able to provide one.

To ensure that this file is found, a System Variables environment system variable called TNS_ADMIN should be set up to point to where the tnsnames.ora file resides. Confirm this is in place by going to Control Panel > System Properties > Environment Variables and browse the System Variables list.

System propertiesEnvironment variables

Variable-Name-and-file-path

Back to Knowledge Base