Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I can't select any Network Alias from the Network Alias Drop-down.

My TNSNames.ora file is in C:\Oracle

My other machine that is a fresh install doesn't have this problem.

I get an error when I click Test on the connection window.

Status :Failure - Test failed: no ocijdbc11 in java.library.path

I'm guessing somehow it's not pointing to the TNSNames.ora file.

Where is that configured? enter image description here

share|improve this question
Is your %TNS_ADMIN% env variable set? Which Oracle client have you got installed (instant client/full oracle client)? Is %ORACLE_HOME% set? – Phil Mar 13 '13 at 16:44
Yes TNS_ADMIN = "C:\Oracle" ORACLE_HOME = "C:\Oracle\instalclient_10_2" – Ben_Coding Mar 13 '13 at 17:07
up vote 3 down vote accepted

tnsnames.ora should be located in TNS_ADMIN, which is defined as ORACLE_HOME/network/admin/.

Go to a command prompt (assuming Windows from your mention of "c:\") and execute the following:

echo %TNS_ADMIN%


Verify the directories returned, make sure that your tnsnames.ora file is in there.

share|improve this answer
I verified the directories that helped. I then found a backup of TNSNAmes.ora and restored it to the directory and it worked. Hmmm... maybe the TNSNames file was bad or had a syntax issue. Anyhow back up and working. Thanks a bunch! – Ben_Coding Mar 13 '13 at 16:58
No problem, glad to help! – Aaron Mar 13 '13 at 16:59
And for anyone who comes after me see: – Ben_Coding Mar 13 '13 at 17:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.