I am getting TNS error for all databases (oracle) configured on one of my UIM probes
Environment
Release : 9.1.0
Component : UIM - ORACLE
Oracle v18c
Cause
- 18c client software installation
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.