So what does this do?
Given you have your database and server details put in TNSNAMES.ORA, this should will check that your listener is up on the database server
Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp.
TNS Ping Utility for 32-bit Windows: Version 22.214.171.124.0 – Production on 01-FEB-2 012 15:31:18
Copyright (c) 1997, 2008, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1234)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mydb01)))
OK (20 msec)