You are getting ORA-12560: TNS:protocol adaptor error becuase you didn’t start the Oracle database. You can start Oracle database like this. From START-> select Oracle Database 11g Express Edition (11g or what ever your database type.you can find this from All Programs).
I reported “ORA-12560: TNS: protocol adapter error” when manually starting all Oracle services from my machine. Start>Control Panel>Performance>Maintenance>Administrative Tools>Services. This was mostly done with less RAM, so it took a long time to start the services. I have been making mistakes for some time while installing oracle core software i.e.
The following fixes may be fixed for TNS bug 12560. Get the latest fix for the SQL*NET client software. Set the $ORACLE_HOME and $PATH variables (should be available to system users). Check the permissions on the potential client on the PC. Check the $TNS_ADMIN variable.
How do I fix error ORA-12560 TNS protocol adapter error?
Set any Oracle System Identifier (SID) to C:>set oracle_sid=ORCL. Then run the Net Start command (C:>net start oracleserviceORCL). This should fix the ORA-12560 error in the above situation.
How do I fix ORA 12560 TNS protocol adapter error?
Oracle System ID (SID), found in C:>set oracle_sid=ORCL. Then run the Net start command (C:>net start oracleserviceORCL). This repair should fix the ORA-12560 error in this actual situation.
When does ora-12560 throw a TNS protocol adapter error?
ORA-12560 occurs when you are preparing to connect to a database and for some reason cannot generate a URL. At the moment it just has a TNS protocol adapter error. The reason may be in one of the users: 1. The listener is not active. a little. Third party software. 3. Problem containing tnsnames.ora file.
What causes ora-12560 TNS protocol adapter error?
ORA-12560: TNS protocol adapter error. Sometimes you get an error message ORA-12560: “TNS: protocol map error”. The error details are as follows. Cause: General, an error occurred in the last protocol adapter. Action: Check the addresses used according to protocol specifications.
Why do I get an ora-12560 TNS error?
This error mostly occurs when the user is setting up Oracle for the first time and trying to login. When a user tries to set up a username and password, the previous error occurs: This error can occur when the listener is barely active. or a problem in tnsnames or list not up After setting the gate, the oracle user should look at all services for the person, including the listeners.
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.