Take the 2-minute tour ×
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.

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? –  FreshPhilOfSO 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
add comment

1 Answer

up vote 0 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%

echo %ORACLE_HOME%

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! –  BryceAtNetwork23 Mar 13 '13 at 16:59
    
And for anyone who comes after me see: docs.oracle.com/html/B14048_02/pbr_rfap.htm –  Ben_Coding Mar 13 '13 at 17:02
add comment

Your Answer

 
discard

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.