Got an stupid error ORA-12154: TNS:could not resolve the connect identifier specifed.
Double check tnsnames.ora, sqlnet.ora, TNS_ADMIN – all were correct
This one in tnsnames doesn’t work:
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(HOST= myhost)(Port= 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = db1)
)
)
and this one works:
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(HOST= myhost)(Port= 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = db1)
)
)
Difference only in one space in penultimate line.
It’s interesting, that tnsping shows another error
TNS-12533: TNS:illegal ADDRESS parameters
but sqlplus
ORA-12154: TNS:could not resolve the connect identifier specifed
Комментариев нет:
Отправить комментарий