{"id":4949,"date":"2025-11-05T05:34:40","date_gmt":"2025-11-05T05:34:40","guid":{"rendered":"https:\/\/w3buddy.com\/?p=4949"},"modified":"2026-01-15T12:41:23","modified_gmt":"2026-01-15T07:11:23","slug":"how-to-fix-ora-12560-tns-protocol-adapter-error-in-oracle","status":"publish","type":"post","link":"https:\/\/w3buddy.com\/blog\/how-to-fix-ora-12560-tns-protocol-adapter-error-in-oracle\/","title":{"rendered":"How to Fix ORA-12560: TNS Protocol Adapter Error in Oracle"},"content":{"rendered":"\n

If you\u2019ve just installed Oracle Database and tried connecting using SQL*Plus, you might have seen this frustrating error:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Don\u2019t worry \u2014 this is one of the most common Oracle errors on Windows<\/strong>, and it\u2019s very easy to fix.<\/p>\n\n\n\n

Let\u2019s understand what it means and how to resolve it step-by-step.<\/p>\n\n\n\n

What Causes ORA-12560?<\/h3>\n\n\n\n

The error means that Oracle can\u2019t connect to a running database instance<\/strong> because the required background services (like the database or listener) are stopped<\/strong>.<\/p>\n\n\n\n

On Windows, Oracle runs as background services, and if those aren\u2019t active, SQL*Plus can\u2019t connect \u2014 hence the \u201cprotocol adapter error.\u201d<\/strong><\/p>\n\n\n\n

Step-by-Step Solution<\/h3>\n\n\n\n

Follow these simple steps to get your Oracle instance up and running again:<\/p>\n\n\n\n

1. Open Windows Services<\/h4>\n\n\n\n
    \n
  • Click the Start<\/strong> menu.<\/li>\n\n\n\n
  • Type services.msc<\/strong> and press Enter<\/strong>.<\/li>\n<\/ul>\n\n\n\n

    2. Find Oracle Services<\/h4>\n\n\n\n
      \n
    • In the Services<\/strong> window, press O<\/strong> to quickly jump to Oracle-related services.<\/li>\n\n\n\n
    • Look for services like:\n
        \n
      • OracleServiceORCL<\/code> (your main database service)<\/li>\n\n\n\n
      • OracleOraDBHomeTNSListener<\/code> (the listener service)<\/li>\n\n\n\n
      • OracleMTSRecoveryService<\/code> (optional)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
        \n

        \ud83d\udca1 Note:<\/em> \u201cORCL\u201d may differ if you used a custom SID name during installation.<\/p>\n<\/blockquote>\n\n\n\n

        \"\"<\/figure>\n\n\n\n

        3. Start the Required Services<\/h4>\n\n\n\n
          \n
        • If any of these show a Stopped<\/strong> status:\n
            \n
          • Right-click \u2192 Start<\/strong><\/li>\n<\/ul>\n<\/li>\n\n\n\n
          • Wait until their status changes to Running<\/strong>.<\/li>\n<\/ul>\n\n\n\n
            \"\"<\/figure>\n\n\n\n

            4. Reconnect Using SQL*Plus<\/h4>\n\n\n\n

            Open Command Prompt<\/strong> again and run:<\/p>\n\n\n\n

            If everything is fine, you should now see:<\/p>\n\n\n\n

            \"\"<\/figure>\n\n\n\n

            Optional: Auto-Start Oracle Services<\/h3>\n\n\n\n

            To avoid this issue after every reboot:<\/p>\n\n\n\n

              \n
            • In the Services<\/strong> window, right-click each Oracle service \u2192 Properties<\/strong><\/li>\n\n\n\n
            • Set Startup type<\/strong> to Automatic<\/strong><\/li>\n<\/ul>\n\n\n\n

              This ensures Oracle automatically starts whenever Windows boots up.<\/p>\n\n\n\n

              Still Not Working? Try These Checks<\/h3>\n\n\n\n

              If you\u2019re still getting the error, here are a few quick diagnostics:<\/p>\n\n\n\n

              1. Check Environment Variables<\/h4>\n\n\n\n

              Make sure your system variables are correctly set:<\/p>\n\n\n\n

                \n
              • ORACLE_HOME<\/code> \u2192 path to your Oracle installation (e.g., C:\\app\\<user>\\product\\<version>\\dbhome_1<\/code>)<\/li>\n\n\n\n
              • Add Oracle\u2019s bin<\/code> directory to your system PATH<\/code><\/li>\n<\/ul>\n\n\n\n

                2. Verify Listener Status<\/h4>\n\n\n\n

                Run:<\/p>\n\n\n\n

                lsnrctl status<\/code><\/pre>\n\n\n\n
                If the listener isn\u2019t running, start it using:<\/p>\n\n\n\n
                lsnrctl start<\/code><\/pre>\n\n\n\n
                3. Restart Your Computer<\/h4>\n\n\n\n
                Sometimes a quick reboot ensures all Oracle services and background processes initialize properly.<\/p>\n\n\n\n
                Conclusion<\/h3>\n\n\n\n
                The ORA-12560: TNS:protocol adapter error<\/strong> is a simple service-related issue \u2014 not a configuration or installation failure.
                Starting the Oracle services via services.msc<\/strong> almost always fixes it instantly.<\/p>\n\n\n\n
                Whether you\u2019re a DBA, developer, or student learning Oracle, remember this quick tip \u2014 it\u2019ll save you time every time you see that red error line.<\/p>\n","protected":false},"excerpt":{"rendered":"
                If you\u2019ve just installed Oracle Database and tried connecting using SQL*Plus, you might have seen this frustrating error: Don\u2019t worry \u2014 this is one of the most common Oracle errors on Windows, and it\u2019s very easy to fix. Let\u2019s understand what it means and how to resolve it step-by-step. What Causes ORA-12560? The error means […]<\/p>\n","protected":false},"author":1,"featured_media":4955,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowu461DA:productID":"","footnotes":""},"categories":[1225],"tags":[],"class_list":["post-4949","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/4949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/comments?post=4949"}],"version-history":[{"count":1,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/4949\/revisions"}],"predecessor-version":[{"id":4954,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/4949\/revisions\/4954"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media\/4955"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=4949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=4949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/tags?post=4949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}