"System.Data.OracleClient requires Oracle client software version 8.1.7 or greater."

[kniino]

Hi,

I was trying to create Oracle DB data connection on Gallery(2019.4) and faced "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater." error.

I installed instantclient_12_1 but it did not work.

Appreciate any help there is. 

[KylieF]

@kniino

I would recommend you reach out to our Support Team at support@alteryx.com for this issue since the error might be directly related to a unique configuration in your gallery set up.

[nbrenner]

It was a security issue for us.  The users need access to the Oracle Client folder and subfolder on the box to be able to access the client.  To that end, our users don't have access to the box, so we added the access permissions to the Alteryx application account (the admin account entered at install) and then Alteryx was able to access the Oracle Client when trying to create a data connection.

[KJennings]

Hi...

I am currently working this issue with one of our users, and feel that this may be the solution based on the circumstances involved.  Currently it seems to be related to the workstation as the user has not yet been able to create a successful workflow to attempt to publish to the server.

Could you please elaborate on what exactly you modified permissions on?

Thanks for your assistance,

Kevin Jennings

[nbrenner]

https://docs.microsoft.com/en-us/archive/blogs/fabdulwahab/system-data-oracleclient-requires-oracle-...

When we applied to the Oracle Client folder, a popup came up asking if we should apply to subfolders as well.  We clicked Yes, or OK, whichever it was and it raced down through subfolders as well.

[KJennings]

@nbrenner 

Thanks for the quick response.  I should have more clear in my question.  Did you need to make any changes on the server, or were all changes made on the workstation?

Thanks!

Kevin J

[nbrenner]

We had shared the article with our IT support team and they shared screen with us while they performed the change on the Alteryx server.