Home » Infrastructure » Windows » ORA-12560: TNS:protocol adapter error (Oracle 11gR2 on Window 7 (Home Basic))
ORA-12560: TNS:protocol adapter error [message #575165] Sun, 20 January 2013 16:36 Go to next message
ganesh_gvn
Messages: 33
Registered: February 2012
Location: PUNE
Member

Dear All,

I have installed Oracle 11gR2 on Window 7 (Home Basic).

Now I am trying to access my database with named 'TEST', from cmd, but I am getting "TNS:protocol adapter error"

Below is the error :
=============================================================================================
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\Home>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jan 21 03:59:55 2013

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

Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
==================================================================================================


When I start the service name 'OracleServiceTest', then I am not getting the error. But It won't allow me to 'startup' the database instead database get started with 'OracleServiceTest' service start.

I am doing this as ADMINISTRATOR. I am not understanding where I am wrong. How this can be solved. Please suggest me.

Thanks in advance.
Ganesh

[Updated on: Mon, 21 January 2013 13:51] by Moderator

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error [message #575174 is a reply to message #575165] Sun, 20 January 2013 22:19 Go to previous messageGo to next message
rishwinger
Messages: 132
Registered: November 2011
Senior Member
Ganesh

I hope you googled about this error and tried everything

I am not sure this would work for you but
I resolved this error by fixing my environment variables

Edit environment variable tns_admin and point it to your tnsnames.ora file location

Re: ORA-12560: TNS:protocol adapter error [message #575175 is a reply to message #575174] Sun, 20 January 2013 22:45 Go to previous messageGo to next message
BlackSwan
Messages: 24462
Registered: January 2009
Senior Member
>I have installed Oracle 11gR2 on Window 7 (Home Basic).
No Oracle version is ever supported on any Windows Home Edition.
I don't know of anyone who has gotten V11 Oracle to work on Windows 7 Home edition.
Re: ORA-12560: TNS:protocol adapter error [message #575251 is a reply to message #575175] Mon, 21 January 2013 13:47 Go to previous messageGo to next message
ganesh_gvn
Messages: 33
Registered: February 2012
Location: PUNE
Member

Dear Rishwinger ,

I googled everything before posting above query.

But the issue not resolved. even as per your comment , "Edit environment variable tns_admin and point it to your tnsnames.ora file location" , i did it earlier but not working. Sad

I am confused here , why do I need listener as, I am trying to access database on same OS where database is residing . Sorry for my query but I am too confused.


Thanks ,
Ganesh
Re: ORA-12560: TNS:protocol adapter error [message #575252 is a reply to message #575251] Mon, 21 January 2013 13:51 Go to previous messageGo to next message
Michel Cadot
Messages: 62593
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You need to have a correct OS configuration, that is NOT a Home Edition.

Regards
Michel
Re: ORA-12560: TNS:protocol adapter error [message #575255 is a reply to message #575251] Mon, 21 January 2013 14:08 Go to previous messageGo to next message
Solomon Yakobson
Messages: 2332
Registered: January 2010
Location: Connecticut, USA
Senior Member
ganesh_gvn wrote on Mon, 21 January 2013 14:47
I googled everything before posting above query.


I seriously doubted.

ganesh_gvn wrote on Mon, 21 January 2013 14:47
even as per your comment , "Edit environment variable tns_admin and point it to your tnsnames.ora file location" , i did it earlier but not working.


That comment is pure nonsense. You are using local connection (/ as sysdba), so TNS is irrelevant. What is relevant is ORACLE environment. As a minimum when making a local connection you MUST have ORACLE_HOME and ORACLE_SID defined. And ORACLE_SID must point to a database you are trying to make connection to. Look what happens when ORACLE_SID points to non-existent database:

c:\TEMP>set ORACLE_SID=abc

c:\TEMP>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 21 15:05:41 2013

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: ^C
c:\TEMP>set ORACLE_SID=orcl

c:\TEMP>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 21 15:05:57 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

c:\TEMP>


And yo show it has nothing to do with TNS:

c:\TEMP>set TNS_ADMIN=abracadabra

c:\TEMP>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 21 15:07:45 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

c:\TEMP>


SY.
Re: ORA-12560: TNS:protocol adapter error [message #575259 is a reply to message #575255] Mon, 21 January 2013 15:00 Go to previous messageGo to next message
ganesh_gvn
Messages: 33
Registered: February 2012
Location: PUNE
Member

Thanks for the update Sir.
Re: ORA-12560: TNS:protocol adapter error [message #575261 is a reply to message #575259] Mon, 21 January 2013 15:05 Go to previous messageGo to next message
Solomon Yakobson
Messages: 2332
Registered: January 2010
Location: Connecticut, USA
Senior Member
ganesh_gvn wrote on Mon, 21 January 2013 16:00
Thanks for the update


Did it help?

SY.
Re: ORA-12560: TNS:protocol adapter error [message #575263 is a reply to message #575261] Mon, 21 January 2013 15:32 Go to previous messageGo to next message
ganesh_gvn
Messages: 33
Registered: February 2012
Location: PUNE
Member

SY Sir, I understood the above example.

In my case , I have to start the OracleService from services, then only I am able to work.
Re: ORA-12560: TNS:protocol adapter error [message #575264 is a reply to message #575263] Mon, 21 January 2013 15:46 Go to previous messageGo to next message
Solomon Yakobson
Messages: 2332
Registered: January 2010
Location: Connecticut, USA
Senior Member
This is OS specific behavior. If, for example, on Unix/Linus all you need is to start the database, Windows is different. You MUST start service, otherwise you will get ORA-12560.

SY.
Re: ORA-12560: TNS:protocol adapter error [message #642568 is a reply to message #575165] Mon, 14 September 2015 10:42 Go to previous messageGo to next message
maniit2k7@gmail.com
Messages: 1
Registered: September 2015
Location: Chennai
Junior Member
I still get the same error, when I tried to surf I found some service needs to be started, but the same was not found in my services.msc.

Regarding Oracle I have only the TNS services.

Error: ORA-12560: TNS:protocol adapter error

Can someone help me with some suggestion.
  • Attachment: ORA.PNG
    (Size: 18.42KB, Downloaded 260 times)
Re: ORA-12560: TNS:protocol adapter error [message #642571 is a reply to message #642568] Mon, 14 September 2015 11:16 Go to previous message
EdStevens
Messages: 555
Registered: September 2013
Senior Member
maniit2k7@gmail.com wrote on Mon, 14 September 2015 10:42
I still get the same error, when I tried to surf I found some service needs to be started, but the same was not found in my services.msc.

Regarding Oracle I have only the TNS services.

Error: ORA-12560: TNS:protocol adapter error

Can someone help me with some suggestion.


Thank you for hijacking someone else's old thread.

It appears that you only installed the oracle client, not the dbms. You have no database to connect to.
Further, the tiny little screen shot (I had to get out the magnifying glass) seems to show that you didn't expand the column with the name of the service, thus hiding valuable information.

[Updated on: Mon, 14 September 2015 11:18]

Report message to a moderator

Previous Topic: Windows 10 / DB12.x
Next Topic: Oracle 12c 64bit and client32 on the same machine
Goto Forum:
  


Current Time: Mon Feb 08 14:02:32 CST 2016

Total time taken to generate the page: 0.12323 seconds