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.
Hoping for some help with this - very simple SELECT * from a table in Oracle.
We have two Oracle databases - one I connect to regularly through Alteryx with no issues (although it did take some intensive legwork to make the 32 bit connection work)
I have attached a number of screen shots.
The error I get is OCILogon2 Error: ORA-12170: TNS:Connect Timeout Occurred
I included a screenshot from Oracle SQL Developer showing the query and results
Two screens from Oracle SQL Developer with connection info - SCPO is the connection name that is NOT working. It has an SID instead of Service Name - not sure why or if that matters. I researched and from what I can find from Oracle they are interchangeable... screenshot from tnsnames.ora file shows both connections, similarly configured there.
Also, screenshots of both configurations in Alteryx.
From what I can tell, my configuration is good - but it won't connect to one (SCPO), but will connect to the other(XIW).
I have tried both 32 bit and 64 bit connection setting, but so far am unable to find a resolution to this.
I have tried it both ways... I also included the screenshot from Oracle SQL Developer so it connects that way normally. I thought the same as you and when trying it reversed still had issues... the error then says:
ORA-12154: TNS: COULD NOT RESOLVE THE CONNECT IDENTIFIER SPECIFIED.
So, I am certain (well, 99.999%) that the config is correct... :(
using the above method, the tnsnames.ora file isn't used since all of the necessary items are included here.
If you wanted to use your tnsnames file, you would instead do something like this:
If you receive something like the ORA-12170: Connection timeout error, that is an indication that there is a problem connecting to your host. Other errors like ORA-12154 indicate that you've connected to the host correctly but now there is an issue with the service name. And as in this case, you may consider using the IP instead of the host name.
Install the oracle instant client and ODBC package from oracle site( for oracle 12.1..)
Added environment variable for TNS_ADMIN and added path for instant client
Ran ODBC installation exe
Created ODBC for Oracle data source
After doing all the above steps, I can access the database and pick the table to my input but when I am running the workflow it is giving error "TNS could not resolve the connect identifier specified ...".
I have used host name and I do see you have suggested to use IP address for this kind of error, I will try that and update the outcomes, though just would like to know if that's only the issue here?
Latest version: 188.8.131.52.0 https://www.oracle.com/technetwork/topics/winsoft-085727.html Basic Package ODBC Package Do the same like on video For Windows 10: you need to install Visual C++ Redistributable Packages for Visual Studio 2013 (x84) ...