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.
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.
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.