| 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: 1398
Registered: January 2010
|
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.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
