This discussion is archived
0 Replies Latest reply: Sep 29, 2011 7:47 AM by CodePixie RSS

client connectivity problem

CodePixie Newbie
Currently Being Moderated
Hi -

We have an 11g database which we cannot use from any client terminal.

The connection to the database itself is fine (using eg SQLPlus) and we can run the following queries without problem:

select count(*) from table1

select * from table1 where identifier =1


However, we cannot run the following (or anything more complex):

select * from table1 where identifier <=2

Any attempt just causes the client to hang, finally returning

IO Error: Socket
Vendor code 17002Error


I have tested installation of a client on a virtual server hosted in the same environment as the oracle server, and this is fine. What could be causing this problem?

Many thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points