I just created a simple TNSNAMES.ORA as follow:
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521))
(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 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?
Click Here to Expand Forum to Full Width