Set the Oracle system ID (SID) to C:>set oracle_sid=ORCL. Next, run the Net Start command (C:>net start oracleserviceORCL). This should resolve the ORA-12560 error in this situation.
If you still get ORA-12560, make sure you can ping the XE service. Use: tnsping XE And you should get OK message along with full connection string (tnsping command is located in oracle’s installation dir: [oracle express installation dir]apporacleproduct11.2.0serverbin).
ORA-12560: TNS: protocol map error This problem occurs when your database is not normally active. By default, Oracle services start at Windows startup, although they can be stopped by the user. Let’s fix this crash by starting the database server in two ways:
Tnsping doesn’t work. Point out the mistake of the person. “TNS-12560: TNS: protocol adapter error.” Copyright (c) 1997, 2005, Oracle. All rights are available. TNS-12560: TNS: protocol adapter error.
You can apply the following fixes to fix TNS error 12560. Obtain the latest patch for the SQL*NET client computer system software. Set the $ORACLE_HOME and $PATH variables (for system users only). problems with antivirus
How do I fix error ORA-12560 TNS protocol adapter error?
Set the Oracle System Identifier (SID) C:>set to oracle_sid=ORCL. Then run the Net Start command (C:>net start oracleserviceORCL). This should fix the ORA-12560 error in this situation.
How do I fix ORA 12560 TNS protocol adapter error?
Set the Oracle System Identifier (SID) to C:>set oracle_sid=ORCL. Then run Net Start Acquisition (C:>net start oracleserviceORCL). This should fix the ORA-12560 error in all of these situations.
When does ora-12560 throw a TNS protocol adapter error?
ORA-12560 occurs when you create a web link to a database and cannot connect. At this point, it just throws a TNS protocol adapter error. The reason can be one of the following: 2. The listener is not active. 2. Third party software. 3. Problem with all tnsnames.ora files.
What causes ora-12560 TNS protocol adapter error?
ORA-12560: TNS protocol adapter error. You usually get the error “ORA-12560: TNS: protocol adapter error”. The error details are as follows. Cause: A general adapter error has occurred. Action: Check the addresses being used against the protocol specifications.
Why do I get an ora-12560-tns error when starting Oracle Database?
Also, I’d like to confirm that the sqlplus executable you’re using turned out to be correct by checking someone’s path – make sure it points to the installation folder in the server’s website directory. You are getting ORA-12560: tns adapter: protocol error because you didn’t get the oracle database. You can start Oracle database like this.
Ermias is a tech writer with a passion for helping people solve Windows problems. He loves to write and share his knowledge with others in the hope that they can benefit from it. He’s been writing about technology and software since he was in college, and has been an avid Microsoft fan ever since he first used Windows 95.