ORA-12560: TNS:protocol adapter error

Few “years” back, while it was almost impossible to install Oracle 10g on Windows 7/8, I made some attempts & managed to install 32Bit versions of 10g successfully. A particular release had helluva of issues, mainly TNS related & I can see many visits to that thread even today! I believe, those visitors are not coming over there for 10g, instead for TNS.

On Windows, the below is a typical situation & we’ll see the primary reasons for the same.

Microsoft Windows [Version 10.0.22000.556]
(c) Microsoft Corporation. All rights reserved.

C:\Windows\system32>sqlplus / as sysdba

SQL*Plus: Release - Production on Mon Mar 21 07:59:29 2022

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

ORA-12560: TNS:protocol adapter error

Enter user-name:

On Windows, everything is another service. So we’ll start with checking whether the “Oracle” service for the database instance has started.

I’m using Oracle database on my laptop mostly for learning purposes, hence the service startup is set as “Manual”. This gives me control over the resources consumed by the database. Not just the service, I have setup the instance to start manual to insure Oracle service doesn’t open the database automatically. Latest Windows OS that use quick boot will save the state of the service, hence you might find your database readily available once after a reboot, although you set everything as manual :)

Let’s see what happens after starting the “Oracle Service”.

Well, that fixes one of the many reasons for the dreaded ORA-12560: TNS:protocol adapter error! As soon I am hit with another, will amend this post.

Oracle client server architecture, TNS error “Unable to connect”

Okay guys, a new topic after a long break. We had a situation with a client server based 3rd party application printing certain reports adhering Kuwaiti labor rules (Arabic reports). For reasons unknown our R12 implementation partner has decided to make a set of forms and reports which were copied to individual user computers and called upon requirement.

Recently we wanted to copy the same application for a new user and came across a problem with TNS error “Unable to connect”. Our team has gone through hours to figure out the issue, futile. Ironically legacy applications which were client server architecture were running smooth without triggering the TNS errors at the same time!

Finally, while grouping the folder items by “type” we noticed the presence of a “tnsnames.ora” file along with runtimes (.fmx and .rdp/.rpt files)

Bingo! removing the file resolved almost 48 hours pain in the ***! So, if you come across such a siutation, have a look inside the folder, where ifrun60.EXE “starts in” (Right click the application, check the “Starts in” folder) and make sure that a copy of tnsnames.ora is not present in the same folder with wrong tns entries.

for Windows7bugs,