| ORA-12560: TNS:protocol adapter error [message #575165] |
Sun, 20 January 2013 16:36  |
|
|
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 #575251 is a reply to message #575175] |
Mon, 21 January 2013 13:47  |
|
|
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. 
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 #575255 is a reply to message #575251] |
Mon, 21 January 2013 14:08 |
Solomon Yakobson
Messages: 3303
Registered: January 2010
Location: Connecticut, USA
|
Senior Member |
|
|
ganesh_gvn wrote on Mon, 21 January 2013 14:47I googled everything before posting above query.
I seriously doubted.
ganesh_gvn wrote on Mon, 21 January 2013 14:47even 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 #642571 is a reply to message #642568] |
Mon, 14 September 2015 11:16 |
 |
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
maniit2k7@gmail.com wrote on Mon, 14 September 2015 10:42I 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
