Oracle Protocol Adapter Error

oracle connection adapter ora-12560
Mikayil Abdullayev picture Mikayil Abdullayev · May 30, 2011 · Viewed 9k times · Source

HI, I've just installed Oracle 10 g Express Edition on to my laptop. The platform is Windows XP SP3. Installation went normally. BUt when I try to get connected to the Oracle database via SqlPlus I get "TNS Protocol adapter error".My laptop is on the network.I'd installed the same database on to a Windows Server 2003 and it works fine. What could the problem be?

Answer

APC picture APC · May 30, 2011

I presume this is ORA-12560: TNS:protocol adapter error. The Oracle documentation describes it as a generic TNS error, but there are two very common causes of it.

  1. The Windows service for OracleXE has not started, so the database is not up.
  2. The Oracle SID is not set.

If the service is started then try setting the SID. In a command window type:

C:>  set oracle_sid=XE

(or whatever you called it). Then you should be able to connect to the database using SQL*Plus. If this does solve your problem you should probably add it to the environment variables (System info, Advanced tab).

Related questions

Oracle - What TNS Names file am I using?

Sometimes I get Oracle connection problems because I can't figure out which tnsnames.ora file my database client is using. What's the best way to figure this out? ++happy for various platform solutions.

Read More
IDLE timeout parameter in Oracle

We are stuck in a situation where one of our processes is taking 3 hours of computing without touching the database. The connection that was taken before calling the process gets closed by the Oracle server and any subsequent query or …

Read More
Relation between Oracle session and connection pool

Let me explain the set up first. We have an oracle server running on a 2GB RAM machine. The Db instance has the init parameter "sessions" set to 160. We have the application deployed on Websphere 6.1. The connection pool settings is …

Read More