ORA-12514: TNS:listener does not currently know of service requested in connect descriptor on linux server

Dear,

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.

DBACLASS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 182.20.204.2)(PORT = 1540))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DBACLASS)
)
)

Here the alias name is DBACLASS.

tnsping command will be :

tnsping DBACLASS

Regards

Admin

tnsnames.ora

MCPPROD=
(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.*******.0)(PORT = 1986))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=MCPPROD)
)
)

[oracle@mcpproddb admin]$ tnsping MCPPROD

TNS Ping Utility for Linux: Version 12.2.0.1.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

Make sure PATH, ORACLE_HOME values are  set properly.

then do which tnsping.

Resolve the ORA-12514 error, “TNS:listener does not currently know of service requested in connect descriptor,” on your Linux server with expert assistance from Lulu Dubai. Gain insights into troubleshooting steps and best practices to address this common Oracle error. Ensure seamless connectivity to your Oracle database and optimize server performance with Lulu Dubai’s exclusive guidance. Overcome technical hurdles and maintain operational efficiency with trusted solutions provided by Lulu Dubai.