ORA-12154: TNS:could not resolve the connect identifier specified

I need help getting past this error.

$ Error. ORA-12154 — •
o% =
ORA-12154: TNS:could not resolve the connect identifier specified
Items Checked
6y TNS_ADMIN environment variable is not defined
© ORACLE_HOME environment variable is defined as "C:\oracle\dbhomeXE"
C "C:\oracle\dbhomeXE\Network\Admin\tnsnames.ora" was located
© Found in the tnsnames.ora file:
(ADDRESS = (PROTOCOL = TCP)(HOST = db.snow.edu)(PORT = 1521))
) ) C "C:\oracle\dbhomeXE\Network\Admin\sqlnet.ora" was located © NAMES.DIRECTORY_PATH specifies TNSNAMES in the sqlnet.ora file
Steps to Take
• Try to TNSPing PROD using the TNS Ping button on the toolbar
Search this message in our knowledge base

What exactly do I need to do to make this work?

My windows 11 failed. I have a fresh install of Windows 11, Toad for Oracle 17, and Oracle 21c local install.

That means Toad found the tnsnames file and the entry for it that you specified, but it just can't connect.

Is the database running? Is the Listener running too?

Can you TNSPing it or connect to it (using the connect string) using SQL*Plus?

Maybe a VPN needs to be connected?

It was my 21c installation. I uninstalled that and downloaded the latest instantclient. Unzipped it into the c:\oracle folder. Made sure that folder was in the PATH and put the TNSNAMES and SQLNET in the Toad directory. It's working now.

1 Like