When trying to use an Oracle APM 2.0 monitor I receive the error "Unexpected error occurred. System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. I'll assume this is something I need to install on the Orion server.
This posting is about mostly desktops and this oracle message. I want to talk about server class machines running a dtexec that are throwing this error message. In one case it meant that an installed oracle client instance on a server machine was no longer there, and it had been there for a long time. On the client side we found recently 1/2023 that certain versions of the oracle client 32 bit don't run on a laptop with AMD chips. Downgrading to a lower version of the oracle client 19.x fixed the problem.
Download Oracle Client Software Version 8.1.7 Or Greater Freel
To connect to Oracle, you will also need to install the Oracle client software on the machine where you have installed the on-premises data gateway. Specifically, the Oracle Database connection requires the installation of the 64-bit Oracle Data Provider for .NET. You can use the following link to download and install the Oracle client:
To connect to an Oracle database with Power BI Desktop, the correct Oracle client software must be installed on the computer running Power BI Desktop. The Oracle client software you use depends on which version of Power BI Desktop you've installed: 32-bit or 64-bit. It also depends on your version of Oracle server.
Before you can connect to an Oracle database using Power BI, you need to install the Oracle Data Access Client (ODAC) software 11.2 or greater on your computer. To install the 32-bit ODAC software, go to 32-bit Oracle Data Access Components (12.1.0.2.4) or choose a version you prefer. To install the 64-bit ODAC software, go to 64-bit Oracle Data Access Components (12.1.0.2.4) or choose a version you prefer. You must choose a Windows Installer version since x-copy version doesn't work with Power BI Desktop.
After you install the matching Oracle client driver, you can connect to an Oracle database. To connect to an Oracle database with the on-premises data gateway, the correct Oracle client software must be installed on the computer running the gateway. The Oracle client software you use depends on the Oracle server version, but will always match the 64-bit gateway. For more information, go to Manage your data source - Oracle.
C:\oracle64\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:config /force /product:odp /frameworkversion:v4.0.30319 /providerpath:C:\oracle64\product\18.0.0\client_1\odp.net\bin\4\Oracle.DataAccess.dll
C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:config /force /product:odp /frameworkversion:v4.0.30319 /providerpath:C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\Oracle.DataAccess.dll
The Microsoft Oracle .NET data provider accesses an Oracle databaseusing the Oracle Call Interface (OCI) through Oracle clientconnectivity software. The provider can access Oracle 7.3.4 or laterand requires Oracle 8i Release 3 (8.1.7) orlater client software. The classes are located in theSystem.Data.OracleClient namespace. An example ofa connection string using integrated security is shown in thefollowing snippet:
The .NET Framework Data Provider for Oracle enables data access to Oracle data sourcesthrough Oracle client connectivity software. The data provider supports Oracle clientsoftware version 8.1.7 and later. 2ff7e9595c