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

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

$ tnsping <ip>

TNS-12535: TNS:operation timed out

Newbie Asked on December 11, 2018 in ORACLE.
Add Comment
3 Answer(s)

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

Newbie Answered on December 11, 2018.
Add Comment

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

Newbie Answered on December 11, 2018.
Add Comment

Make sure PATH, ORACLE_HOME values are  set properly.

 

then do which tnsping.

 

 

 

 

Newbie Answered on December 11, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.