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

Toad for Oracle
1

I need help getting past this error.

image
image786×594 19.9 KB

$ Error. ORA-12154 — •
o% =
C — TNS SQL
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:
PROD =
(DESCRIPTION =
(ENABLE = BROKEN)
(ADDRESS = (PROTOCOL = TCP)(HOST = db.snow.edu)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = DBPROD)
) ) 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
Retry
Close

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.

TNSNAMES_ORA
TNSNAMES_ORA1003×2030 133 KB

sqlnet_ora
sqlnet_ora1010×692 20.2 KB

2

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?

3

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