How to solve ORA 12560: TNS:Protocol Adapter Error [Complete Guide]

By | January 2, 2017

How to solve ORA 12560

Oracle is free, open business management software available for both personal and commercial use. Its uses object-relational database management system which allow users to process credit card payments, handles customer, support, and manages customer orders. Oracle, networking software does the task of exchange of data between machines using underlying services to establish communication between the components. Establishment of communication happens due to some set of services, these services are known as Transparent Network Substrate (TNS).

TNS handles communication with oracle components with its database codes and pre-programmed schema. The acronym TNS occurs in various instances, when you get an error. TNS uses various protocols, which could be TCP/IP, DECNET, SPX/IPX, AppleTalk etc. These all combination of TNS and the hidden protocols that help in networking makes the connection establish between components. Such complex is TNS that it becomes the diagnosis of problems quite challenging, but Oracle provides tracing facilities to troubleshoot the error. The Oracle Transparent Network Substrate (TNS) facilitates simple inter-database communication and has a inbuilt management layer over the standard network topology. But sometimes there may occur some communication error while connecting to the database. ORA-12560 TNS Protocol Adapter Error is one such error which happens whenever there is a problem in accessing a specific server of the database.

ORA-12560 TNS Protocol Adapter Error can happen for numerous reasons, but the most common being the server problem.  This problem arises when a user does not specify which database or server was being accessed or there may be incorrect password provided to the database. Instead of giving exact reasons for the connection error, Oracle simply prompts ORA-12560 TNS Protocol Adapter Error. Let’s discuss the following error and the workaround for it.

The first instance of getting this error could be when you login into Oracle database and an error prompts:

ora-12560-tns-protocol-adapter-error

Then follow these steps:

If you are running on a server that is running the database (i.e. database is local to machine) then

At first, make sure that you have set correct ORACLE_SID:

Go to command prompts and run the following commands:

  1. Set Oracle Database SID as

                 Set oracle_sid=ORCL

2. Then run Net Start command

                      Net start oracleserviceORCL

If that didn’t worked for you, then check the service name ‘OracleService<SID> ties up with actual database SID. If somehow database SID changes without recreating service then this can lead this error. The you have to recreate this service by following this step:

oradimxx -delete -sid <old-sid>

oradimxx -new -sid <SID> –intpwd <internal-password> AUTO –pfile <full-init-ora-filename>

If the above method doesn’t work, may be the OracleService for the database is not running. Check for the service, if it is not running then starts the service. If it is running then restart the service.

Now restart the service using below method.

  1. Go to Start button.
  2. Type Run and open it.
  3. On the dialogue box, type services.msc then enter.
  4. Then navigate to find OracleServicesORCL and select the service and then click on Start to initiate oracle database server if it’s not already running.
  5. After it has been done and running, from the command prompt run the following:
  6. Tnsping<tnsalias> (tnsalias entry you can find it in tnsnames.ora file)

If the above guides are out of your mind abd you are perplexed what to do and wonder now how to repair and fix ORA 12560: TNS:protocol adapter   then don’t worry. For your rescue there is this tool which will help you out. This tool doesn’t require any tech know how and could use this tool at ease. It will not require prior knowledge to use this tool, just foolow these simple steps and you are done with the error.

Steps to fix ORA 12560: TNS:protocol adapter using tool

Step 1:  Run Stellar Phoenix Oracle Recovery and you would see options to select or search corrupt  Oracle databases in your computer.

Step:2  Click on Scan File to start the scan process after selecting the oracle database.On the left-side pane, recoverable objects get listed.

2

Step 3: Click an object to see its preview.

3

Step 4: : Click Start Repair in the icon bar to start the repair process. A prompt message occurs which will guide you further. Click next and continue.

4

Step 5: Provide user name, password and path of the blank database where you want to save the repaired database objects.

5

Step 6: Repairing and restoring various database objects after establishing a connection with blank oracle database.

6

 

This way you could fix ORA 12560: TNS:Protocol Adapter Error. Hope that help’s.