A Tale of Two Configurations: TNS Names and Environment Variables
SummaryProblem Solution Approach: This quick note will outline what problem, I was facing and how I resolved it for the benefit of others
Oracle TNS Names and Windows System Environment Variables - A Tale of two Configurations!
So here is the background:
I had just installed ODAC - Oracle Data Access Controls for Visual Studio.
Little did I notice, it created a new ORACLE Home upon completion.
So when I tried connecting to my Oracle instance in OCI, I kept getting the below error.
Problem: ORA-28759: failure to open file
I changed passwords multiple times, to no avail, that didn't work. So next, I decided to explore the Environment variables in the OS.