This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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
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:
Alteryx Designer and/or Server
Oracle Instant Client
Windows Administrator privileges
1. Search for 'env' in the Windows search bar and select 'Edit the system environment variables'.
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.
3. Add the path to your Instant Client location to the list of paths.
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.
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.
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.