Re: tnsping problem

Posted by Arsalan on Jan 27, 2021; 8:42am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tnsping-problem-tp9275p9280.html




Sir,
Here is the result of tnsping from my labtop and

please find the attached screen shot of DB query,

About Database performance issue the db was worked fine before this problem this problem occured in 2 days
--

C:\Windows>tnsping afgprod 10
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 27-JAN-2021 13:05:58

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:
c:\app\arsalah\product\12.1.0\dbhome_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.******)(PORT = 1544)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = afgprod)))
OK (20 msec)
OK (3840 msec)
OK (40 msec)
OK (0 msec)
OK (10 msec)
OK (20 msec)
OK (0 msec)
OK (0 msec)
OK (10 msec)
OK (20 msec)
===================