Friday, 21 April 2017

IO Error: Got minus one from a read call vendor code 17002

When we are trying to connect database by using Sql developer, we got below error.

Error:

IO Error: Got minus one from a read call vendor code 17002





















Fix:

You can follow these steps to avoid the error:

  1. Go to directory $ORACLE_HOME/network/admin
  2. Make sure you have backup of sqlnet.ora
  3. Modify sqlnet.ora file with the parameter: (tcp.validnode_checking = no)
  4. If you don't want to disable this, you can put the machine names as follows:  tcp.invited_nodes=(machine1, machine2)
  5. Bounce the listener or reload the listner (lsnrctl reload)

No comments:

Post a Comment