ORA-12514: TNS:listener does not currently know of service requested in connect descriptor on linux server
We never do tnsping of the ip, we do tnsping of the tns alias defined in tnsnames.ora.
if tnsnames.ora file looks as this.
(ADDRESS = (PROTOCOL = TCP)(HOST = 22.214.171.124)(PORT = 1540))
(SERVER = DEDICATED)
(SERVICE_NAME = DBACLASS)
Here the alias name is DBACLASS.
tnsping command will be :
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.*******.0)(PORT = 1986))
[oracle@mcpproddb admin]$ tnsping MCPPROD
TNS Ping Utility for Linux: Version 126.96.36.199.0 – Production on 11-DEC-2018 12:58:08
Copyright (c) 1997, 2016, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name