1 person found this helpful
You don't need a 'thick' connection, or an Oracle Client to connect using a TNSNames file.
Simply provide the directory for us to find your tns (if the list of services doesn't come up by default), and connect.
So uncheck 'use OCI' and try again.
Thanks, "use OCI" is not checked in Tools > Preferences > Database > Advanced. One additional clue - I have Oracle 12c installed on the laptop, it has ocijdbc12.dll in BIN. Adding ocijdbc11.dll to BIN causes an immediate termination of SQL Developer on opening, a bug I'll have to report somewhere. Am I remotely on the right track with that? Will adding ocijdbc11.dll to the correct folder fix the problem?
use the network alias, not the connect identifier on the TNS connection properties - connect identifier requires the Oracle Client stuff
Now that you've been at this a couple of day are you ready to tell us what PROBLEM you are trying to solve?
The Basic connection is no problem.
Ok - so why don't you just use that connection?
But an attempt at a TNS connection is giving me error "Test failed: no ocijdbc11 in java.library.path".
Why do you want a TNS connection? You already have a basic connection.
I'm not clear on the procedure suggested in the ReadMe "To connect to earlier version of the database using the Thick Driver
Why do you want to use the thick driver?
I'm having a hard time figuring out what problem, if any, you are really trying to solve.
Do you want a TNS connection? If so, why?
Do you want a connection using the 'thick' driver? If so, why?
What is it you expect either of those two types of connections to do for you that the basic connection won't do?
What worked to correct "Test failed: no ocijdbc11 in java.library.path" was this:
Tools > Preferences > Database > Advanced
"Use Oracle Client" is checked, with path set to Oracle Home: file:/C:/app/myuserid/product/12.1.0/dbhome_1.
It only worked after 2 (?) restarts. Not claiming this as a confirmed, tested best practice, just a solution in this case. Thanks to Jeff for suggesting a way to work the problem .