OraFAQ Forum: Client Tools » connectivity problem to sqlplus

Home » Other » Client Tools » connectivity problem to sqlplus

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

connectivity problem to sqlplus [message #550113]

Fri, 06 April 2012 02:27

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Show us what you did.

Regards
Michel

Report message to a moderator

Re: connectivity problem to sqlplus [message #550119 is a reply to message #550115]

Fri, 06 April 2012 02:48

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.

Report message to a moderator

Re: connectivity problem to sqlplus [message #550121 is a reply to message #550119]

Fri, 06 April 2012 03:19

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So you tried to connect to a LOCAL database and not a remote one hence the error.

Regards
Michel

Report message to a moderator

Re: connectivity problem to sqlplus [message #550125 is a reply to message #550121]

Fri, 06 April 2012 03:36

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?

Report message to a moderator

Re: connectivity problem to sqlplus [message #550130 is a reply to message #550125]

Fri, 06 April 2012 04:02

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: connectivity problem to sqlplus [message #550132 is a reply to message #550125]

Fri, 06 April 2012 04:03

John Watson
Messages: 8964
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>

Report message to a moderator

Re: connectivity problem to sqlplus [message #550135 is a reply to message #550132]

Fri, 06 April 2012 04:14

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

ok thank you very much sir Michel and john.
problem is resolved.

Report message to a moderator

Previous Topic:	TO_DATE FORMAT
Next Topic:	Compilation Errors in TOAD

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 17:26:06 CST 2025