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

book

Article ID: 145307

calendar_today

Updated On:

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.