topic Re: Unable to connect with Oracle in Alteryx Server Discussions

Unable to connect with Oracle

NATARAJ — Fri, 31 Mar 2023 09:53:03 GMT

Hello Guru,

Im facing an issue in Alteryx connectivity. The issue is while connecting Oracle using OCI, it is keep spinning and not getting the result. But strangely, If I give a wrong password (intentionally), it is giving an error "Invalid username/password", can someone help to fix the issue?

Re: Unable to connect with Oracle

gabrielvilella — Fri, 31 Mar 2023 15:07:22 GMT

Here are a few tips on how to connect Oracle: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Connect-to-an-Oracle-Database-in-Alteryx/ta-p/561574

Re: Unable to connect with Oracle

NATARAJ — Wed, 05 Apr 2023 08:22:21 GMT

Hello.

Thanks for the response. But the solution did not work for me. it is really strange that, OCI is unable to connect oracle server.

Re: Unable to connect with Oracle

manojmcpd — Wed, 31 May 2023 19:02:31 GMT

I am trying to connect with oracle using OCI connection. I am able to connect using the Alteryx Desktop but when i am trying same workflow on Alteryx Gallery getting error "ORA 01017: Invalid username/password. What is causing this error?