TNS ping

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.

C:\>tnsping mydb01

TNS Ping Utility for 32-bit Windows: Version – 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)