Applications Systems

ORA-28040 No matching authentication protocol on Oracle User Experience Monitor

When testing a component or upon initial poll, the Oracle User Experience monitor returns ORA-28040: no matching authentication protocol.

First published date

11/14/2018 9:27 PM

Last published date

6/26/2020 5:42 AM

Overview

This article details and provides steps to resolve an issue that occurs during testing a component or upon initial polling, the Oracle User Experience monitor returns the following error message:

ORA-28040: no matching authentication protocol

This message is usually a result of using Oracle libraries that are too old for the release of Oracle database. For instance, the oci.dll delivered by Solarwinds is a 10.2 oci.dll and therefore, cannot be used to access Oracle 12.

Product section

Server Application Monitor

Cause

Oracle client libraries are usually good for two releases of Oracle. For instance, the Oracle 12 client libraries can be used to access Oracle 11 and Oracle 12. However, the Oracle 12 client libraries cannot be used to access Oracle 10.

Resolution

The fix to the problem is dependent upon how the Oracle client libraries are or were installed on the SolarWinds server (or Additional Polling Engine).

If the Windows PATH includes direct links to the Oracle client libraries:

The easiest way to solve this problem would be to replace the current directories with newer Oracle libraries.

If the SolarWinds path is before the Oracle library paths, or if the Oracle library path does not exist in the PATH system variable:

Go to the folder where the SolarWinds Oracle plugins were installed, usually ProgramFiles (x86)/SolarWinds/Orion/APM/OracleClient
Place the updated libraries in that directory folder
Click Yes to overlay the oci.dll that was delivered by SolarWinds

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.