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: 28
Registered: February 2012
Location: PUNE
Junior 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: 22703
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: 28
Registered: February 2012
Location: PUNE
Junior 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: 58902
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: 1998
Registered: January 2010
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: 28
Registered: February 2012
Location: PUNE
Junior 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: 1998
Registered: January 2010
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: 28
Registered: February 2012
Location: PUNE
Junior 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 message
Solomon Yakobson
Messages: 1998
Registered: January 2010
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.
Previous Topic: ODP 10 for .net 2.0 Silent Installation and ODBC trouble
Next Topic: need hummingbird exceed software for windows?
Goto Forum:
  


Current Time: Wed Aug 27 06:25:21 CDT 2014

Total time taken to generate the page: 0.17816 seconds