6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

How to Edit Environment Variables for Oracle

TessaS
Alteryx
Alteryx
Created

How to edit system environment variables for Oracle

 

The goal is to make the Oracle Instant Client discoverable to Alteryx. Environment variables should be investigated when you get an error connecting to Oracle or it's taking an unusually long time to connect.

 

Example of an error:
 

ocidll.png

 

Prerequisites

 

  • Alteryx Designer and/or Server
    • All versions
  • Oracle
    • All versions
  • Oracle Instant Client
    • All versions
  • Windows Administrator privileges

 

Procedure

 

1. Search for 'env' in the Windows search bar and select 'Edit the system environment variables'.

searchenv.png


2. Select 'Environment Variables...', go to the 'System variables' and scroll down to the 'Path' variable. If there are multiple paths referencing Oracle, ensure that the path you are editing is the first in the list.


pathvar.png

3. Add the path to your Instant Client location to the list of paths.


envpath.png

4. Search for a variable called 'TNS_ADMIN'. It should point to the location of the TNSNAMES.ora file. If it doesn't exist, click 'New' and add it.

tnsadmin.png
5. Repeat step 4 for the ORACLE_HOME variable. The path should be the same path that was added to the PATH variable in step 3.

 

Common Issues

 

Spoiler (Highlight to read)
You cannot get administrative privileges.
Edit the user paths instead. These changes will only be in effect for that set of user credentials.

You don't have a TNSNAMES.ora file
Skip step 4 but complete step 5.
You cannot get administrative privileges. Edit the user paths instead. These changes will only be in effect for that set of user credentials. You don't have a TNSNAMES.ora fileSkip step 4 but complete step 5.

 

Additional Resources