HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Where's my Network Alias list in Oracle?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
wherelistoraclenetworkalias

Problem

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?

Solution

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.

Code Snippets

echo %TNS_ADMIN%

echo %ORACLE_HOME%

Context

StackExchange Database Administrators Q#36600, answer score: 4

Revisions (0)

No revisions yet.