patternMinor
Where's my Network Alias list in Oracle?
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
I'm guessing somehow it's not pointing to the
Where is that configured?
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.pathI'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
Go to a command prompt (assuming Windows from your mention of "c:\") and execute the following:
Verify the directories returned, make sure that your tnsnames.ora file is in there.
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.