status failure - test failed io error got minus one from a read call SQL Developer

Error Description 

status failure - test failed io error got minus one from a read call, while connecting to Oracle EBS Database from SQL Developer

b2ap3_thumbnail_oracle_sqldeveloper_error.jpg

Root Cause of the Issue

SQL Net is not allowing connections to the database because of the setting 'tcp.validate_node' is set as 'yes'.

Resolution

1. Open sqlnet.ora

2. Change the setting to:

tcp.validate_node = no

3. Now try reconnecting to the database from SQL Developer and you should be able to connect it successfully this time.

Environment

  • Operating System = Oracle Linix
  • Oracle E-Business Suite Release 12.2.4
Oracle EBS > Diagnostics > Examine gives error Fun...
ORA-04023: Object alter view, ERROR at line 1: