I am connecting to Oracle server using PLSQL,this is my tnsnames.ora
(C:\Oracle\ora90\network\ADMIN
) config:
MY_ERP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
and this is my env variable of ORACLE_HOME:
C:\Oracle\ora90
When I am connecting to server,it throw this error:
error while trying to retrieve text for error ORA-12154
Am I missing something? The OS: Windows 10. PLSQL:7.1.4.1390. Oracle 9.
Best Answer
If those lines really start with spaces in
tnsnames.ora
, that will not work. Remove the leading spaces in the first line (MY_ERP =
), becasue an alias can not start with a space.You can also try setting
TNS_ADMIN
toC:\Oracle\ora90\network\ADMIN
, becauseORA-12154
means the connection identifier could not be resolved, mabybe PL/SQL Developer searches fortnsnames.ora
somewhere else:Finally: Oracle 9 was release 18 years ago, install a recent client, if your database is compatible with it.