12 Replies Latest reply on May 7, 2016 11:25 PM by K Brown

    Receiving "IO ERROR: Got minus one from a read call" when connecting to DB

    K Brown

      We have 2 12.1.0.2 databases running on the RAC cluster rac-clust.  One (rac2db) is a 2 node RAC running on db1 and db2 and is admin-managed.  The second (rac1db) is a single-node RAC running on db2 and is also admin-managed.  Both databases are identical with the exception of the number of utilized nodes.  I am able to successfully connect to rac2db from our 4.0.3 SQL*Developer installation with the following credentials:

      HOST: db2

      PORT: 1521

      SID:rac2db2

      * Connect

       

      When I use the same credentials, but change the SID to match the single node installation, I get the IO ERROR.... error

      HOST: db2

      PORT: 1521

      SID:rac1db1

      *IO ERROR: Got minus one from a read call  Vendor code 17002.

       

      I have checked all of our sqlnet.ora files and have verified that none of them have TCP.VALIDNODE_CHECKING set.

       

      Using TNSNAMES.ORA, I am able to connect remotely to both of these databases.  The server that is running SQL*Developer does not have a tnsnames.ora installation, though, so we must use the basic connect string to connect.  I tried using the jdbc connection URL and received the same results as the basic connect.

       

      Please let me know if additional information is needed.

       

      Cheers