4

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

2
  • 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
4

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%

echo %ORACLE_HOME%

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

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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