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.
Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email firstname.lastname@example.org for assistance.
Error when attempting to establish an oracle OCI connection in server or designer. Uploads from designer to server(gallery) may also fail with the following errors.
ORA-12154: TNS: could not resolve the connect identifier specified
This issue can occur if a new OCI instance client driver is installed with an existing OCI package. This may cause conflicts when referencing the tnsnames.ora file
Check and confirm the environmental variables are correctly configured to use the new driver and specify an additional parameter TNS_ADMIN to ensure the tnsnames.ora file is read from the correct location
Update the environmental variable path (Please note: local administrator rights are required to access environmental variables)
Open the Control Panel on the windows machine, then select System
Click on Advanced System Settings then Environmental Variables
Under System variables find the PATH, then click on Edit
Click on New and enter the path of the new OCI instant client
Move the new path above all other oracle paths, You can use the Move Up/Down buttons to do this (see screenshot below)
Click Ok then enter click New under systems variables
Enter TNS_ADMIN for the variable name
Enter the location of the tnsnames.ora file under variable value (See screenshot below)
Save the changes and restart the node
Check the parameter names.directory_path in the machine's Oracle Client directory \OracleHome\network\admin\SQLNet.ora file to see what is specified. If you are using a tnsnames.ora file, move the TNSNAMES in the names.directory_path to the beginning of the paramter.
Example: Before: NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, HOSTNAME) After: NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, HOSTNAME) You can also uncomment out the names.directory_path.
names.directory_path Specifies the order of naming methods that are used when a client tries to connect to a database. Possible values: TNSNAMES, LDAP, ONAMES, HOSTNAME, EZCONNECT.
In some instances, user may not have access to modify system variables due to permissions. Please liaise with your IT department to make the above changes.
If the above does not resolve your issue there are additional checks posted on the following site which may help to troubleshoot this further.dba.oracle.com
Installation and configuration of oracle drivers is outside the Alteryx support scope.