ORA-12560: TNS:protocol adaptor error

by
  1. Go 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)
    Services

  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)

More Related Contents:

  1. Best way to do multi-row insert in Oracle?
  2. ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
  3. How do I limit the number of rows returned by an Oracle query after ordering?
  4. How to create id with AUTO_INCREMENT on Oracle?
  5. When do I need to use a semicolon vs a slash in Oracle SQL?
  6. Fetch the row which has the Max value for a column
  7. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  8. How to handle a single quote in Oracle SQL
  9. SQL Error: ORA-00933: SQL command not properly ended
  10. CASE vs. DECODE
  11. Convert a string date into datetime in Oracle
  12. DATEDIFF function in Oracle [duplicate]
  13. WHERE IN condition not accepting String value
  14. What is the difference between Views and Materialized Views in Oracle?
  15. Pivoting of data using two columns
  16. Check if current date is between two dates Oracle SQL
  17. ORA-00907: missing right parenthesis
  18. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  19. Foreign Key Creation issue in Oracle
  20. create custom function for date difference excluding weekends and holidays in oracle sql
  21. How do I list all tables in a schema in Oracle SQL?
  22. Is there a version control system for database structure changes?
  23. oracle sql: update if exists else insert [duplicate]
  24. Oracle: Updating a table column using ROWNUM in conjunction with ORDER BY clause
  25. Return number from Oracle Select statement after parsing date
  26. How do you interpret a query’s explain plan?
  27. How to call Oracle MD5 hash function?
  28. Oracle Convert TIMESTAMP with Timezone to DATE
  29. SQL Server equivalent of WM_CONCAT function [duplicate]
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment