Announcements

Oracle training based on real-time expertise as per industry standards. Upcoming batch details are here.

View batch schedule

Free Oracle mock interview. Register using the link.

Register

#DBAchallenge: submit your questions.

Ask questions
Swipe for more →
Browse by Topic
Latest Posts

    Thursday, August 8, 2024

    Oracle On Windows - ORA-12560: TNS:protocol adapter error

    Oracle On Windows - ORA-12560: TNS:protocol adapter error


    Issue: 

    Unable to connect to database getting error ORA-12560: TNS:protocol adapter error


    C:\Users\Administrator>set ORACLE_HOME=E:\app\mallik\product\19.0.0.0\dbhome_1
    C:\Users\Administrator>set ORACLE_SID=ORA19C

    C:\Users\Administrator>E:\app\mallik\product\19.0.0.0\dbhome_1\bin\sqlplus / as sysdba
    SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 31 23:00:31 2024
    Version 19.3.0.0.0
    Copyright (c) 1982, 2019, Oracle.  All rights reserved.

    ERROR:
    ORA-12560: TNS:protocol adapter error

    Enter user-name:
    ERROR:
    ORA-12560: TNS:protocol adapter error

    Enter user-name:
    ERROR:
    ORA-12560: TNS:protocol adapter error

    SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
    C:\Users\Administrator>

    Cause:

    Windows service will be down -  OracleServiceORA19C


    Solution or Fix:

    Verify the windows service status for Oracle and restart them 


    No comments:

    Post a Comment

    🌟 Proud to be an Oracle ACE Pro! 🚀

    🌟 Proud to be an Oracle ACE Pro! 🚀 I’m excited to share my official Oracle ACE Profile with the Oracle community. 👨‍💻 Mallikarjun ...