UIM - TNS Error for all databases listed on oracle probe.

Products

• NIMSOFT PROBES
• DX Infrastructure Management

Issue/Introduction

I am getting TNS error for all databases (oracle) configured on one of my UIM probes

 

 

 

 

Cause

- 18c client software installation

Environment

Release : 9.1.0

Component : UIM - ORACLE

Oracle v18c

Resolution

Oracle probe was working as expected previously. UIM administrator noticed TNS errors being generated. As it turns out, the DBA installed 18c client software on the server running a particular instance of the oracle probe. Configuration path to tnsnames file was probably changed as a result of installing the 18c client software. Once the software was backed out, the connectivity to the 18c databases/instances was restored.