OraFAQ Forum: Client Tools » running client sqlplus

Home » SQL & PL/SQL » Client Tools » running client sqlplus (win7)

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

running client sqlplus [message #567057]

Sun, 23 September 2012 18:28

viewer
Messages: 4
Registered: September 2012
Location: Turkey

Junior Member

hello for everyone......
i am so newbie at forum......

i have oracle on suse linux server....
i want to connect it from my win7 notebook with sqlplus...
i downloaded client.zip and installed it....
everything seems normal....
but when i try to connect.....
i get ora-12560 error...
my tnsname and listener files regular...
there is no foreign characters....

what mistake i make?
anyone can say it?

best regards...

Report message to a moderator

Re: running client sqlplus [message #567058 is a reply to message #567057]

Sun, 23 September 2012 19:23

Andrey_R
Messages: 137
Registered: January 2012
Location: Euro-Asia

Senior Member

Hi Viewer,
You can try to understand what's wrong by the stages:

In the Windows machine:

I would check your TNS_ADMIN environment variable,
Make sure it is set to the folder containing TNSNAMES.ORA file.

on Linux Machine:

I would also check the listener by "lsnrctl status"

after doing both, any change?

Report message to a moderator

Re: running client sqlplus [message #567059 is a reply to message #567058]

Sun, 23 September 2012 19:30

BlackSwan
Messages: 20088
Registered: January 2009

Senior Member

>i get ora-12560 error...
ORA-12560 means that no packets ever left client; so what exists or does not exist on DB Server is 100% irrelevant to resolve this error.
ORA-12560 can result from a myriad of different causes.
From what URL did you obtain client.zip?
use COPY & PASTE then do the same as below

[oracle@localhost sql]$ sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Sun Sep 23 17:11:53 2012

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

Enter user-name:

Report message to a moderator

Re: running client sqlplus [message #567063 is a reply to message #567057]

Sun, 23 September 2012 23:50

Michel Cadot
Messages: 54145
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-12560: TNS:protocol adapter error
 *Cause: A generic protocol adapter error occurred.
 *Action: Check addresses used for proper protocol specification. Before
 reporting this error, look at the error stack and check for lower level
 transport errors. For further details, turn on tracing and reexecute the
 operation. Turn off tracing when the operation is complete.

Regards
Michel

Report message to a moderator

Re: running client sqlplus [message #567090 is a reply to message #567058]

Mon, 24 September 2012 03:21

viewer
Messages: 4
Registered: September 2012
Location: Turkey

Junior Member

thanks Andrey_R

my client system is win7, oracle is 11.2.0 client and server side is suse e and 11.2.0

but what is TNS_ADMIN? and where i will use it?
i understood, where i will describe it and what it contains...
but how i will use it?

best regards

Report message to a moderator

Re: running client sqlplus [message #567093 is a reply to message #567090]

Mon, 24 September 2012 03:26

Michel Cadot
Messages: 54145
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post (copy and paste inline no image) the result of :

set
tnsping xxx
sqlplus user/psw@xxx

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

[Updated on: Mon, 24 September 2012 03:35]

Report message to a moderator

Re: running client sqlplus [message #567095 is a reply to message #567058]

Mon, 24 September 2012 03:29

viewer
Messages: 4
Registered: September 2012
Location: Turkey

Junior Member

thanks BlackSwan

my client system can not send any package to server side..i understood correct?
i downloaded zip files from oracle.com and version 11.2.0 ....
serverside is 11.2.0 too.......

your screen comes but i can not pass next step...
what i will copy&paste?

Report message to a moderator

Re: running client sqlplus [message #567098 is a reply to message #567095]

Mon, 24 September 2012 03:34

Michel Cadot
Messages: 54145
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 24 September 2012 10:26

Post (copy and paste inline no image) the result of :
set
tnsping xxx
sqlplus user/psw@xxx
Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

[Updated on: Mon, 24 September 2012 03:35]

Report message to a moderator

Re: running client sqlplus [message #567099 is a reply to message #567063]

Mon, 24 September 2012 03:36

viewer
Messages: 4
Registered: September 2012
Location: Turkey

Junior Member

thanks Michel Cadot;

i checked.....
i can connect server with ssh and vnc....
i can run sql*plus at server and can do everything
there is no problem....

i checked ..there is no tracing and routing problems...
1521 port is open at both sides....
i think, i a mistake at client side

Report message to a moderator

Re: running client sqlplus [message #567100 is a reply to message #567099]

Mon, 24 September 2012 03:51

Michel Cadot
Messages: 54145
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post what I asked, from the client, no other comment for the moment, I don't care about them, they are just shoot in the dark.

Regards
Michel

[Updated on: Mon, 24 September 2012 03:51]

Report message to a moderator

Previous Topic:	auto optimizer stats collection
Next Topic:	How to execute this Function in Toad (2 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 12:04:41 CDT 2013

Total time taken to generate the page: 0.11511 seconds