oracle probe on one hub is generating ORA-12557: TNS:protocol adapter not loadable
search cancel

oracle probe on one hub is generating ORA-12557: TNS:protocol adapter not loadable

book

Article ID: 259504

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM) CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

We run the Oracle probe on 6 probe servers (along with other probes). Yesterday, one of the oracle probes started generating the following error for ALL Oracle databases configured for remote monitoring on that probe server.
 
TNS:protocol adapter not loadable
 
I rebooted the probe server and verified no changes were performed on the server - no change.
 
oracle: testClient starting with: user: , conn:
oracle: Profile: test connection, data engine connecting to database , using connection test connection, user:
oracle: Profile: test connection, Oracle error! Status: -1, - ORA-12557: TNS:protocol adapter not loadable
oracle: Profile test connection/test connection, OCIServerAttach failed with rc= -1
oracle: Profile test connection, disconnect starting
oracle: Profile test connection, disconnect finshed
oracle: Connection test to  failed
 
Please advise where I should look to resolve this.

Environment

  • Release: 20.4
  • oracle probe

Cause

  • Unknown, possibly environmental, e.g., Windows Update corrupted oracle client install.

Resolution

Customer's DBA reinstalled the oracle client for the hub where the oracle probe was installed and then it worked without throwing the error:

oracle: Profile: test connection, Oracle error! Status: -1, - ORA-12557: TNS:protocol adapter not loadable