ORA-12560: TNS:protocol adaptor error

  1. o to the windows machine that hosts the Oracle database server
  2. Go to Start -> Run -> Services.msc in Windows. Locate OracleService < SID > (here OracleServiceORCL) and click on Start to start the oracle database service (if not already running)
  3. Once it is up and running, from the command prompt run the following:tnsping < tnsalias > (tnsalias entry you can find it in tnsnames.ora file)

Leave a Comment