0 Replies Latest reply on Sep 29, 2011 2:47 PM by CodePixie

    client connectivity problem

      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.