Hi all,
yeah, this classic ^^
I got error as subject when try to tnsping to other DB server.
I have read and try some tips and workaround, but no luck.
maybe here, you can give idea what to check to solve the problem.
client is Linux box, with Oracle 10g,
remote is Linux box, with oracle 11g.
the error is :
------------------------------
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 16-JAN-2017 14:45:43
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/home/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.167.1.13)(PORT = 1521)) (CONNECT_DATA = (
SERVER = DEDICATED) (SERVICE_NAME = IMART)))
TNS-12560: TNS:protocol adapter error
------------------------------------------------------
here is my tnsnames.ora.
its just contain this line only :
IMART =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.167.1.13)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = IMART)
)
)
--------------------