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

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? 

Parents
  • We were facing the same issue and below is how we fixed it.

    Investigation shows post installing 2022.3 lot of files from APM folder.

    Solution -  restored Oracle.ManagedDataAccess.dll -> opened old instant client -> cd C:\oraclient\odp.net\bin\4 -> oraprovcfg.exe /action:gac /providerpath:"c:\Program Files (x86)\SolarWinds\Orion\Oracle.ManagedDataAccess.dll"

    This fixed our issue.

  • Hello 

    Please correct me if I'm wrong,

    so you executed

    /1 cd C:\oraclient\odp.net\bin\4

    /2 oraprovcfg.exe /action:gac /providerpath:"c:\Program Files (x86)\SolarWinds\Orion\Oracle.ManagedDataAccess.dll"

    because the Oracle.ManagedDataAccess.dll is located in C:\oraclient\odp.net\bin\4 and you wanted to relocate it back to the Orion path. Or is it the other way around?

  • Hey  - 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!

  • Thank you, very helpful!!! Just want to add this one for the final step:

    Changing Oracle Driver Type to the one we registered.




Reply Children
No Data