Hi there,

I just created a simple TNSNAMES.ORA as follow:

oracledb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracledb)
)
)

When I use SQLPLUS username@oracledb, the SQLPlus prompt me the password and the SQLPlus can connect the Oracle successfully.

However, when I just run SQLPLUS, the SQLPlus will return to following error once I entered username and password:

ERROR:
Error while trying to retrieve text for error ORA-12545

In my environmental variable, I already setup up ORACLE_SID=oracledb.

Anyone can solve above case?

Regards,
Edward.