Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

How to monitor oracle on 2022.4 using polling and not agents?

Solarwnd1

How to monitor oracle on SAM 2022.4 using polling and not agents?

Find more posts tagged with

Accepted answers

Seashore

Are you using the "Oracle User Experiance Monitor" Component in SAM? If so, what driver type are you using then?

All comments

Solarwnd1

On version before 2022.4, we were able to monitor oracle. Since upgrading to SAM 2022.4, we are no longer able to monitor Oracle. We receive the following error: Oracle returned an error. Failed to find or load the registered .Net Framework Data Provider.

Seashore

Are you using the "Oracle User Experiance Monitor" Component in SAM? If so, what driver type are you using then?

Solarwnd1

Yes, using the Oracle User Experience Monitor. Using the Microsoft .NET Data Provider driver type.

anthony.yates

We have just been fixing our existing monitors as upgrading to 2022 (from 2020) broke them and it removed the Oracle client dll.

There are docs on setting up but these appear out of date as reference folder Solarwinds\Orion\APM\OracleClient which does not exist since upgrading.

Configure SAM to monitor Oracle database servers (solarwinds.com)

Use the SAM Oracle Database template and Oracle User Experience monitor without ODBC (solarwinds.com)

We raised case with Solarwinds and after an amusing response suggestion we look for the missing windows dll file on our Oracle Linux server we eventually got passed to another engineer who was a bit more helpful and pointed us in the right direction.

Anyway these are the steps we did to get up and running again but I'm not currently sure whether there is any difference between using Unmanaged driver vs Managed driver, but it appears that only the unmanaged driver is working for us.

Download Oracle client from https://www.oracle.com/database/technologies/net-downloads.html
Install Oracle client
Went to C:\Program Files\Oracle Client for Microsoft Tools\odp.net\bin\4
Copied Oracle.DataAccess.dll to SolarWinds\Orion folder (could not see Oracle.ManagedDataAccess.dll)
Ran oraprovcfg.exe /action:gac /providerpath:"D:\SolarWinds\Orion\Oracle.DataAccess.dll"
Restarted Orion Service
APM Monitor now showed “Oracle Data Provider for .NET” AND “Managed Oracle Data Provider for .NET”
Tested both providers, not fixed
Restarted Orion Server
Tested both providers, not fixed
Found Oracle.ManagedDataAccess.dll in a different folder
Went to C:\Program Files\Oracle Client for Microsoft Tools\odp.net\managed\common
Copied Oracle.ManagedDataAccess.dll to SolarWinds\Orion folder
Ran oraprovcfg.exe /action:gac /providerpath:"D:\SolarWinds\Orion\Oracle.ManagedDataAccess.dll"
Tested both providers, not fixed
Changed monitor advanced settings to use x64 instead of x86
Tested both providers, now works with “Oracle Data Provider for .NET” but not “Managed Oracle Data Provider for .NET”

Note: We have SolarWinds installed at \SolarWinds\Orion so your paths may be different

Hopefully the info will help you get it working or others fix if broken.

mrt3385

this helped with my onprem and OCI oracle instances, thank you!

jltg

You are my Hero! Fixed when upgrade from 2020 to 2023 version. The installator deleted this file.

yogakos

hai I've solve also with this workaround using oracle database authentication type on the oracle database

but when the oracle using OS Authentication type I'm still having issue

we've 2 different Oracle database.

the one we solve is the security level of the user is default which is when I input oracle username and password it's directly to database

the other hand of Oracle database security level it's need to login to database first and then query to database to login to database. (that's why when I try to connect through sql developer and oracle template it's show ORAI:01017 - nvalid Username/Logon Denied.

do you have such experience before guys ?

Appreciate your reply

thanks u