Home » Other » Client Tools » running client sqlplus (win7)
running client sqlplus [message #567057] Sun, 23 September 2012 18:28 Go to next message
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...
Re: running client sqlplus [message #567058 is a reply to message #567057] Sun, 23 September 2012 19:23 Go to previous messageGo to next message
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
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?


Re: running client sqlplus [message #567059 is a reply to message #567058] Sun, 23 September 2012 19:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
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: 
Re: running client sqlplus [message #567063 is a reply to message #567057] Sun, 23 September 2012 23:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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
Re: running client sqlplus [message #567090 is a reply to message #567058] Mon, 24 September 2012 03:21 Go to previous messageGo to next message
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
Re: running client sqlplus [message #567093 is a reply to message #567090] Mon, 24 September 2012 03:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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 Go to previous messageGo to next message
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?
Re: running client sqlplus [message #567098 is a reply to message #567095] Mon, 24 September 2012 03:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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 Go to previous messageGo to next message
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



Re: running client sqlplus [message #567100 is a reply to message #567099] Mon, 24 September 2012 03:51 Go to previous message
Michel Cadot
Messages: 68625
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:
  


Current Time: Thu Mar 28 17:05:30 CDT 2024