Oracle User Experience Monitor: Failed to find or load the registered .Net Framework Data Provider

Question

Hello - 
 I recently upgraded to 2022.3 and now all of my Oracle User Experience monitors are in an "unknown" state because of the following error message: 
 "Failed to find or load the registered .Net Framework Data Provider" 
 Nothing has changed on the linux servers I'm monitoring that host these Oracle DBs, and I already had Oracle .NET installed on our polling server before the upgrade. 
 What's the fix please?

strau2ca · Accepted Answer

Hey joshua.pinpin - I finally fixed this issue. I was able to reference the Oracle.ManagedDataAccess.dll file in a temp folder on my server. I copied this into the new SolarWinds Oracle path and ran oraprovcfg.exe against it. After that, my Oracle polling worked. 
 Here are the steps: 
 1. Locate Oracle.ManagedDataAccess.dll and copy it into "c:\Program Files (x86)\SolarWinds\Orion\" 
 2. Navigate to where oraprovcfg.exe is installed via CMD. Run the command below. 
 oraprovcfg.exe /action:gac /providerpath:"c:\Program Files (x86)\SolarWinds\Orion\Oracle.ManagedDataAccess.dll 
 3. CMD will return a success message if the command executes properly. 
 4. Kick off polls for your Oracle monitors and they should work. 
 Note: I didn't have to restart or shutdown any SolarWinds services during this process. 
 I hope this helps!

yyyghb4 · Answer

I ran into this today as well after we upgraded to 2022.4.1 over the weekend. I contacted support and they basically gave me the same answer as this thread. But the instructions were missing some steps. So I've tried to write some better instructions for my documentation and thought I'd share.

Open a command prompt (cmd) with administrator rights 
 cd C:\oraclient\odp.net\bin\4 If you are not able to find the above dir and get dir not found error, then ODAC may be installed in different path or not installed at all. 
 Download the relevant ODAC ver from

https://www.oracle.com/database/technologies/net-downloads.html 
 For Windows, (Choose the appropriate (32 or 64 bit) XCopy ODAC Package

Download the zip file with the installer and extract to a temporary location. 
 From that location, in the command prompt, navigate to the installer directory and execute the following command

install.bat all c:\oracle myhome true 
 
 From the Oracle installation directory, (C:\oracle\odp.net\managed\common) copy the &ldquo;Oracle.ManagedDataAccess.dll&rdquo; to the Orion installation directory. If Solarwinds is installed to the C drive, the location will be &ldquo;C:\Program Files (x86)\SolarWinds\Orion&rdquo; 
 In the command prompt, navigate to the following oracle directory, (\asp.net\bin\4) if you downloaded the installer, it will be &ldquo;C:\oracle\asp.net\bin\4&rdquo;and execute the following command: 
 
 oraprovcfg.exe /action:gac /providerpath:"c:\Program Files (x86)\SolarWinds\Orion\Oracle.ManagedDataAccess.dll" 
 
 You should receive a successful confirmation of the completed command. You can now close all of the windows and try the Oracle SAM component again. It should work now.

Feel free to modify if I've missed something, or have something wrong. 
 BTW, We also had a strange issue with a bunch of our SAM Powershell scripts. They stopped working as well, where some had previously been set to Remote Host execution, they were now set to Local host execution, and all that were broken had had the option of "Run under specified account" unchecked.

Oracle User Experience Monitor: Failed to find or load the registered .Net Framework Data Provider

Top Replies