How to Fix Oracle 10g: TNS Protocol Adapter Error

The ORA-12560: TNS Protocol Adapter Error is one of the most common issues faced while installing or using Oracle 10g. This error usually appears when you try to open SQL*Plus or attempt to connect to your database.

ORA-12560: TNS: protocol adapter error

This guide explains the cause of this error and the step-by-step methods to fix it.

💡 What Is the TNS Protocol Adapter Error?

TNS stands for Transparent Network Substrate, which is Oracle’s communication layer responsible for database connectivity. When this layer fails or cannot communicate properly, Oracle throws the ORA-12560 error.

This error mostly occurs due to configuration issues, stopped services, or incorrect environment settings.

🔍 Common Reasons for ORA-12560

Oracle Database service is not running
Oracle Listener service is stopped
Incorrect ORACLE_HOME or PATH settings
Running SQL*Plus from the wrong directory
Corrupted or missing tnsnames.ora file

🛠 How to Fix the TNS Protocol Adapter Error

1️⃣ Start Oracle Database Services

Open the Windows Services panel:

services.msc

Find and start the following services:

OracleServiceORCL
OracleOraDb10g_home1TNSListener

If they are already running, restart them.

2️⃣ Run Command Prompt as Administrator

Open CMD in Administrator mode and try connecting again:

sqlplus /nolog
connect sys as sysdba

3️⃣ Set Oracle Environment Variables

Make sure ORACLE_HOME and PATH are correctly set:

set ORACLE_HOME=C:\oracle\product\10.2.0\db_1
set PATH=%ORACLE_HOME%\bin;%PATH%

(Update the path based on your installation.)

4️⃣ Start the Listener Manually

Run this command:

lsnrctl start

Check status:

lsnrctl status

5️⃣ Verify the tnsnames.ora File

Check if the ORCL entry exists in:

C:\oracle\product\10.2.0\db_1\network\admin\

A missing or incorrect entry can cause the ORA-12560 error.

🎯 Additional Tips

Always run SQL*Plus from the correct Oracle 10g installation folder.
Avoid multiple Oracle versions on the same system to prevent conflicts.
If the error persists, reinstall the Oracle Listener configuration.

✔ Final Thoughts

The ORA-12560: TNS Protocol Adapter Error is usually related to Oracle services or environment settings. By ensuring the database service, listener, and configuration files are correctly set up, you can resolve this issue quickly.

If you’re still facing issues, consider restarting your system or reinstalling the network components of Oracle 10g.

How to Fix Oracle 10g: TNS Protocol Adapter Error