Oracle error: "ORA-12560: TNS: protocol adapter error."



  • Hello! Got an Oracle 11g home computer. I'm launching SQL Plus and I'm injecting a default user. Login: su, password is empty. There's a mistake in the entrance: "ERROR: ORA-12560: TNS: protocol adapter error." Help me find where the passwords and logic of Oracle users are built.



    1. You haven't written anything about whether you've created an O.D. or not.
    2. Check if TNS listener: tnsping %ORACLE_SID%
    3. The simplest way to check whether the OBD is raised correctly or not telnet localhost 1521
    4. Start a service.msc and visually check the state of services called Oracle* service, in specialty OracleService%ORACLE_SID%

    ORACLE_SID - that's the name of your OBD instas. Usually the oracle creates this variable automatically. You can check: echo %ORACLE_SID% (in principle, you should know her - once you've had the OBD.

    Google: ask tom ERROR: ORA-12560: TNS: protocol adapter error


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2