Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
A Tale of Two Configurations: TNS Names and Environment Variables — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

A Tale of Two Configurations: TNS Names and Environment Variables

Question
6
Views
0
Comments
edited Feb 12, 2021 7:01AM in Database

Summary

Problem Solution Approach: This quick note will outline what problem, I was facing and how I resolved it for the benefit of others

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!