- Go to the windows machine that hosts the Oracle database server
-
Go to Start -> Run -> Services.msc in Windows.
Locate OracleService < SID > (hereOracleServiceORCL) and click onStartto start the oracle database service (if not already running)

-
Once it is up and running, from the command prompt run the following:
tnsping < tnsalias >(tnsalias entry you can find it in
tnsnames.orafile)