Although I did the steps in the link. I cannot connect with TNS. Do I need to install the old oracle client setup file?
I get a screen like the following
I cannot connect with TNS.
What happens when you try?
That just means that Toad can't find SQLnet.ora, tnsnames.ora, and ldap.ora.
It seems like your TNS_ADMIN environment variable is not pointing to the location where these files exist.
That blog recommends putting them in the same folder as the instant client. To me, that's a bad idea. I always put them in a separate folder.
1 Like
OK, problem solved.
I put the tnsnames.ora file in the C:\instantclient_21_12\network\admin directory.
C:\instantclient_21_12 under this directory fixed it.
1 Like