Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.

We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

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