As outlined here:
Oracle User Experience Monitor: Failed to find or load the registered .Net Framework Data Provider - Forum - The Orion Platform - THWACK (solarwinds.com)
This script
1) Downloads the Oracle package from Oracle to a Temporary Location. Then Expand that .zip to a oracle folder. (c:/temp & c:/oracle
2) Moves the required dll to the Orion installation directory
3) Registers the .dll with the odp.
4) Removes .zip from
Assumptions:
- Ran on the target system
- Target system has internet access
Modifications
- If Oracle changes their url, it will need to be updated.
- Scripts assumes a number of common Orion Installation locations (C: and E: based on Kevin's Blog) and will check these 4 locations. If you have a different installation location, you can pass that will the -orion_path parameter.
- Defaults to 64bit version, can be changed to 32 bit by passing '32-bit' to the -bit parameter.
Use Example
./Invoke-2023OracleFix.ps1
Example with Custom params:
./Invoke-2023OracleFix.ps1 -oracle_path 'C:\install\oracle' -orion_path :'D:\programs\orion' -temp_folder 'C:\install\temp' -bit '32-bit'