If you need to trace the TNSPING command, add the 2 lines below to the sqlnet.ora file:
TNSPING.TRACE_LEVEL=ADMIN TNSPING.TRACE_DIRECTORY=/apps/opt/oracle/product/12.1.0.2/db_1/network/admin
Then run the tnsping command:
[oracle@server]$ tnsping DEANDR TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 30-JAN-2018 19:57:30 Copyright (c) 1997, 2014, Oracle. All rights reserved. Used parameter files: oracle_home/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server.domain.com)(PORT = 2340)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = DEANDR))) TNS-12535: TNS:operation timed out
In this case I had set the trace files to be written to the ORACLE_HOME/network/admin directory. A file named tnsping.trc will be created and will contain information as to the details of the trace command.
