Home » SQL & PL/SQL » Client Tools » connectivity problem to sqlplus
connectivity problem to sqlplus [message #550113] Fri, 06 April 2012 02:27 Go to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
hello experts,
i have a problem please guide me, when i try to connect with a database which is on another machine , through the sqlplus editor then it throws an error-12560-protocol adapter error.
but when i try to connect through toad then ,i get connected . what is the problem behind it please tell me.and i am using 11g version 11.2.0.1.0, thanx in advance.

[Updated on: Fri, 06 April 2012 02:35]

Report message to a moderator

Re: connectivity problem to sqlplus [message #550115 is a reply to message #550113] Fri, 06 April 2012 02:35 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Show us what you did.

Regards
Michel
Re: connectivity problem to sqlplus [message #550119 is a reply to message #550115] Fri, 06 April 2012 02:48 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
sqlplus
-------
enter username: scott
password: tiger
ora-12560-protocol adapter error.

but there is no problem with toad , successfully connected.

Re: connectivity problem to sqlplus [message #550121 is a reply to message #550119] Fri, 06 April 2012 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you tried to connect to a LOCAL database and not a remote one hence the error.

Regards
Michel
Re: connectivity problem to sqlplus [message #550125 is a reply to message #550121] Fri, 06 April 2012 03:36 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thank you sir,
then how should i connect to remeote database through sqlplus . i dont have local database and how did you feel that i am trying to connect my local database? is there anything missing in my above statement?
Re: connectivity problem to sqlplus [message #550130 is a reply to message #550125] Fri, 06 April 2012 04:02 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
is there anything missing in my above statement?

Yes, there should be a service name pointing to your local database:
connect scott/tiger@remotedb
or
enter username: scott@remotedb
password: tiger

Regards
Michel
Re: connectivity problem to sqlplus [message #550132 is a reply to message #550125] Fri, 06 April 2012 04:03 Go to previous messageGo to next message
John Watson
Messages: 7215
Registered: January 2010
Location: Global Village
Senior Member
c:\users\john\home>sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Fri Apr 6 10:01:53 2012

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

SP2-0640: Not connected
> conn scott/tiger
ERROR:
ORA-12560: TNS:protocol adapter error


> conn scott/tiger@orcl
Connected.

Session altered.

orcl>
Re: connectivity problem to sqlplus [message #550135 is a reply to message #550132] Fri, 06 April 2012 04:14 Go to previous message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
ok thank you very much sir Michel and john.
problem is resolved.
Previous Topic: TO_DATE FORMAT
Next Topic: Compilation Errors in TOAD
Goto Forum:
  


Current Time: Thu Jan 18 09:00:34 CST 2018

Total time taken to generate the page: 0.04323 seconds