UIM - TNS Error for all databases listed on oracle probe.
book
Article ID: 145307
calendar_today
Updated On:
Products
NIMSOFT PROBESDX 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.