29 Mart 2016 Salı

ORA-12560: TNS:protocol adapter error

ORA-12560: TNS: protocol adapter error in Windows
How to beat error ORA-12560: TNS: protocol adapter error in Windows
When connecting through sqlplus command "sqlplus / as sysdba" error message appears:

ORA-12560: TNS: protocol adapter error

In my case, the problem was solved by turning off UAC in Windows.

To turn off UAC in Windows, do the following:
1. Go to "Start" - "Control Panel" - "User Accounts" - "Change User Account Control Settings"
2. Slider drop to the lowest level.
3. Reboot the machine.
After these steps, I have all earned.

If this does not work, try:
1. Prescribe "SQLNET.AUTHENTICATION_SERVICES = (NTS)" in the sqlnet.ora file on the Oracle database server
2. Check whether the record of your database in the listener.ora file is present

Hiç yorum yok:

Yorum Gönder