ORA-12560: TNS: protocol adapter error

I have the same issue with Oracle Express 10g, the "tnsping xe" works, and when running "lsnrctl status" I don't have a service named "xe" in the list. The "lsnrctl reload listener" command doesn't change anything. Unable to connect with sqlplus.

The problem persists after reinstallation. I specify that I am on Windows XP, and both services OracleServiceXE and OracleTNSListener are running fine. I checked the tnsnames.ora which is correct.

Is there an Oracle DBA around? Thanks!

Salam ALAYKOUM,

The best solution is to right-click on the workstation post, manage, services and applications, then start the two services:
-OracleMTS RecoveryService
-OracleServiceXE

Hello everyone,

I tried to install Oracle 10 on WinXP Pro, but when launching the configuration assistant to copy the database files, a dialog box appears with the error ora-12560 TNS PROTOCOL ADAPTER ERROR

Thank you for your help

It's me again, I found the following message on the Oracle site:

If other Oracle client software is installed on the same computer as Oracle Database XE, ensure that you use the appropriate connect syntax for these clients when trying to connect to Oracle Database XE. If you do not specify the appropriate connect syntax, then an "ORA-12560: TNS: protocol adapter error" message may appear.

I do indeed have an Oracle 10g client on the machine. What syntax is being referred to?

I'm trying "sqlplus sys@xe as sysdba" and I'm getting the error 12560. Is my syntax correct?

I also found information regarding an environment variable "LOCAL," or "ORACLE_SID." On another machine, I don't have these environment variables and yet I connect without any problem to the XE database locally. I therefore believe they are unnecessary if the server is properly configured.

Any ideas? Thanks!

salem 3alaikon
I have the same problem as you,
I'm trying to migrate an Access database to Oracle via Workbench.

During the Oracle database creation step, I receive this message:
"unable to connect to target database
TNS: protocol adapter error"

I would appreciate a response, thank you.

try tnping sid

Hello

try the command tnsping sid, if it works check the status of the database by running the command: lsnrctl status

if it doesn't work then you have a problem with the adaptation between the service_name and the sid, make sure to check the tnsname.ora file

good luck

Hello,
I recently installed Oracle Developer Suite 10g to work on forms
when I want to use sql*plus to connect I enter with SYSTEM, manager and the error TNS: protocol adapter error appears, I don't understand what to do.
Knowing that I previously worked with Oracle 9i, with the latter, we configured the database with the Database Assistant.
But with Oracle Developer Suite 10g, I haven't found that assistant, please, I need your help as soon as possible.
Here is my email: zarrouk_moune@yahoo.fr

Hello,
How can we know if the listener has started successfully? What can we do to check? And how do we know if the tnsnames.ora file is correct?
Actually, I have a problem as well! I can't connect to the database from Oracle Forms. I enter the username, password, and database name but I'm told there's a listener issue...
I was told to place the product's tnsnames.ora into the devsuitehome but it didn't work!
Thank you for shedding some light on this.

Thank you, you just saved my life!!

asselemou 3alaykom

In the Mozilla version, there is an icon at the bottom right of the window that indicates "you are on line." Click on it to become "off line," then refresh the page and connect to the database, and insha Allah it will work. I had the same problem and it got resolved :)

I solved the problem. Check if your Oracle orcl service is started.
With my Windows 2003 SP server, it was stopped. Set the Oracle service to automatic mode. I rebooted the Windows 2003 server. Everything is working fine.

Thank you

But I can't start the OracleMTS RecoveryService.