Hello! Installed on the home computer Orakl 11g. I launch application SQL Plus and I enter the data of the user by default. Login: su, password is empty. Together, the input throws an error: "ERROR: ORA-12560: TNS: protocol adapter error". Help me find where the passwords and logins of users are configured.

  • Nobody want to answer? - andrey84
  • I advise you to find step by step instructions for installing Oracle DB. And it will be even better if it turns out to be with pictures. - Viacheslav

3 answers 3

  1. You have not written anything about creating an instance database or not.
  2. Check if TNS listener: tnsping %ORACLE_SID% running.
  3. The easiest way to check if the database is raised correctly or not is telnet localhost 1521 .
  4. Run service.msc and visually check the status of the services with the name of the Oracle * service, OracleService%ORACLE_SID% .

ORACLE_SID is the name of your database instance. Normally orakl creates this variable automatically. You can check it like this: echo %ORACLE_SID% (in principle, you should know it - just put the database yourself).

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

    I installed at home Oracle 11g Express Edition. When installing, I asked for a username and password, I remembered somewhere and everything works.

    When I try to log in with the wrong password, I have the error ORA-01017 . IMHO you have a problem with the network settings (for example with the Firewall). Describe in more detail the OS, the version that is included, etc.

    • The xp operating system that is installed on the virtual machine. There is also oracle. I did not put any firewalls and similar programs there. The machine is local, i.e. the network is not configured to integrate with other computers. Where you can look at the error code and find out the sign-cause of the error. - andrey84
    • Google: ORA-12560 issues approximately 642,000 different answers. IMHO try to configure the virtual machine and XP so that the Internet (oracle.com) is visible. - avp
    • As far as I remember when installing XE, I ask you to specify only a password. Standard logins: SYS or SYSTEM. - Viacheslav

    Try the solution with disabling UAC in Windows :

    How to beat the error ORA-12560: TNS: protocol adapter error in Windows .