ORA-12560: TNS: protocol adapter error

Question

Hello everyone!!
So I’m back on this awesome Forum!! There's nothing to say!!
My friends, I had a problem when I wanted to work with Oracle Forms, more precisely when I want to execute the form an error appears:

error:
ORA-12560: TNS: protocol adapter error

I would like to inform you that the Listener service is started, I really can't overcome this problem after long searches on Google.

I am counting on your help

Sincerely

Matrix++

Configuration: Windows XP Internet Explorer 6.0

slouma · Accepted Answer

salamou 3alaikom
I had the same problem
The solution is to check if the Oracle server on your machine is running
Right-click on My Computer --> Manage --> Services and Applications --> Services
Then look for and start the services:
-OracleMTS RecoveryService
-OracleServiceXE

chahrazed · Answer

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.

belwaer · Answer

try tnping sid

meslou · Answer

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

b_rachid · Answer

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

Dodot · Answer

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!

Dodot · Answer

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!

mouna · Answer

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

inside_8 · Answer

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.

beryllou · Answer

Thank you, you just saved my life!!

taybo · Answer

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 :)

kingenge · Answer

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

oracleX · Answer

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

lolita · Answer

But I can't start the OracleMTS RecoveryService.

ORA-12560: TNS: protocol adapter error

14 réponses

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

My tv turns off and then on again repeatedly?

Executable from a python file

Pay in 4 installments cdiscount

The alt gr key is not working on my keyboard.

Code 80072efe how to get windows update working again

Video in ".3gp" format